Solved

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

Posted on 2009-05-20
1
786 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 34

Accepted Solution

by:
Mark Geerlings earned 500 total points
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
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…
Via a live example, show how to take different types of Oracle backups using RMAN.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now