listener hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: listener hangs

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Posts
    170

    listener hangs

    I installed oracle 8.1.7 on windows 2000 m/c. The installed completed succesfully. I see the tnslistener serveice is started throught the windows services. When I run lstnrctl stop it stops the listener but when I run the lstnrctl start it just hangs.

    When I am trying to create a database using the db configuration assitant it fails complaining 12560: TNS protocol adapter error. I have re-installed couple of times but same problem.

    I got the following error the first time
    =========================================
    LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 04-OCT-2004 11:15:10
    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Starting tnslsnr: please wait...

    Service OracleOraHome81TNSListener already running.
    TNS-12536: TNSperation would block
    TNS-12560: TNSrotocol adapter error
    TNS-00506: Operation would block
    32-bit Windows Error: 997: Unknown error

    Remove the listener service from registry and start the listener using
    lsnrctl start
    Getting the following error
    ============================
    H:\>lsnrctl start

    LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 04-OCT-2004 11:41:
    54

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Starting tnslsnr: please wait...

    Failed to open service , error 1060.


    listener.ora looks like the following.
    ======================================
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.250.150.121)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\ora81)
    (PROGRAM = extproc)
    )
    )

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    In my listener on my local box I have this listed

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\ora92)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = Smokey)
    (ORACLE_HOME = D:\oracle\ora92)
    (SID_NAME = Smokey)
    )

    I named the database instance Smokey, is there anything more in your listener file?
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width