Solved

How to create the database on fail safe cluster

Posted on 2009-05-19
6
1,422 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

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.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

839 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