Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 9i RAC failover/scalable doesn`t happen

9i RAC failover/scalable doesn`t happen

From: unknown <govindo_at_gmail.com>
Date: 8 May 2006 08:14:53 -0700
Message-ID: <1147101293.528050.234340@e56g2000cwe.googlegroups.com>


Folks,
My RAC setup as follows...

I am not an oracle guy,just picked up some document explaining the RAC testing and I did as it is stated...but the failover doesn`t happen.

Testing............

1)rac1#srvctl status database sai
sai1 running on node rac1
sai2 running on node rac2

2)rac1# sql>select * from emp; (Have about 100000 records) ** Records start scrolling......

3)rac2#srvctl stop instance -d sai -i sai1

4)rac1# scrolling of record stop..shows the following message ORA-01089
ORA-12571 The failover doesn`t happen......My tnsnames.ora is given below

# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9201/network/
# Generated by Oracle configuration tools. SAI2 =
(description=
(address=(protocol=tcp)(host=rac2)(port=1521))
(connect_data=(service_name=sai.ftpl.com))
)

LISTENER_SAI2 =
(description=
(address=(protocol=tcp)(host=rac2)(port=1521))
(connect_data=(service_name=sai.ftpl.com))
)

SAI1 =
(description=
(address=(protocol=tcp)(host=rac1)(port=1521))
(connect_data=(service_name=sai.ftpl.com))
)

LISTENER_SAI1 =
(description=
(address=(protocol=tcp)(host=rac1)(port=1521))
(connect_data=(service_name=sai.ftpl.com))
)

SAI =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP) (HOST = rac1) (PORT = 1521))
(ADDRESS=(PROTOCOL=TCP) (HOST = rac2) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sai.ftpl..com)
(FAILOVER_MODE= (TYPE=SELECT) (METHOD=BASIC)

)
)
)

LISTENERS_SAI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sai.ftpl.com)

)
)

any help would be appreciated Received on Mon May 08 2006 - 10:14:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US