Re: Oracle 8.0.5 error

From: Dan <daniel.ostertag_at_visaer.com>
Date: Fri, 17 Jun 2011 12:12:51 -0700 (PDT)
Message-ID: <2faa3624-21ea-4861-b475-9437c17b08d9_at_a10g2000vbz.googlegroups.com>



On Jun 17, 1:59 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 17, 9:12 am, Dan <daniel.oster..._at_visaer.com> wrote:
>
>
>
>
>
> > Yes, yes, I know this is a REALLY OLD version of Oracle.  I'm doing
> > some one-time work for a client that is stuck on old enterprise
> > software that can only run on Oracle 8.
>
> > Having said that here is the problem:
> > a newly installed version of Oracle 8.0.5 resides on Windows 2000
> > SP4.  After installation the svrmgr30.exe (server manager) program
> > always gives me the error "ORA-12203: TNS:unable to connect to
> > destination".  This happens even before I try to type "connect
> > internal".  I get the error both when I manually try to create a
> > database and when the installer tries to create the ORCL database for
> > me.  I purposely run the installer and take all the defaults, so it's
> > not like I've not created the TNSNAMES or Listener correctly - the
> > installer should be doing this.  And on investigation, the listener is
> > up and running, tnsnames looks good, etc.
>
> > A similar configuration on another server gives the same exact error.
>
> > Is it the network?  Doubtful, I'm doing everything local.  Is it the
> > OS?  Can 8.0.5 simply NOT RUN on Win2000?  I've seen issues regarding
> > this but nothing as dead-in-the-water as this.
>
> > Any ideas?  No dinosaur comments please :)
>
> > Dan
>
> Do you have more than one %oracle_home% in your path?  Also check
> registry for multiple entries, and all the environment variables.  See
> MOS ORA-12203 CONNECTING VIA SERVER MANAGER ON WINDOWS NT [ID
> 1041178.6]
>
> Could be an effect of trying more than once, services screwed up.  See
> MOS CREATE NEW DATABASE - CANNOT CONNECT: ORA-12203 AND NT ERROR 1058
> [ID 1067887.6]
>
> jg
> --
> _at_home.com is bogus.http://www.metrolyrics.com/dinosaur-lyrics-king-crimson.html
> Sorry, you mentioned dinosaur :)- Hide quoted text -
>
> - Show quoted text -

Joel,
That article seems to be related to exactly what is happening to me. The description on where to navigate to is a little sketchy, but I went to \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 and added an ORACLE_SID entry. But this didn't help. The sid that I had the installer install (ORCL) is not running because the 'Create database' command failed because it couldn't connect internal. So when I point to this database in the registry it's only half-built. It has services but no actual database. I want to run svrmgr30 to run the create database command but can't do it.

John, regarding the OS, the other system that is working is at Win2000 SP4 also. It has the same Ora-12203 error but somehow they were able to build databases - probably before this error started arising.

I set up a trace level 16 in sqlnet.ora and I see that a message in the log says "Unable to get data from navigation file tnsnav.ora". I'm not sure if this is an issue or not.

I'm completely stumped. Part of it might be that I haven't used this version in so long.

Thanks,
Dan Received on Fri Jun 17 2011 - 14:12:51 CDT

Original text of this message