Re: ORA-12203

Anthony Mak wrote:
>
> I am using Oracle Server 7.3 When I tried to login to Schema Manager
> and SQL*PLUS ... etc, I got the ORA-12203 error saying unable to
> connect to destination.
>
> How can this be solved?
>
> What does Oracle mean when it say can't connect to destination?
>
> Also, I tried to go to Oracle's website to search for meaning for this
> ORA-12203 message. Is there a site that have all explantion for Oracle
> error messages?

   Hi Anthony,

--
TNS-12203 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.
--
Sign up OTN.oracle.com (free) and you will can using dosc

http://otn.oracle.com/docs/index.htm
http://otn.oracle.com/docs/products/oracle8i/doc_index.htm

(I prefer PDF format)

Valery Yourinsky
-- 
Oracle8 Certified DBA