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

On Jun 17, 9:12*am, Dan <daniel.oster... (AT) visaer (DOT) com> wrote:
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
--
@home.com is bogus.
http://www.metrolyrics.com/dinosaur-...g-crimson.html
Sorry, you mentioned dinosaur

On Jun 17, 12:12*pm, Dan <daniel.oster... (AT) visaer (DOT) com> wrote:
Try the setup you are describing on a windows version that it actually
succeeds on and then start working backwards maybe?

Will it succeed on any versions of windows 2000?

Is it the SP4 part that is messing you up?

What is the version of the operating system these "people" are running
an 8.0.5 system that actually still work?

On Jun 17, 1:59*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
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

Dan:

#*It has services but no actual database.

So rip out the windows services and start again?

#I want to run svrmgr30 to run the create database command but can't
do it.

Been a real long time since 8.0 and svrmgr ... but you should be able
to run the create database sql commands from sqlplus right?

On Jun 17, 3:22*pm, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
John,
I did start again yesterday, I reinstalled Oracle from scratch and
rebuild the database. No luck. When I try to just delete the
database via the database configuration assistant, it fails because it
can't log onto it's own utility (probably svrmgr30) to do the drop.
So I'm stymied.

I don't think 8.0 can build databases with sqlplus. I'm pretty sure
that "sqlplus /nolog" and "connect / as sysdba" started in 9i. I
tried it in any event and still got the same error. In one of my
blogs I read about the oranav and how you need it if you have an
interchange in your network. I don't even know what that is.

Dan

Dan:

I don't do oracle on windows so my knowledge is fairly limited. I
think you need to do something special to get rid of the Oracle
"services" that windows uses ( should be pretty well documented in the
Oracle documentation ) and/or registry entries.

Some special command to get rid of the windows oracle services do some
googling around if necessary. ( Oradim maybe ? ).

A unix install can be cleaned up just by deleting files and
directories ( everything is a file in unix right ) but windows has
complications.


# I don't think 8.0 can build databases with sqlplus. *I'm pretty sure
that "sqlplus /nolog" and "connect / as sysdba" started in 9i.

connect internal

On 18/06/11 00:52, John Hurley wrote:
To remove Oracle services:

Delete any references to Oracle services left behind in the following
part of the registry:

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*

Total clean of Oracle install, one of many URLs

http://www.cryer.co.uk/brian/oracle/...l_oracle9i.htm
--
S. Anthony Sequeira
+44 7542 455 233
++
You are not permitted to kill a woman who has wronged you, but nothing
forbids you to reflect that she is growing older every minute. You are
avenged fourteen hundred and forty times a day.
-- Ambrose Bierce
++

Why would svrmgr try to connect to a database using TNS?

Why would it try to connect to a remote database?

Do you perhaps have LOCAL or TWO_TASK defined?


open a dos-box in your whinedoze environment, and try

echo %LOCAL%
echo %TWO_TASK%


or verify the output from "set"

On Jun 17, 9:15*pm, Dan <daniel.oster... (AT) visaer (DOT) com> wrote:
To delete an Oracle service:

C:\> oradim -delete -sid <sid_name>

HTH
-g