File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 17257
    
    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.
 
 
subject: getting error ORA-125 : TNS :no listener while try to login toad