Re: Oracle 8.0.5 error

From: ddf <>
Date: Wed, 22 Jun 2011 12:55:50 -0700 (PDT)
Message-ID: <>

On Jun 22, 11:16 am, "Gerard H. Pille" <> wrote:
> ddf wrote:
> > Where is this entry configured:
> > \orant\bin\SVRMGR30.EXE)(HOST=WRIGHT-UUJCBBFS)(USER=Administrator))))
> > It's not in your posted tnsnames.ora file as the SID you have listed
> > is ORCL, not orcl.  I expect you have another tnsnames.ora somewhere
> > that Oracle is using.
> > David Fitzjarrell
> An Oracle client does not use a tnsnames.ora to decide to which database it should connect.  It
> uses environment variables, registry entries, command-line parameters or the connect string
> entered by the user.   After that, sql*net will be used when connecting to a remote ("_at_") database.
> In Dan's trace you'll see he wants a local, bequeath connection, so even for this phase, no
> tnsnames.ora is needed.  Nor is sqlnet.ora.

And at 2 AM after a long day of battling with Oracle Support and dealing with production issues I missed the BEQ in the entry. It happens.

> orcl may well be a built in, default database that svrmgr30.exe tries to contact.   Dan, did you
> check the registry for "orcl" ?    On the command line, do you enter "svrmgr30.exe" or just
> "svrmgr30"?    There could be a "svrmgr30;bat" or "svrmgr30.cmd" lurking around.

It may well be but it does seem strange that it's coded as 'orcl' and not the usual 'ORCL'.

David Fitzjarrell Received on Wed Jun 22 2011 - 14:55:50 CDT

Original text of this message