If I connect to scott/tiger@FOO, is it possible to get
a copy of the FOO TNS definition?

I'm doing some connection testing, and I want to print
out TNS of the current connection so I can verify I'm
testing the right options.

Many TIA!!
Mark

--
Mark Harrison
Pixar Animation Studios

On May 28, 12:44*am, m... (AT) pixar (DOT) com wrote:
Also see the Oracle® Database Net Services Administrator's Guide about
Troubleshooting Oracle Net Services, you may be interested in the log
and tracing abilities.

jg
--
@home.com is bogus.
http://www.thestandard.com/news/2009...y-one-chairman

mh (AT) pixar (DOT) com wrote:
: If I connect to scott/tiger@FOO, is it possible to get
: a copy of the FOO TNS definition?

: I'm doing some connection testing, and I want to print
: out TNS of the current connection so I can verify I'm
: testing the right options.

Do you mean from within the database while connected?

In sqlplus I use

select
'&_O_RELEASE' Release,
USER Username,
global_name
-- , 'and _CONNECT_IDENTIFIER' CONNECT_STRING
from global_name;


I forget which version you need to be able to use &_CONNECT_IDENTIFIER.

Global name does not depend on sqlplus, but the & vars do (and can also be
easily viewed by just typing DEF with no parameters in sqlplus.

Also look at SYS_CONTEXT('USERENV',xx), it has some things that are
useful, in this case you might be interested in DB_DOMAIN DB_NAME
DB_UNIQUE_NAME HOST, and maybe others.

$0.10