Home » RDBMS Server » Networking and Gateways » Connection Problem with Oracle (Oracle 9i, Windows XP)
icon9.gif  Connection Problem with Oracle [message #305870] Wed, 12 March 2008 04:57 Go to next message
richakulkarni
Messages: 3
Registered: March 2008
Location: Bangalore, India
Junior Member
Hello All Cool ,
I have recently installed Oracle 9i on my machine. I'm not able to connect to the database because of the TNS problems and listener problems. I tried configuring through Net Configuration Assistant, but didnt work. My global database name = richa , SID = richa, host = localhost. Can anyone guide me as to what all things i need to check and do to make it work. I'm getting these errors in SQL developer, Toad as well as in sql plus Sad .

Please help Smile .

Thanks a lot in advance.
Richa
Re: Connection Problem with Oracle [message #305873 is a reply to message #305870] Wed, 12 March 2008 05:10 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Whats your OS?
What TNS error are you getting?
Re: Connection Problem with Oracle [message #305908 is a reply to message #305873] Wed, 12 March 2008 05:53 Go to previous messageGo to next message
richakulkarni
Messages: 3
Registered: March 2008
Location: Bangalore, India
Junior Member
Hello,
I have win xp as OS and i'm getting Listener error: No listener
and TNS error: service name and adapter errors

Thanks
Richa
Re: Connection Problem with Oracle [message #305925 is a reply to message #305908] Wed, 12 March 2008 06:12 Go to previous message
Michel Cadot
Messages: 57615
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12224: "TNS:no listener"
 *Cause: The connection request could not be completed because the listener
 is not running.
 *Action: Ensure that the supplied destination address matches one of
 the addresses used by the listener - compare the TNSNAMES.ORA entry with
 the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
 go by way of an Interchange). Start the listener on the remote machine.

ORA-12541: "TNS:no listener"
 *Cause: The connection request could not be completed because the listener
 is not running.
 *Action: Ensure that the supplied destination address matches one of
 the addresses used by the listener - compare the TNSNAMES.ORA entry with
 the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
 go by way of an Interchange). Start the listener on the remote machine.

Regards
Michel
Previous Topic: ORA-12500: TNS:listener failed to start a dedicated server process error on a load balancer environ
Next Topic: conectivity of oracle 9i and forms 6i
Goto Forum:
  


Current Time: Mon Apr 21 03:52:52 CDT 2014

Total time taken to generate the page: 0.14608 seconds