Re: 9i RAC failover/scalable doesn`t happen

Hi!
I have a question.
Did you make a TNS_CONNECTION with TAF policy?

If you didn't, your situation is correct. Probaby like following.

<NO TAF policy>

1. RAC1 connnct
2. select a lot
3. RAC1 fail
4. connection end of connection.
5. Retry connct
6. connect RAC2 with same TNS

<TAF policy>

1. RAC1 connnct
2. select a lot
3. RAC1 fail
4. connection transparent to RAC2.
5. result select

Please read TAF(Transparent Apllication failover) in RAC guid.

regards.
"unknown" <govindo_at_gmail.com> wrote in message news:1147101293.528050.234340_at_e56g2000cwe.googlegroups.com...
> Folks,
> My RAC setup as follows...
>
> * Solaris 9
> * SC 3.1(UP5)
> * SVM (Multiowner diskset)
> * Raw file
> * oracle 9201
> I configured two instances sai1,sai2 running on rac1 and rac2
> respectively. I have configured the resource group for rac
> framework,udlm and svm.
>
> 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 Tue May 09 2006 - 06:05:54 CDT