Solved

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

Posted on 2009-05-20
1
801 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
[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
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

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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.

730 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