6 Replies Latest reply: Sep 30, 2012 1:20 AM by 964640 RSS

    11g Rel2 RAC Database prerequisites Failed

    964640
      Hi experts,

      I successfully installed clusterwares in 2 nodes but when i installled Oracle 11g Rel 2 (11.2.0.1) RAC database in
      Oracle linux 5.4 64bit, all the prerequisites are failed. I dont understand why all the prerequisties are failed,

      Both nodes are working fine, i used all basics command to check the clusters, but why the database installation

      prerequisties are failed.

      Kindly help me regarding this issue.

      Regards.
      shahzad
        • 1. Re: 11g Rel2 RAC Database prerequisites Failed
          rajeysh
          could you post the output of

          crsctl status resource -t

          also

          cluvfy stage -post crsinst -n node1_name,node2_name,othernodes_if_you_have -n verbose


          olsnodes -n

          also post the error message/failed prerequisites while creating database
          • 2. Re: 11g Rel2 RAC Database prerequisites Failed
            964640
            crsctl status resource -t


            [grid@erprac1 ~]$ crsctl status resource -t
            --------------------------------------------------------------------------------
            NAME TARGET STATE SERVER STATE_DETAILS
            --------------------------------------------------------------------------------
            Local Resources
            --------------------------------------------------------------------------------
            ora.ACFS.dg
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.DATA.dg
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.FRA.dg
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.LISTENER.lsnr
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.acfs.dbhome_1.acfs
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.asm
            ONLINE ONLINE erprac1 Started
            ONLINE ONLINE erprac2 Started
            ora.eons
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.gsd
            OFFLINE OFFLINE erprac1
            OFFLINE OFFLINE erprac2
            ora.net1.network
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.ons
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            ora.registry.acfs
            ONLINE ONLINE erprac1
            ONLINE ONLINE erprac2
            --------------------------------------------------------------------------------
            Cluster Resources
            --------------------------------------------------------------------------------
            ora.LISTENER_SCAN1.lsnr
            1 ONLINE ONLINE erprac2
            ora.erprac1.vip
            1 ONLINE ONLINE erprac1
            ora.erprac2.vip
            1 ONLINE ONLINE erprac2
            ora.oc4j
            1 OFFLINE OFFLINE
            ora.orcl.db
            1 ONLINE OFFLINE
            2 ONLINE OFFLINE
            ora.scan1.vip
            1 ONLINE ONLINE erprac2

            [grid@erprac1 ~]$ olsnodes -n
            erprac1 1
            erprac2 2
            [grid@erprac1 grid]$ ./runcluvfy.sh stage -post crsinst -n erprac1,erprac2-verbose

            Performing post-checks for cluster services setup

            Checking node reachability...
            Node reachability check failed from node "erprac1"
            Check failed on nodes:
            erprac2-verbose


            WARNING:
            These nodes cannot be reached:
            erprac2-verbose
            Verification will proceed with nodes:
            erprac1

            Checking user equivalence...
            User equivalence check passed for user "grid"
            Checking time zone consistency...
            Time zone consistency check passed.


            Checking Cluster manager integrity...

            Checking CSS daemon...
            Oracle Cluster Synchronization Services appear to be online.

            Cluster manager integrity check passed


            UDev attributes check for OCR locations started...
            UDev attributes check passed for OCR locations


            UDev attributes check for Voting Disk locations started...
            UDev attributes check passed for Voting Disk locations

            Default user file creation mask check passed

            Checking cluster integrity...


            Cluster integrity check passed


            Checking OCR integrity...

            Checking the absence of a non-clustered configuration...
            All nodes free of non-clustered, local-only configurations


            ASM Running check passed. ASM is running on all cluster nodes

            Checking OCR config file "/etc/oracle/ocr.loc"...

            OCR config file "/etc/oracle/ocr.loc" check successful


            Disk group for ocr location "+DATA" available on all the nodes


            Checking size of the OCR location "+DATA" ...

            Size check for OCR location "+DATA" successful...

            WARNING:
            This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

            OCR integrity check passed

            Checking CRS integrity...

            CRS integrity check passed

            Checking node application existence...

            Checking existence of VIP node application (required)
            Check passed.

            Checking existence of ONS node application (optional)
            Check passed.

            Checking existence of GSD node application (optional)
            Check ignored.

            Checking existence of EONS node application (optional)
            Check passed.

            Checking existence of NETWORK node application (optional)
            Check passed.


            Checking Single Client Access Name (SCAN)...

            Checking name resolution setup for "racnode-cluster-scan"...

            Verification of SCAN VIP and Listener setup passed
            OCR detected on ASM. Running ACFS Integrity checks...

            Starting check to see if ASM is running on all cluster nodes...

            ASM Running check passed. ASM is running on all cluster nodes

            Starting Disk Groups check to see if at least one Disk Group configured...
            Disk Group Check passed. At least one Disk Group configured

            Task ACFS Integrity check passed

            Checking Oracle Cluster Voting Disk configuration...

            Oracle Cluster Voting Disk configuration check passed

            User "grid" is not part of "root" group. Check passed

            Checking if Clusterware is installed on all nodes...
            Check of Clusterware install passed

            Checking if CTSS Resource is running on all nodes...
            CTSS resource check passed


            Querying CTSS for time offset on all nodes...
            Query of CTSS for time offset passed

            Check CTSS state started...
            CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
            Check of clock time offsets passed


            Oracle Cluster Time Synchronization Services check passed

            Post-check for cluster services setup was unsuccessful.
            Checks did not pass for the following node(s):
            erprac2-verbose

            After this check i found then erprac2 second node is not reachable, how we can resolve this problem. Please assist me.
            • 3. Re: 11g Rel2 RAC Database prerequisites Failed
              921598
              when node reachability is an issue , other tests would be failed. have you checke the nodes reachability from each other using simple ping or accessing using via network?
              • 4. Re: 11g Rel2 RAC Database prerequisites Failed
                964640
                I already ping for both nodes and its working fine but where is the problem i dont know.

                I need the real experts people for this forum to solve my issue as urgent basis. already uploaded all the errors.

                Thanks.
                shahzad
                • 5. Re: 11g Rel2 RAC Database prerequisites Failed
                  921598
                  Dear Shahzad
                  I observe in your commandline (./runcluvfy.sh stage -post crsinst -n erprac1,erprac2-verbose) you don't have sapce between your node2 and "-verbose", please add space and run the cluvfy again and paste the results.

                  ./runcluvfy.sh stage -post crsinst -n erprac1,erprac2 -verbose
                  • 6. Re: 11g Rel2 RAC Database prerequisites Failed
                    964640
                    Hi,

                    Yes there was a mistake in command, now sending the output of cluvfy, please check and advice me what is the actual problem, output shows that clusters are fine in both the nodes then why database creation prerequesties are failed. here i should mention that i used "grid " id for creation of clusters and "oracle" id for creation of database.

                    [grid@erprac1 grid]$ ./runcluvfy.sh stage -post crsinst -n erprac1,erprac2 -verbose

                    Performing post-checks for cluster services setup

                    Checking node reachability...

                    Check: Node reachability from node "erprac1"
                    Destination Node Reachable?
                    ------------------------------------ ------------------------
                    erprac1 yes
                    erprac2 yes
                    Result: Node reachability check passed from node "erprac1"


                    Checking user equivalence...

                    Check: User equivalence for user "grid"
                    Node Name Comment
                    ------------------------------------ ------------------------
                    erprac1 passed
                    erprac2 passed
                    Result: User equivalence check passed for user "grid"
                    Checking time zone consistency...
                    Time zone consistency check passed.


                    Checking Cluster manager integrity...

                    Checking CSS daemon...

                    Node Name Status
                    ------------------------------------ ------------------------
                    erprac1 running
                    erprac2 running

                    Oracle Cluster Synchronization Services appear to be online.

                    Cluster manager integrity check passed


                    UDev attributes check for OCR locations started...
                    Result: UDev attributes check passed for OCR locations


                    UDev attributes check for Voting Disk locations started...
                    Result: UDev attributes check passed for Voting Disk locations


                    Check default user file creation mask
                    Node Name Available Required Comment
                    ------------ ------------------------ ------------------------ ----------
                    erprac1 0022 0022 passed
                    erprac2 0022 0022 passed
                    Result: Default user file creation mask check passed

                    Checking cluster integrity...

                    Node Name
                    ------------------------------------
                    erprac1
                    erprac2

                    Cluster integrity check passed


                    Checking OCR integrity...

                    Checking the absence of a non-clustered configuration...
                    All nodes free of non-clustered, local-only configurations


                    ASM Running check passed. ASM is running on all cluster nodes

                    Checking OCR config file "/etc/oracle/ocr.loc"...

                    OCR config file "/etc/oracle/ocr.loc" check successful


                    Disk group for ocr location "+DATA" available on all the nodes


                    Checking size of the OCR location "+DATA" ...

                    Size check for OCR location "+DATA" successful...
                    Size check for OCR location "+DATA" successful...

                    WARNING:
                    This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

                    OCR integrity check passed

                    Checking CRS integrity...
                    The Oracle clusterware is healthy on node "erprac1"
                    The Oracle clusterware is healthy on node "erprac2"

                    CRS integrity check passed

                    Checking node application existence...

                    Checking existence of VIP node application
                    Node Name Required Status Comment
                    ------------ ------------------------ ------------------------ ----------
                    erprac1 yes online passed
                    erprac2 yes online passed
                    Result: Check passed.

                    Checking existence of ONS node application
                    Node Name Required Status Comment
                    ------------ ------------------------ ------------------------ ----------
                    erprac1 no online passed
                    erprac2 no online passed
                    Result: Check passed.

                    Checking existence of GSD node application
                    Node Name Required Status Comment
                    ------------ ------------------------ ------------------------ ----------
                    erprac1 no does not exist ignored
                    erprac2 no does not exist ignored
                    Result: Check ignored.

                    Checking existence of EONS node application
                    Node Name Required Status Comment
                    ------------ ------------------------ ------------------------ ----------
                    erprac1 no online passed
                    erprac2 no online passed
                    Result: Check passed.

                    Checking existence of NETWORK node application
                    Node Name Required Status Comment
                    ------------ ------------------------ ------------------------ ----------
                    erprac1 no online passed
                    erprac2 no online passed
                    Result: Check passed.


                    Checking Single Client Access Name (SCAN)...
                    SCAN VIP name Node Running? ListenerName Port Running?
                    ---------------- ------------ ------------ ------------ ------------ ------------
                    racnode-cluster-scan erprac2 true LISTENER 1521 true

                    Checking name resolution setup for "racnode-cluster-scan"...
                    SCAN Name IP Address Status Comment
                    ------------ ------------------------ ------------------------ ----------
                    racnode-cluster-scan 192.168.1.187 passed

                    Verification of SCAN VIP and Listener setup passed
                    OCR detected on ASM. Running ACFS Integrity checks...

                    Starting check to see if ASM is running on all cluster nodes...

                    ASM Running check passed. ASM is running on all cluster nodes

                    Starting Disk Groups check to see if at least one Disk Group configured...
                    Disk Group Check passed. At least one Disk Group configured

                    Task ACFS Integrity check passed

                    Checking Oracle Cluster Voting Disk configuration...

                    Oracle Cluster Voting Disk configuration check passed

                    Checking to make sure user "grid" is not in "root" group
                    Node Name Status Comment
                    ------------ ------------------------ ------------------------
                    erprac1 does not exist passed
                    erprac2 does not exist passed
                    Result: User "grid" is not part of "root" group. Check passed

                    Checking if Clusterware is installed on all nodes...
                    Check of Clusterware install passed

                    Checking if CTSS Resource is running on all nodes...
                    Check: CTSS Resource running on all nodes
                    Node Name Status
                    ------------------------------------ ------------------------
                    erprac1 passed
                    erprac2 passed
                    Result: CTSS resource check passed


                    Querying CTSS for time offset on all nodes...
                    Result: Query of CTSS for time offset passed

                    Check CTSS state started...
                    Check: CTSS state
                    Node Name State
                    ------------------------------------ ------------------------
                    erprac1 Active
                    erprac2 Active
                    CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
                    Reference Time Offset Limit: 1000.0 msecs
                    Check: Reference Time Offset
                    Node Name Time Offset Status
                    ------------ ------------------------ ------------------------
                    erprac1 0.0 passed
                    erprac2 0.0 passed

                    Time offset is within the specified limits on the following set of nodes:
                    "[erprac1, erprac2]"
                    Result: Check of clock time offsets passed


                    Oracle Cluster Time Synchronization Services check passed

                    Post-check for cluster services setup was successful.