Re: ora-12560 only from TKPROF

From: beach <chbeach_at_loxinfo.co.th>
Date: Mon, 22 Jan 2001 08:19:05 +0700
Message-ID: <94g49e$1sdt$1@news.cscoms.com>

Hi Ed
I think it's a definition problem in your listener. here the meaning of ORA(TNS-12203)

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.

Beat

"Ed Stevens" <ed.stevens_at_home.com> wrote in message news:94a99k$3ri$1_at_nnrp1.deja.com...
> When I run TKPROF from my workstation, with the EXPLAIN option, it gets
> an ora-12560, but any other tool (SQL-Plus, svrmgr, etc.) connects with
> no error.
>
> When I run TKPROF80 (with EXPLAIN) at the server hosting the database,
> it gets an ora-12203, but again other tools connect with no problem.
>
> ???
>
>
> - Ed Stevens
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sun Jan 21 2001 - 19:19:05 CST