Category: Oracle Database General

Oracle Database General

Aug 13

Howto upgrade Oracle Grid 11g to 11.2.0.3

In this article we will upgrade a database running on Oracle RAC version 11.2.0.1 to version 11.2.0.3. The steps to upgrade from the version 11.2.0.2 are very similar, only changing the dependent packages and patches. Our RAC database is running on a Red Hat, with the following specifications: O.S: Red Hat Enterprise Linux Server release …

Continue reading

Aug 12

Howto upgrade Oracle Grid 11.2.0.3 to PSU 7

In this article, we will update a newly installed version of Oracle Grid and Database 11.2.0.3, running on Linux X86_64 (RAC) for the Patch Set Update 7 (11.2.0.3.7), dated July/2013. For this, we need to download the following packages from Oracle Metalink website: p16742216_112030_Linux-x86-64.zip -> PSU 7 p6880880_112000_Linux-x86-64.zip -> Latest OPatch version After uploading the …

Continue reading

May 29

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

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 …

Continue reading

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

Continue reading