OK that means that the listener is running on that machine. (hence the
operation would block error). running lsnrctl status will tell you the
status of the listener.
What does tnsnames.ora say for the db you are trying to connect to?
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"dominant" <member32241_at_dbforums.com> wrote in message
news:3540463.1067516999_at_dbforums.com...
>
> here is my attempt
>
>
>
> C:\>lsnrctl start
>
>
>
> LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-OCT-
> 2003 14:13:29
>
>
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
>
>
> Starting tnslsnr: please wait...
>
>
>
> Failed to start service, error 3.
>
> TNS-12536: TNS:operation would block
>
> TNS-12560: TNS:protocol adapter error
>
> TNS-00506: Operation would block
>
> 32-bit Windows Error: 997: Unknown error
>
>
>
> C:\>
>
>
>
>
>
> I think the listener.ora is properly configured, here is it's content
>
>
>
>
>
> # LISTENER.ORA Network Configuration File:
> # E:\oracle\ora92\network\admin\listener.ora
>
> # Generated by Oracle configuration tools.
>
>
>
> LISTENER =
>
> (DESCRIPTION_LIST =
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>
> )
>
> )
>
> )
>
>
>
> SID_LIST_LISTENER =
>
> (SID_LIST =
>
> (SID_DESC =
>
> (GLOBAL_DBNAME = dika)
>
> (ORACLE_HOME = E:\oracle\ora92)
>
> (SID_NAME = dika)
>
> )
>
> )
>
>
> --
> Posted via http://dbforums.com
Received on Thu Oct 30 2003 - 09:00:16 CST
