That’s Me

Gavin Soorma
  • Oracle Certified Professional
    • 7.3, 8i, 9i,10g, 11g
  • 11i Apps DBA OCP
    •
  • 10g RAC OCE
    •
  • Certified GoldenGate Implementation Specialist
    •
  • 10g OCM
    •
  • 11g OCM
    •

    Feedback

    1,650,000 hits

    Thanks A MILLION for your support!

    Please send me your valuable feedback and suggestions

    11gR2 RAC installation and the ORA-15014 error

    In 11g Release 2, we now have to place the Voting Disk and Cluster Registry files on ASM disks and we do not have the option of placing them on OCFS or raw devices as in the case of previous versions.

    When you run the root.sh script as part of the 11gR2 RAC installation, it will create an ASM disk group CDATA and will place the OCR and Voting disk files on this ASM disk. We provide an ASM disk discovery string where the raw devices exist on which the ASM disk groups will be built.

    Initially we had provided the ASM diskstring as /dev/ocr_disk* as this was where we wanted to place the OCR and Vote files. But when we tried to change this to create another ASM disk group, we kept getting these ORA-15031 and ORA-15014 errors.

    We had to change the asm_diskstring parameter to include both the paths

    Continue reading 11gR2 RAC installation and the ORA-15014 error

    May 28th, 2010 | Tags: , , | Category: Administration, Oracle 11g release 2, Real Application Clusters | Leave a comment

    ORA-29701 after IP address change and overcoming the SIHA ORA-29787 error on SPFILE creation

    I had recently installed 11g Release 2 Grid Infrastructure for a single instance on a RHEL 5 virtual machine set up using VMware server and after I changed the IP address for one of the NIC’s (eth0) I started getting ORA-29701 errors whenever I issued the crsctl check command as well as when I tried to start the ASM instance as shown below.

    SQL> startup;
    ORA-01078: failure in processing system parameters
    ORA-29701: unable to connect to Cluster Synchronization Service

    These are the steps I had to take to overcome the problem – basically it is recreating the Oracle High Availability Services and updating the cluster registry with all the infomation about the resources which were originally configured.

    [root@gavin install]# ./roothas.pl -deconfig
    2010-05-20 12:49:48: Checking for super user privileges
    2010-05-20 12:49:48: User has super user privileges
    2010-05-20 12:49:48: Parsing the host name
    Using configuration parameter file: ./crsconfig_params
    CRS resources for listeners are still configured
    CRS-2730: Resource ‘ora.asm’ depends on resource ‘ora.cssd’
    CRS-4000:

    Continue reading ORA-29701 after IP address change and overcoming the SIHA ORA-29787 error on SPFILE creation

    May 28th, 2010 | Tags: , , | Category: Administration, Oracle 11g release 2 | Leave a comment