Re: How do I trace hanging "connect / as sysdba"?

Dimitre and Frank,
Thanks for your comments. I have just got back from a bookshop where I was browsing the Oracle books!
I got some interesting results shown below:

C:\notes>net start | findstr /I oracle

   OracleMTSRecoveryService
   OracleOraHome92Agent
   OracleOraHome92HTTPServer
   OracleOraHome92TNSListener
   OracleServiceSTARTER1
   OracleServiceSTARTER2
   OracleServiceSTARTER3
   OracleServiceSTARTER5

C:\notes>lsnrctl status OracleOraHome92TNSListener

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 18-FEB-2006 17:30:26 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

TNS-01101: Could not find service name OracleOraHome92TNSListener  NNC-00405: network failure

C:\notes>lsnrctl services OracleOraHome92TNSListener

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 18-FEB-2006 17:31:
28

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

TNS-01101: Could not find service name OracleOraHome92TNSListener  NNC-00405: network failure

So it looks like there is a serious problem there which I need to investigate.

Thanks for the explanation about what is going on with connect / as sysdba.
The os user seems to be set up ok as an administrator member of group OS_DBA.
I am running McAfee Personal Firewall but that is not reporting any blocks.
> what happens when you try sqlplus /nolog
> and then connect / as sysdba?

That is what I did to get the hang.

>- you could add sqlnet.trace_level_client=admin
>in sqlnet.ora and see if it results in any .trc files.
I just tried this but get nothing.

Peter Received on Sat Feb 18 2006 - 11:53:50 CST