Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I trace hanging "connect / as sysdba"?
Oops, sorry about that - here are the correct results I hope!
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on
18-FEB-2006 19:41:
50
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0- Produc
Start Date 18-FEB-2006 17:25:29 Uptime 0 days 2 hr. 16 min. 22 sec Trace Level off Security OFF SNMP OFF Listener Parameter File C:\oracle\ora92\network\admin\listener.ora Listener Log File C:\oracle\ora92\network\log\listener.logListening Endpoints Summary...
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on
18-FEB-2006 21:07:
47
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ash)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
Handler(s):
"DEDICATED" established:0 refused:0 LOCAL SERVER
There should be more services shouldn't there?
I don't know what to use for <your_tns_service>
Great! So there is something in the authentication process which is causing the hang do you think?
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
sqlnet.authentication_services=(none)
# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database onNT.
NAMES.DIRECTORY_PATH= (TNSNAMES) sqlnet.trace_level_client=admin
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 18-FEB-2006 17:25:27 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is C:\oracle\ora92\network\admin\listener.ora Log messages written to C:\oracle\ora92\network\log\listener.log Trace information written to C:\oracle\ora92\network\trace\listener.trc Trace level is currently 0
Started with pid=920
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ash.tvs)(PORT=1521)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
CODE
18-FEB-2006 19:41:50 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=peter))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352))
* status * 0
18-FEB-2006 21:07:47 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=peter))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352))
* services * 0
18-FEB-2006 21:08:54 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=peter))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352))
* services * 0
Sat Feb 18 17:26:06 2006
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'C:\ORACLE\ORA92\DATABASE\INITSTARTER3.ORA'
Sat Feb 18 17:26:07 2006
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'C:\ORACLE\ORA92\DATABASE\INITSTARTER1.ORA'
Sat Feb 18 17:26:22 2006
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'C:\ORACLE\ORA92\DATABASE\INITSTARTER5.ORA'
Sat Feb 18 17:26:22 2006
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'C:\ORACLE\ORA92\DATABASE\INITSTARTER2.ORA'