In many situations, the DBA is faced with the scenario where many company teams end up having access to the root password of the machine where Oracle is installed. These teams are usually the Infrastructure, the Backup, the Deployment, etc.. In this case, it is very easy to root user run a "su - oracle" …
May 22
Changing AUDIT tablespace and create a purge job in 11g
Oracle Database 11g comes with some audit options turned on by default, which over time can exhaust the SYSTEM tablespace without the DBA knowledge. However, this same version of database now offers some DBMS packages that can greatly facilitate the life of the administrator who wants to migrate audit to another tablespace or change the …
May 20
Howto upgrade Oracle Database 11.2.0.3 to PSU 6
In this article, we will update a newly installed version of non-RAC Oracle Database 11.2.0.3, running Linux X86_64 to the Patch Set Update 6 (11.2.0.3.6), dated April/2013. For this, we need to download the following packages from Oracle's website: p16056266_112030_Linux-x86-64.zip -> PSU 6 p6880880_112000_Linux-x86-64.zip -> Latest version of OPatch After transfering the files to the server, …
May 17
Howto install oracle-validated RPM in Red Hat el5
The oracle-validated RPM package already does all the arrangements for you of dependencies during the installation of Oracle in an Enterprise Linux 5. However, the latest versions of this package have been demanding as a prerequisite the uek-kernel, which limited the installation only in Oracle Linux 5 distribution. In this topic, we will learn how …
May 16
Howto setup a new database target on Oracle EM 12c Cloud Control
In this post, we will make Oracle EM 12c monitor a new target (in which case it will be a Oracle Database non-RAC). In this example, we are dealing with an Oracle 11gR2 single instance database running on a Linux x86_64. The steps to be performed are: Configure the Linux OS of the database to …
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
