This discussion is archived
6 Replies Latest reply: Sep 29, 2012 11:20 PM by 964640 RSS

11g Rel2 RAC Database prerequisites Failed

964640 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points