Sep 20

Finding Oracle users with DBA privilege hidden by roles

Some users in Oracle may have very dangerous privileges without your consent, they can cause great damage to the database. Sometimes this privilege is hidden via a chain of roles, which makes it difficult to perception. Eg: SQL> CREATE USER SYSADM identified by “sysadm1”; SQL> CREATE ROLE A; SQL> CREATE ROLE B; SQL> CREATE ROLE …

Continue reading

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