Re: Oracle 8.0.5 error
From: ddf <oratune_at_msn.com>
Date: Wed, 22 Jun 2011 12:55:50 -0700 (PDT)
Message-ID: <bf791f59-4538-49df-98e2-cfa8eadf9bc8_at_k6g2000yqc.googlegroups.com>
On Jun 22, 11:16 am, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> ddf wrote:
> > Where is this entry configured:
>
> > (ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:
> > \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.
>
Date: Wed, 22 Jun 2011 12:55:50 -0700 (PDT)
Message-ID: <bf791f59-4538-49df-98e2-cfa8eadf9bc8_at_k6g2000yqc.googlegroups.com>
On Jun 22, 11:16 am, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> ddf wrote:
> > Where is this entry configured:
>
> > (ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:
> > \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