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

Did you cut and paste this?

>> (SERVICE_NAME = sai.ftpl..com) <<

Regards,

Steve

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@gmail.com> wrote in message
news:1147101293.528050.234340@e56g2000cwe.googlegr oups.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
>