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

From: DR <dr_at_invalid.address>
Date: Sat, 18 Feb 2006 19:01:31 +0100
Message-ID: <43f760ff$0$15784$14726298@news.sunsite.dk>

"pcroft" <pcroft_at_cix.co.uk> ha scritto nel messaggio news:1140285229.978123.236610_at_g47g2000cwa.googlegroups.com...
> 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.

OracleOraHome92TNSListener is not your listener name! Try with "lsnrctl status" (your listener name is "LISTENER").

Regards,
Dimitre Received on Sat Feb 18 2006 - 12:01:31 CST