Solved

How to create the database on fail safe cluster

Posted on 2009-05-19
6
1,445 Views
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?
0
Comment
Question by:ajayg161073
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 1

Expert Comment

by:metroname
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.
0
 

Author Comment

by:ajayg161073
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.
0
 
LVL 1

Accepted Solution

by:
metroname earned 125 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.
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 1

Expert Comment

by:metroname
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.
0
 

Author Comment

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

Expert Comment

by:metroname
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?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

734 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