ORA-12541: TNS:no listener ( ERROR coming when one node of RAC database is off
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.
I Suspect that the listener you use runs only on one of the nodes, OR the client side tnsnames.ora points ONLY to one of your listeners. Hence when the node with the listener is down, there really is no listener.
Put the tnsnames.ora as well
I observed one more thing while trying to fix this.
I logged in to database(in the node which was not shut down), using command :
conn sys as sysdba.
Then it connected to idle instance.
Then I used the command startup, which then started the oracle instance. After that I could connet to database from outside as sysdba only. For other users, it's showing oracle initialization or shutdown in progress. That was a bit strange though.
So does that mean, Out of my two nodes, if one node is shutdown, it's not starting oracle instance by default ?
As I already mentioned, that error means that the client is looking for a listener where the listener is not present.
That would mean
1) The client looks at wrong place (host/port)
2) The listener is not working
Please let us know
1) From which machine you try to log
2) Look at the tnsnames.ora and see if the address of this listener is present there, coresponding to your connect string
3) Look at the sqlnet.ora and see what the policy is (should be try all addresses until one succeeds or something)
The Oracle Net Assistant also has interface to these files.
The listener.ora file does not seems to have any problems
I've already posted tnsnames.ora and listener.ora file of client and servers. As you can see from them, the listener name(as in the connect string) orclrac is there in the listener.ora files of server nodes.
As for from which computer i'm logging in, actually i'm using vmware for rac implementation. So i'm logging in from the host operating system.
Also, i amn't getting anything from sqlnet.ora file of the client.
It looks as below.
# sqlnet.ora Network Configuration File: f:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.