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

Jul 09

Oracle RAC in VMWare hangs with ORA-27072: File I/O error

During three months, I have had constant problems of an Oracle RAC installation suddenly hanging. The system was as follows: O.S: Red Hat Enterprise Linux Server release 5.8 (Tikanga) - x86_64 Kernel: 2.6.18-308.16.1.el5 VMWare: VMware ESXi 5.0 Oracle 11.2.0.3 PSU 6 Oracle homes in different drives and shared disks for RAC via VMFS It was …

Continue reading

Jun 20

Moving OCR and Voting Disk to Oracle ASM Online

Prior Oracle 11gR2, it was only possible to the OCR and Voting Disk files in multiple raw devices, shared between the nodes of a cluster. From this version on, it's very interesting to take the advantages and capabilities of ASM (striping and mirror) to store those files. To store the OCR and Voting Disk files …

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