Oct 22

OCM 11g Preparation – Recommended Hardware

As we will need to create RAC, Dataguard, Single Instance and Oracle EM machines scenarios, let’s consider a scenario where we will need to simulate 4 VMs running at the same time. To this work in your system, you will need at least: 16 GB RAM Quad core fast CPU (Something similar or better than a Core i5) …

Continue reading

Oct 07

Retrieve oracle sysdba audit from table

Oracle will always generate audit files for some SYSDBA operations in audit_file_dest, no matter what you do. As Doc ID 1528170.1, “Some auditing of SYSDBA is mandatory and cannot be disabled (STARTUP, SHUTDOWN, and CONNECT).” If audit_sys_operations is currently set to TRUE, many files will be created in audit_file_dest by SYSDBA user activity. In this …

Continue reading

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