Solved

solution for error ora-12560 oracle 10g failsafe server node2 on windows werver 2003 mscs server

Posted on 2009-05-20
1
796 Views
Last Modified: 2013-12-18
i have created the 2 node cluster by using the  starwind iscsi target software and microsoft iscsi initiator on windows server 2003. then i have installed the oracle software on both nodes.
then i have created the database on one node and used the shared drive for storing the control file, database file and logfiles.then i have installed the oracle fail safe softwareversion 3.3.3 on both nodes. after completing the above procedure i am facing the following problems

1) problem on node1(when node2 is  off or on)-  after turning on this node, i am getting the error ora-12528, i found the database in no mount condition. then  i used "shut immediate"  command  to make it down. then i used the "startup" command, i found that the database is open without  ora-12528 error . i fell that it should start automatically when the windows server start. so please guide for the automatic startup of the database on node1(
2)i problem on node2 (when node 1 is  off or on)-  it is giving the error ora-12560 tns protocol adapter error while connecting to oracle.
0
Comment
Question by:ajayg161073
1 Comment
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 24442033
How much experience do you have managing or installing Oracle databases in a simpler (non-clustered) configuration?

If you are new to Oracle, I would *NOT* recommend that you try working with a complex configuration like this first!  Get some experience with Oracle on a single server first.  If your organization "needs" to have Oracle running in a clustered environment, then hire consultants with experience in installing, configuring and managing a complex environment like that.  Or, pay Oracle (or some other hosted service provider) to host the data and take care of these complexities for you.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle SQL syntax check  without executing 6 55
How to load 2 images in same column in Delphi 2 47
Repeat query 13 46
What's wrong with this T-SQL Foreign Key? 7 46
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

810 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