Oct 22
As we have many situations to deal with in the topics, my recommendation is creating 6 VMs using Virtualbox: Oracle Single Instance Oracle Enterprise Manager Oracle RAC Node 1 Oracle RAC Node 2 Oracle DG RAC Node 1 Oracle DG RAC Node 2 I won't show here how to create an VirtualBox and install Oracle Linux …
Oct 22
The exam environment keep changing over the time and I believe that Oracle will soon update the Linux and Database release to the latest. As Oct/2014, the exam environment in official OCM website is the following: Exam Environment Oracle Linux Release 5.4 (32-bit) Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 (32-bit) Oracle Enterprise Manager 11g Grid …
Oct 22
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) …
Oct 07
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 …
Oct 01
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 …
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
