[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2009-05-20
1
Medium Priority
?
835 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 1500 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

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

830 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