Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 684
  • Last Modified:

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

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?
0
andrewfx
Asked:
andrewfx
  • 2
1 Solution
 
shahidnsCommented:
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.

Regards.
Shahid.
0
 
andrewfxAuthor Commented:
shahidns,

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?
0
 
shahidnsCommented:
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.

Regards.
Shahid.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now