solution for error ora-12560 oracle 10g failsafe server node2 on windows werver 2003 mscs server
Posted on 2009-05-20
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.