ORA-12541: TNS:no listener ( ERROR coming when one node of RAC database is off
Hi
I've a RAC Database running on two nodes on WINDOWS 2000.
When One node(name- tgvirtualtwo) runs alone and other node(name-tgvirtualone) is off, it's working fine. However when the node(name-tgvirtualone) runs alone, and tgvirtualtwo is off, I'm unable to connect to database. Error showing ORA-12541: TNS:no listener .
I also checked oracle services.They are all running.
Here is my listener configurations:
TgVirtualTwo configurations
--------------------------
# listener.ora.tgvirtualtwo Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora.tgvirtualtwo
# Generated by Oracle configuration tools.
LISTENER_TGVIRTUALTWO =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521)(IP = FIRST))
)
)
TgvirtualOne configurations:
--------------------------
LISTENER_TGVIRTUALONE =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.8)(PORT = 1521)(IP = FIRST))
)
)
I also tried changing host to 10.0.0.1( private ip of tgvirtualone) in place of 192.168.0.8 but to no avail.
Please help !