Oracle Database Discussions

Hello,

I'm trying to create an 8.1.7.0 database on a W2k server, but it is failing because as soon as svrmgrl is launched, I get an ORA-12560, TNS: protocol adapter error:

D:\oracle\db_creation_scripts>D:\oracle\ora81\bin\svrmgrl @D:\oracle\db_creation_scripts\mterm62run.sql

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNS:protocol adapter errorEcho ON
SVRMGR> connect INTERNAL/manager
ORA-12560: TNS:protocol adapter error
SVRMGR> startup nomount pfile="D:\oracle\admin\mterm62\pfile\initmterm62.ora"
LCC-00161: Message 161 not found; product=RDBMS; facility=MGR

My ORACLE_HOME, ORACLE_SID, and TNS_ADMIN environmental variables are correctly set, and I'm able to tnsping the listener.

I've enabled tracing, and my client trace file is:

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is d:\trace\client_trace.log_2084_9.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source d:\oracle\ora81\network\admin\sqlnet.ora
Parameter source loaded successfully

Attempted load of local pfile source D:\oracle\db_creation_scripts\sqlnet.ora
Parameter source was not loaded

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_DIRECTORY_SERVER = d:\trace
TRACE_DIRECTORY_CLIENT = d:\trace
NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME)
SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf
TRACE_FILE_CLIENT = client_trace.log
TRACE_FILE_SERVER = server_trace.log
SQLNET.AUTHENTICATION_SERVICES = (NTS)
TRACE_UNIQUE_CLIENT = on
TRACE_LEVEL_CLIENT = ADMIN
TRACE_LEVEL_SERVER = ADMIN
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "D:\oracle\db_creation_scripts\sqlnet.log"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nigini: entry
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbi: entry
nrigbni: entry
nrigbni: Unable to get data from navigation file tnsnav.ora
nrigbni: exit
nrigbi: exit
nigini: exit
niqname: Hst is already an NVstring.
niqname: Inserting CID.
niotns: entry
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleMTERM62)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=MTERM62)(CID=(PROGRAM=D:\oracle\ora81\bin\SVRMGRL.EXE)(HOST=SERV0354)(USER=tarisa))))
nsmal: 140 bytes at 0x12493f0
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nlpcaini: entry
nlpcaini: prg =
nlpcaini: arg[0] =
nlpcaini: arg[1] =
nlpcaini: exit
nsmal: 420 bytes at 0x12542f0
nsmal: 1712 bytes at 0x12572f0
nsopen: opening transport...
ntpcon: entry
ntpcon: toc = 1
sntpcall: entry
snlpcss: entry
ntpcon: exit
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=2, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nsmfr: 1712 bytes at 0x12572f0
nsmfr: 420 bytes at 0x12542f0
nladget: entry
nladget: exit
nsmfr: 140 bytes at 0x12493f0
nladtrm: entry
nladtrm: exit
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12560
nioqper: ns (2) err code: 0
nioqper: nt main err code: 530
nioqper: nt (2) err code: 2
nioqper: nt OS err code: 0
niomapnserror: entry
niqme: entry
niqme: reporting NS-12560 error as ORA-12560
niqme: exit
niomapnserror: returning error 12560
niomapnserror: exit
niotns: Couldn't connect, returning 12560
niotns: exit
nigtrm: Count in the NI global area is now 0
nnfgdei: entry
nrigbd: entry
nrigbd: exit
nigtrm: Count in the NL global area is now 0

My tnsnames, listener and sqlnet.ora files are very simple:

## BEGIN TNSNAMES.ORA
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

MTERM62 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.1.75)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mterm62)
(INSTANCE_NAME = mterm62)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.1.75)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = mterm62)
(PRESENTATION = http://admin)
)
)

# LISTENER.ORA Network Configuration File: D:\oracle\ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = serv0354)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_DESC =
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = mterm62)
)
)
TRACE_LEVEL_LISTENER = ADMIN

# SQLNET.ORA Network Configuration File: D:\oracle\ora81\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

TRACE_DIRECTORY_CLIENT = d:\trace

TRACE_UNIQUE_CLIENT = on

TRACE_DIRECTORY_SERVER = d:\trace

SQLNET.AUTHENTICATION_SERVICES= (NTS)

TRACE_FILE_CLIENT = client_trace.log

TRACE_FILE_SERVER = server_trace.log

TRACE_LEVEL_CLIENT = ADMIN

TRACE_LEVEL_SERVER = ADMIN

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

Does anyone have any ideas what else I can check. I'm a Unix person, not a Windows person, which is making it even more complicated. If I was on Unix, I'd just blow everything away and start again from scratch, but since I'm not sure how to remove all traces from the registry, etc., I don't want to try that on this machine. There was already one other database created, but it's not goign to be used.

Any help would be greatly appreciated.

regards,

Tarisa.