Re: Oracle 8.0.5 error
From: joel garry <joel-garry_at_home.com>
Date: Fri, 17 Jun 2011 10:59:13 -0700 (PDT)
Message-ID: <4125f726-c018-4421-afc5-557afa650a91_at_x38g2000pri.googlegroups.com>
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
Date: Fri, 17 Jun 2011 10:59:13 -0700 (PDT)
Message-ID: <4125f726-c018-4421-afc5-557afa650a91_at_x38g2000pri.googlegroups.com>
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 :)Received on Fri Jun 17 2011 - 12:59:13 CDT