May 2013 archive

Howto run expdp with data compression in Oracle 10g and 11g

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 …

Continue reading

Howto force password for sysdba user access

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" …

Continue reading

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 …

Continue reading

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, …

Continue reading

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 …

Continue reading