Re: Oracle 8.0.5 error
From: ddf <oratune_at_msn.com>
Date: Thu, 23 Jun 2011 08:53:52 -0700 (PDT)
Message-ID: <dda9e34c-c2f7-44d9-89e0-97eff2109b27_at_a11g2000yqm.googlegroups.com>
On Jun 22, 5:28 pm, Dan <daniel.oster..._at_visaer.com> wrote:
> On Jun 22, 3:55 pm, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > 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- Hide quoted text -
>
> > - Show quoted text -
>
> David and Gerald,
> Thanks so much for taking the time to help me here, I appreciate it
> emmensely. I'll try to answer your questions:
>
> - In the registry under hkey-local-machine\software\oracle, there is
> an ORACLE_SID entry of ORCL.
> - I checked svrmgr30 and ran it with the .exe at the end and the
> result is the same. I went to the bin directory and ran from there to
> be sure.
> - Someone asked about the lower case orcl instead of ORCL, remember
> this is Windows so the case doesn't matter. I tried both though just
> to be 100% sure.
> - Also, I'm totally local when doing this work, there is no remote
> database. What I'm doing is using remote desktop to get to this
> computer, but it's the database server. So when running svrmgr30, as
> long as the ORACLE_SID is set it shouldn't care about tns/sqlnet,
> etc. Correct? What's strange is that it only works when I do the _at_
> sign in the connect internal command.
>
> From the trace file it shows that it's using the BEQ connection. Is
> this normal? Per ddf's question, this entry is configured in the
> tnsnames.ora file in net80\admin.
>
> Also, somewhere I read that I should set the LOCAL key entry in the
> registry HOME0 directory to XXXX. Apparently this is to steer it away
> from the default orcl. Not sure why, I did this and nothing
> happened. Setting it to ORCL didn't help either.
>
> Any other suggestions as to what I should do? I am completely
> stumped. Oh, and by the way, I'm building this database for the
> client because their old oracle server had the EXACT SAME connection
> problem via svrmgr30. I thought it was a bad install but maybe not.
> Could it be something with their network? Something with the
> compatibility of 8.0.5 and Win2000?
>
> Again, thanks for all your help.
> Dan- Hide quoted text -
>
> - Show quoted text -
Date: Thu, 23 Jun 2011 08:53:52 -0700 (PDT)
Message-ID: <dda9e34c-c2f7-44d9-89e0-97eff2109b27_at_a11g2000yqm.googlegroups.com>
On Jun 22, 5:28 pm, Dan <daniel.oster..._at_visaer.com> wrote:
> On Jun 22, 3:55 pm, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > 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- Hide quoted text -
>
> > - Show quoted text -
>
> David and Gerald,
> Thanks so much for taking the time to help me here, I appreciate it
> emmensely. I'll try to answer your questions:
>
> - In the registry under hkey-local-machine\software\oracle, there is
> an ORACLE_SID entry of ORCL.
> - I checked svrmgr30 and ran it with the .exe at the end and the
> result is the same. I went to the bin directory and ran from there to
> be sure.
> - Someone asked about the lower case orcl instead of ORCL, remember
> this is Windows so the case doesn't matter. I tried both though just
> to be 100% sure.
> - Also, I'm totally local when doing this work, there is no remote
> database. What I'm doing is using remote desktop to get to this
> computer, but it's the database server. So when running svrmgr30, as
> long as the ORACLE_SID is set it shouldn't care about tns/sqlnet,
> etc. Correct? What's strange is that it only works when I do the _at_
> sign in the connect internal command.
>
> From the trace file it shows that it's using the BEQ connection. Is
> this normal? Per ddf's question, this entry is configured in the
> tnsnames.ora file in net80\admin.
>
> Also, somewhere I read that I should set the LOCAL key entry in the
> registry HOME0 directory to XXXX. Apparently this is to steer it away
> from the default orcl. Not sure why, I did this and nothing
> happened. Setting it to ORCL didn't help either.
>
> Any other suggestions as to what I should do? I am completely
> stumped. Oh, and by the way, I'm building this database for the
> client because their old oracle server had the EXACT SAME connection
> problem via svrmgr30. I thought it was a bad install but maybe not.
> Could it be something with their network? Something with the
> compatibility of 8.0.5 and Win2000?
>
> Again, thanks for all your help.
> Dan- Hide quoted text -
>
> - Show quoted text -
Oracle tested 8.0.6 Enterprise edition on Windows 2000 beta in 1999; the official recommendation at that time was to not install 8.0.6 on Windows 2000. See Doc 116208.1 for details.
David Fitzjarrell Received on Thu Jun 23 2011 - 10:53:52 CDT