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

May 23

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

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