Re: ORA-12203, ORA-12500 , Connect failed.

check your client and server configuration file for listener

and you can see error message about the error number using oerr command.

for example

$oerr ora 12203 (enter)

12203, 00000, "TNS:unable to connect to destination"

// *Cause: Invalid TNS address supplied or destination is not listening.
// This error can also occur because of underlying network transport
// problems.
// *Action: Verify that the service name you entered on the command line
// was correct. Ensure that the listener is running at the remote node and
// that the ADDRESS parameters specified in TNSNAMES.ORA are correct.
// Finally, check that all Interchanges needed to make the connection are
// up and running.

 Please check tnsnames.ora(client side) and listener.ora(server side)

good luck!

jjchoi <jjchoi_at_iesys.co.kr>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:850unj$kmb$1_at_kpt1000.hitel.net¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> Hi
>
> suddenly, it's connect failed with error messages .
> that error number is ORA-12203, ORA-12500 .
> I don't know. what to do?
> Please, help me...
>
> thanks and regards
>
>
>
Received on Wed Jan 05 2000 - 21:33:04 CST