Loading...

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

Continue with Google
Continue with Facebook
or

Valid

On the last year, I've been working for a customer that uses one of the Oracle OCI regions as his primary DC and the other as a Standby environment. As they are pretty identical regarding the routes and network access rules, I needed to constantly get their Standby region in sync with the primary regarding …

The post Cloning Security List Rules among different SLs in OCI appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

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

Those days, I needed to recreate a Load Balancer in Oracle Cloud Infrastructure for a specific reason. It was a private Load Balancer. The problem is that when you create a Load Balancer, you can't specify the Private IP address in the Subnet that you want to use.. Oracle will pick automatically 3 IPs from …

The post Force a private IP during Load Balancer creation in OCI appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

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

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

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

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

Those days I was trying to retrieve some OCI Json data using REST calls via curl. However, even though I've set up an application and Client ID and Secret accordingly, I was getting the error below: [crayon-5c5aea112ed50149178740/] "Cannot obtain Certificate. Verify Access Signing Certificate in Settings" Than I realize that there is an option under …

The post "Verify Access Signing Certificate in Settings" in OCI when running curl REST calls appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

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

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. To check previous changes, follow the links below: Dissecting 181016 BP, PSU, RU and RUR Dissecting 180717 BP, PSU, RU and RUR Dissecting 180417 BP, PSU, RU and RUR …

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

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

In this article, I will show how it is extremely simple to inject a hidden rootkit inside an Oracle database PL/SQL object (like a procedure) making it very hard to detect for almost all DBA's and Security Admins. It's important to understand and know how those virus works so we can always be prepared to …

The post Injecting a simple dbakit (or rootkit) in Oracle PL/SQL objects appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article
  • 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 October 2018 - 181016? [crayon-5bfd070c5895d704156992/] And created? [crayon-5bfd070c58970564221670/] P.S: Nothing was added for 11.2.0.4 / 12.2.0.1 in Oracle objects. …

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

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

In the Oracle Open World 2018 event that happened in San Francisco last week, from October 22nd to 25th, much has been said about the trends and strategy paths that Oracle is taking in both OCI and in Oracle Database. As we DBA's are always excited about the upcoming features, I will share below some …

The post The best upcoming features in Oracle Database 19c appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

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

As of today (October 2018), there is still no internal capability in Oracle Cloud Infrastructure to backup the metadata of all the objects you have (like computes, volumes, network, users, etc). This would be indeed a great feature and prefer to believe that Oracle is working to deploy it. Meanwhile, I have some customers that …

The post Howto backup Oracle Cloud Infrastructure metadata appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

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

Creating a read-only user for OCI access is useful if you want to give your auditors or external providers only read privileges on all your Infrastructure resources or if you want to run oci-cli tool in a secure mode, with guarantee that no changes will happen in your Oracle Cloud Infrastructure. In this article I …

The post Creating a read-only user in Oracle Cloud Infrastructure appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides.

Read Full Article

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