RAC problem

[suhasd75]

All,

I upgraded Oracle to 10.1.0.5 from 10.1.0.4.
The second instance does not seem to be accepting any connections.
I login to server and run
sql> select * from v$instance
This returns the correct instance number, namely, 2 in this case.
However, I login from a client (sql*plus/toad) using tnsnames.ora, which has an entry for the second node, and then query v$instance; it shows instance number 1 !
This is really strange to say the least.
Also, if I query gv$instance, I get two records, with correct details.
CRS is running, nodeapps are running on both instances properly.

I anyone can give a solution, I would be very grateful!

Thanks in advance!
Suhas

[davey23uk]

well the listener is obviously redirecting you to the first instance

[suhasd75]

Thanks for the early reply davey23uk!
How do I rectify this issue ?

[stmontgo]

select * from GV$ACTIVE_INSTANCES

[waitecj]

Thanks for the early reply davey23uk!
How do I rectify this issue ?

Start lsnrctl on the second node and check the status of the listener you are using to connect. Can you see your service registered with the listener?