Re: TNSPING to Oracle without Entry in TNSNAMESORA

Nicolas Bronke wrote:
>
> >
> > I asked you to read the connect string in Frank's answer.
> > Does that include a reference to TCP/IP? No. So that should answer your
> > question. Sorry if my hint was above you.
> >
> I saw this with the local database. But my hope has been, that there is a
> chance to adapt the entry so that it work with TCP/IP. Because if I take the
> default database on any host without any tns entry, the connect to this
> database is much faster than the connect using any tns entry. And I have on
> several host more than one instance.
>
> Nevertheless thanks.
>
> Nicolas

I should have elaborated on the answer:
it will only work when entererd in tnsnames.ora on the same machine your instance resides. Also, afaik, it only works on MS platforms.
I think it causes oracle to be called in the same way it would when oracle_sid is set, without the obligation to set oracle_sid.

instead of:
set oracle_sid=testone
sqlplus scott/tiger
set oracle_sid=testtwo
sqlplus scott/scott
set oracle_sid=testthree
sqlplus scott/beam_me_up
set oracle_sid=testfour
sqlplus scott/doc

you can:

sqlplus scott/tiger_at_testone
sqlplus scott/scott_at_testtwo
sqlplus scott/beam_me_up_at_testthree
sqlplus scott/doc_at_testfour

So, no remote access using this (but then, you cannot use set oracle_sid from remote and expect things to work in this way, either), but no need for changing/setting oracle_sid all the time, either. Nifty solution when you have multiple instances on the same machine.

And no, it's not tcp, it's the BEQueth protocol (MS specific version of the IPC protocol is the closest I can describe it). Which would be the protocol of choice on non-MS platforms, when connecting locally (e.g. forms3 via terminal emulation)

-- 
Gtrz,

Frank van Bortel