listener error - connections failing or are slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: listener error - connections failing or are slow

  1. #1
    Join Date
    Jul 2003
    Posts
    131

    Exclamation listener error - connections failing or are slow

    Oracle 10g; Windows 2003 server

    This server/db is about 2 weeks old. It was working fine but now the connection to db are getting real slow or they are failing most of the times. The error it shows are:
    TNS-12571: TNSacket writer failure
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 54: Unknown error
    TNS-12500: TNS:listener failed to start a dedicated server process

    See this from actual listener.log:
    -------------------------------
    29-AUG-2006 10:12:17 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    29-AUG-2006 10:12:17 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    29-AUG-2006 10:12:17 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MYDB)(CID=(PROGRAM=D:\oracle\product\10g\db_1\bin\nmup m.exe)(HOST=MYDB)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=IPADDRESS)(PORT=2380)) * establish * MYDB * 12571
    TNS-12571: TNSacket writer failure
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 54: Unknown error
    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12560: TNSrotocol adapter error
    29-AUG-2006 10:13:39 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MYDB)(CID=(PROGRAM=D:\oracle\product\10g\db_1\bin\nmup m.exe)(HOST=MYDB)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=IPADDRESS)(PORT=2383)) * establish * MYDB * 0
    29-AUG-2006 10:13:39 * (CONNECT_DATA=(SID=MYDB)(CID=(PROGRAM=D:\oracle\product\10g\db_1\perl\5.6.1\bin\MSWin32-x86\perl.exe)(HOST=MYDB)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=IPADDRESS)(PORT=2385)) * establish * MYDB * 0
    ------------------------------------

    After listener restart, it worked fine for few minutes and then started showing errors like before. There is no error in sqlnet.log file.

    Please suggest whats going wrong here and its fix. I have 5 other servers like that and they are all working fine.
    -D

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'd look at memory on the server.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jul 2003
    Posts
    131
    Quote Originally Posted by marist89
    I'd look at memory on the server.
    Memory is not the issue. There is plenty. The difference that I noticed between this server/db and other working servers/db is that they are not MTS setup but this one is has these entries in registry.

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService

    ORAMTS_NET_CACHE_MAXFREE = 5
    ORAMTS_NET_CACHE_TIMEOUT = 120000
    ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
    ORAMTS_SESS_TXNTIMETOLIVE = 120

    Also heer is my TNSNAMES.ora entry on server:
    ------------------------------------------------
    MYDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = MYDB)
    )
    )

    and, LISTENER.ora entry
    -------------------------------------------
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\product\10g\db_1)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = MYDB)
    (ORACLE_HOME = D:\oracle\product\10g\db_1)
    (SID_NAME = MYDB)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
    )
    )
    )


    -D

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