These days, I needed to register a new database that was running at 12c on my RMAN catalog. The procedure that I tried was the same as I had done before hundreds of times with DBs in all versions. When I connected, RMAN complained that the version of the catalog was outdated, as expected: [oracle@brocbddtrj001 …
Aug 07
Setup VNCR in Oracle RAC
Enabling VNCR (Valid Node Checking for Registration) is a mandatory task that every DBA should do when terminates the configuration of a new database, being it a Single Instance or a Oracle RAC. In my opinion, Oracle should have already defined this option enabled by default on new releases. In times of TNS Poison (Oracle Security …
Aug 03
Howto upgrade Oracle EM 12c with Database Vault enabled
In recent days, I updated the EM 12c release 12.1.0.3.0 to 12.1.0.4.0. However, the database where the repository was placed had Oracle Database Vault enabled and I was not even allowed to temporarily disable it during the upgrade (security policy of the company). The best way to have proceeded with the installation without facing problems would be shutting …
May 08
Howto repoint your Oracle Management Agent to a different OEM 12c Server
Maybe one day you might face a situation where you lose, change or reinstall your Oracle EM 12c Server and if you do so, you won't need to reinstall all the OMS agents running on your client hosts. All you need is to create a new instance of the agent inside each of your client hosts …
Mar 25
Howto solve Session waiting SQL*Net from/to DBLink forever
In large corporations, it is still common to find several different Oracle versions (9i, 10g and 11g) communicating with each other. Among some of them, the Oracle Compatibility Matrix alerts that some error may occurs. Even so, the DBA still creates the database link with the impression that will always work. If we analyze the …
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
