DTABASE IS UNAVAILABLE [message #126827] |
Wed, 06 July 2005 18:18 |
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 |
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 |
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.
|
|
|