• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1495
  • Last Modified:

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?
0
ajayg161073
Asked:
ajayg161073
  • 4
  • 2
1 Solution
 
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
 
metronameCommented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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