Oct 01

Restricting oracle Username using Trigger

One of the important tasks that the DBA has is to keep organized and controlled the schemas that exist in the database. Some companies have a standard nomenclature for its employees and service providers usernames and to avoid the creation of wrong logins, you can make a process to force an username pattern. To accomplish …

Continue reading

Sep 13

ORA-01917 “RECOVERY_CATALOG_USER” error while upgrading RMAN catalog

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading