Re: TNSPING to Oracle without Entry in TNSNAMESORA

Nicolas Bronke wrote:
>
> > Yres it is normal. The environment variable ORACLE_SID will enable this
> > connection.
> >
> Thank you.

In addition: if you want that, without switching oracle_sid settings all the time, try this in tnsnames.ora:
DES2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle)(ARGV0 = oracleDES2)

        (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))     (CONNECT_DATA =
      (SID = DES2)
    )
  )
Replace _all_ DES2 with your own SID (apart from the 1st one, which doesn't
matter).

-- 
Gtrz,

Frank van Bortel