Home » RDBMS Server » Networking and Gateways » DTABASE IS UNAVAILABLE
DTABASE IS UNAVAILABLE [message #126827] Wed, 06 July 2005 18:18 Go to next message
ghostofrockies
Messages: 2
Registered: July 2005
Junior Member
HI,

i installed oracle 10g and now when i want to logon it gives me an error message that database is unavailable. it also gives me an error ora 12541 when i try to logon through sqlplus. i checked the listener.ora and tnsnames.ora files to check whether the host address matches, it does.

please help.

thanks

ghost
Re: DTABASE IS UNAVAILABLE [message #126885 is a reply to message #126827] Thu, 07 July 2005 02:21 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
You need to start your database listener:

$ oerr ora 12541
12541, 00000, "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.


Best regards.

Frank
Re: DTABASE IS UNAVAILABLE [message #126980 is a reply to message #126885] Thu, 07 July 2005 12:00 Go to previous message
ghostofrockies
Messages: 2
Registered: July 2005
Junior Member
hi Frank.

I have checked the listener.ora and tnsnames.ora files and the address match in there. ALthough i have started listener from the command line, but it still gives me the same error.

Thanks.
Previous Topic: Old client new DB Server
Next Topic: listner is not started
Goto Forum:
  


Current Time: Sun Nov 24 21:56:39 CST 2024