Creating an oracle database on a windows cluster failover node, using data files on shared drive.

Posted on 2009-12-18
Last Modified: 2013-12-18
I have 2 windows machines that are set up as a cluster.  Both of them have oracle installed.  Both of them have a network drive D setup.  When the cluster fails over to node2, drive D is mounted on that machine and all oracle files are available there.

I have created a database on Node1.  All files (redo logs, control files, data files) are stored on the shared D drive.  For easiness sake, lets call this database catdb.  Catdb works fine and perfect on node1.  

What I need to do is create that database on Node2 of the cluster so that it uses the control files, redo logs, data files that are stored on shared drive D.

What would be the best way to do this?
Question by:andrewfx
    LVL 2

    Accepted Solution

    Hello Andrew,
    I am assuming this is an Active/passive cluster.

    Once you have setup your instance in the primary node, carry out the following on the 2nd node:
    - Failover the cluster to the 2nd node. Now your shared disk should be available here.
    - Copy all the configuration and parameter files to the same location as they were in the primary node. I suggest you have the spfile on the shared disk so that you use the same file from both the servers to avoid errors incase you make configuration changes.
    - Create an oracle service using the oradim utility with the same name as in primary and use the spfile to start the database

    oradim -NEW -SID catdb -SRVC oracleservice_catdb -SYSPWD password -STARTMODE auto
    -SPFILE filesname -SHUTMODE immediate

    - Once you start the service, the database should start without any errors.
    -You can add the service Oracleservice_catdb to the failover cluster configuration.


    Author Comment


    Thank you for your response.  The only way I know of to change the location of the spfile from the default location is to create an initSID.ora file in the default location that has the parameter SPFILE=D:\blah\blah\spfile

    So I would need to create that file on both Node1 and Node2, correct?  Or is there a different way to change the location of the spfile?
    LVL 2

    Expert Comment

    yes, spfile can be created using that.

    However, once the spfile is created and when you use oradim and specify the path of the file, then it will look at the parameters configued witht he service and not the init<sid> file.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now