Loading...

Follow DBA – Rodrigo Jorge – Oracle Dicas e Guias on Feedspot


Valid
or
Continue with Google
Continue with Facebook

Since Oct-2017 I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. So what oracle internal objects were changed in 180417? [crayon-5af453f6a3e86612854442/] And created? [crayon-5af453f6a3e9b695438067/] P.S: Nothing was added or changed for 11.2.0.4 in Oracle objects, that's why its …

The post Dissecting 180417 BP, PSU, RU and RUR appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

After some delay, Oracle finally released in the end of April the First RUR for 12.2.0.1 Jan-2018 RU. The original release date for this RUR was April 17, 2018 but it was only really available around April 30, 2018. The problem is that because of this delay something get internally messed and instead of using …

The post Oracle 12.2.0.1 JAN2018 RUR - 180417 or 180411 ? appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

After applying the 180417 PSU and BP over 12.1.0.2 Database, I've noted 2 new packages created on the database: DBMS_ASH and DBMS_BDSQL. [crayon-5ae0a32b39e73795791932/] * Note DBMS_ASH Package Body was not created by the PSU, only by the BP. Probably this was a bug or something still under development. DBMS_ASH: [crayon-5ae0a32b39e8e502824865/] DBMS_BDSQL: [crayon-5ae0a32b39eaa858016336/] Both packages are …

The post New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

For a long time I had a problem in my VirtualBox 5.x when I need to run heavy oracle database process and it crashed not only the VM but my role macOS forcing my MacBook Pro to reboot with the following error message: After it returns, as soon as I log in I could see …

The post Fixing VirtualBox crashing macOS on high load (Kernel Panic) appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In this article, I will show you in details how to create the new released 18c Oracle Database on Oracle Cloud Infrastructure Classic. 1. Creating Trial Account Go to cloud.oracle.com and click on right up corner in “Try for Free“. In the new opened page, click on “Create a Free Account“. In this page you …

The post Creating Oracle 18c Database in OCI Classic appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In my previous post I showed how to install the Oracle 18c Exadata binaries in a Oracle Linux 7. Next step is to create and run a database in this environment. Note that this is intended for study only and test the amazing new features of 18c, following this article can make you probably face …

The post Creating and running an Oracle 18.0.0.0.0 DB instance on Oracle Linux appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In this article I will describe how to install the very first available release of Oracle Database 18c (18.0.0.0.0) binaries on Oracle Linux 7.2. Even though it’s not officially released for on-premises yet (only Oracle Cloud), in edelivery it is available an Exadata DB version that is compatible with your local machine running OL. Use it for …

The post Installing Oracle Database 18.0.0.0.0 binaries on Oracle Linux 7 appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Since last quarter of 2016, a very easy to explore SQL Injection came to public where having a combination CREATE SESSION + EXECUTE_CATALOG_ROLE, an user could escalate his privileges to DBA. The first time I’ve read about this leak was on Mahmoud Hatem blog. This SQL Injection affects 12.1.0.2 and 12.2.0.1 when the user has this …

The post SQL Injection on 12c CBVIEW package finally fixed on 180116 appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Since Oct-2017 I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. So what oracle internal objects were changed in 180116? [crayon-5a699748dd162684604602/] And created? [crayon-5a699748dd177679083581/] So which are exactly the objects modified by 180116? [crayon-5a699748dd181994531116/] What changed for each? …

The post Dissecting 180116 BP, PSU, RU and RUR appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

One of the biggest problemas we have in Oracle Cloud Infrastructure Classic is that when you provision an ExaCS you cannot assign “IP Network” addresses (as known as private IPs, eg: 10.x.x.x) to your ExaCS machine. That being said, you have only 2 options if you want to communicate your applications in Compute Classic (as …

The post Implementing Oracle Connection Manager with High Availability appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview