May 29
Many people are still reluctant to use the Oracle export Data Pump (expdp) in 10g because there is no effective method of compression via pipe as there is in simple export command (exp). Starting in version 11g, Oracle added the parameter "COMPRESS=ALL" that helps in compressing the dump file generated, but still uses the internal …
May 23
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
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
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
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 …
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
