wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes getting error ORA-125 : TNS :no listener while try to login toad Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "getting error ORA-125 : TNS :no listener while try to login toad" Watch "getting error ORA-125 : TNS :no listener while try to login toad" New topic
Author

getting error ORA-125 : TNS :no listener while try to login toad

smita mishra
Ranch Hand

Joined: May 18, 2006
Posts: 31
I install toad in my computer.but when try to log in It askes me database,user name & password.I have installed oracle 9i to my system.So i choose database name ra
user : ora
password ra
but i got an error :"ORA-125 : TNS :no listener"
why I get this error? how can I fix it?
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

I believe you also need to give it the location of the database through a tnsname. Also if the database isn't running on the server, then you have no listeners running.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
smita mishra
Ranch Hand

Joined: May 18, 2006
Posts: 31
how can I check whether database is running on the server ?
Chris Hendy
Ranch Hand

Joined: Mar 04, 2006
Posts: 98
Since you have installed toad that would imply you have a Windows system.

In this case Oracle is installed as a service called OracleService<SID>, where <SID> is the System Identifier of your database. In your case OracleServiceORA. Make sure this service is started. The listener is another service called (as far as I can remember) Oracle<ORACLE_HOME_NAME>TNSListener where <ORACLE_HOME_NAME> is the value you chose on installation. Make sure this service is started.

If you are on *nix tell me because the steps are different.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getting error ORA-125 : TNS :no listener while try to login toad
 
Similar Threads
ORA-00942: table or view does not exist
Can't initialize OCI. Error -1 -- Toad error please help
Network Adapter Problem
End of TNS datachannel Error
Oracle Standby - Listener could not authe nticate the user