Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 9i RAC failover/scalable doesn`t happen
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