Solved

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

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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

707 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