Error ORA-12541 Listener Not Available

Asked By A.Steven 40 points N/A Posted on - 06/12/2011

Hi,

I have no time to do more chit chat, but I am stuck up with this error of Visual Studio.

It was running fine, but I got a surge power attack to my computer,and after it turned on.

I was getting this error when I started Visual Studio, "No Listener" available.

ORA-12541: TNS:no listener

I have tried to sort this out, but no one helped me out. I know now why this error appears but don’t know how to fix this problem or error.

I can make it easy for you by telling why it appears. It appears because if the listener is not being started or not being correctly configured or may be due to a network problem.

I tried to start the listener but couldn’t succeed.

Now I am totally hopeless and depending on anyone of you to reply to my post for fixing this error up?

• Status: Open
• Question Views: 2154
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Software

Best Answer by kaibaa

Go To Solution

Best Answer

Best Answer

Answered By kaibaa 0 points N/A #120564

Error ORA-12541 Listener Not Available

This error code has many reasons to occur:

1. Listener not started,
2. Error in the configuration of the listener
3. Or due to a network problem

You have already tried to start the listener but the program refused to do, so you should configure the configuration parameter ORACLE_SID as follows :

set ORACLE_SID=DB_NAME (with DB_NAME the name of the database you are working on) 

then set the ORACLE_HOME parameter as follows:

set ORACLE_HOME=path_to_your_oracle_installation_directory.

Otherwise compare the TNSNAMES.ORA and the LISTENER.ORA entries (they must contain the same destination address).

 

Don't forget to restart the listener after taking these actions.

About kaibaa

Questions
0

Answers
2

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 06/12/2011
• Question Category: Misc Software

Answered By GeoffScott 0 points N/A #120565

Error ORA-12541 Listener Not Available

ORA-12541: TNS: No listener occurs, when the listener is not running or the serve is unreachable or it may be down.

Another cause may be that the listener is not properly configured. With this, we must have the listener up and listening on the address. You can check if your listener is up and running by:
Please click on Start then Settings.

• Please go to Control Panel, then Service under NT or Listener Control Program. It shows the current status or state of the listener

If the listener is properly set up, this may be caused by Network connection problems.

About GeoffScott

Questions
0

Answers
7

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 06/14/2011
• Question Category: Misc Software