How to create the database on fail safe cluster

I have created 2 node cluster MSCS on windows server 2003.Then I have installed oracle fail safe server 3.3.3 for windows.Now I want to create the database.How to create the Database on the oracle fail safe server?
ajayg161073Asked:
Who is Participating?
 
metronameConnect With a Mentor Commented:
Okay so in step two, when you have installed Oracle on both nodes, you then created the database on a shared resource correct?  Like on a NAS or SAN?

On node one for example, and once the bin files are installed, you created the DB on that MSCS cluster resource, failed the node to node two (other server) and then attached the install to that DB on that MSCS cluster shared resource (say drive E) correct?

Now you would start with the FS installation.

Please note if you install the Oracle BIN files on D:\Oracle on node one you will need to do the same on node two installation (D:\Oracle).  The DB then resides in the shared resource (in this example E:\DB).  ORA-01033 is a shutdown in progress and ora-12560 is a "generic" protocol adapter error.  You will typically see this in clustering if the Oracle client doesn't know what instance to connect to or what the TNS alias is to be used.  If we fix the first part the second should work just fine.

Please keep posting questions/results here so the community can benefit.

Thanks! Hope this bit can help more.
0
 
metronameCommented:
Not sure if you've found your answers yet but if you follow these basic steps you should be fine.
1.  MSCS is already installed as you have stated
2.  Oracle on both nodes in the cluster (not the failsafe application yet)
3.  Create your oracle DB on one of your server nodes using the shared disc.
4.  Now install Oracle's FailSafe on each node in the cluster
5 ... From here you can use the FailSafe manager to finalize your cluster.

It sounds like you may have just installed FailSafe a little to early on.

Please post back if this helps.
0
 
ajayg161073Author Commented:
after completing the installation according to the steps given by you. I am getting the error "ora-01033' on one node and ora 12560 on another node in the cluster.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
metronameCommented:
Sorry meant to include this too...have you issued "alter database open" yet after the installation?

Sorry I know basic but I have to ask just to be sure.
0
 
ajayg161073Author Commented:
please let me know the contents of the listner.ora and tnsnames.ora file on both nodes of the failsafe cluster.
0
 
metronameCommented:
Sorry about the delay in getting back to you.  I am traveling.

Please explain your question above.  Do you not know your listener and tns names?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.