Only one node seeing shared disk at a time

I am trying to set up Oracle on a two-node cluster with one shared disk. I cannot use Oracle Real Application clusters because the shared disk was assigned as a primary partition from a SAN and cannot be reassigned as an extended partition or logical partition. I will install the binaries on each node and store the datafiles on the shared disk. The problem is only one node sees the shared disk at a time.

    Requires Free Membership to View

    Login

When you start an Oracle database, the instance places locks on each datafile. This prevents other instances from opening those datafiles. This is most likely your problem you are experiencing. The only solution around this is to implement Real Application Clusters (RAC). RAC is the only approved solution for letting multiple instances use the same shared disk files.

For More Information


This was first published in April 2003

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top