How to create the database on fail safe cluster

Posted on 2009-05-19
Medium Priority
Last Modified: 2013-12-18
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?
Question by:ajayg161073
  • 4
  • 2

Expert Comment

ID: 24424827
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.

Author Comment

ID: 24429237
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.

Accepted Solution

metroname earned 375 total points
ID: 24437119
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.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.


Expert Comment

ID: 24437123
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.

Author Comment

ID: 24438334
please let me know the contents of the listner.ora and tnsnames.ora file on both nodes of the failsafe cluster.

Expert Comment

ID: 24514658
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?

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

627 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