Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Bangalore India
    Posts
    2

    Unanswered: Listener giving out of stream error

    Hi Gurus,
    I have a SCO/Oracle 8 operation. For the past few weeks the listener suddenly starts generating immense log information. the message is "out of stream ". I haveonly increased the number of clients from 30 to 40 machines before this problem occured.
    Please advise
    TIA
    A.Varadarajan

    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL= IPC)(KEY= ora))
    (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
    (ADDRESS= (PROTOCOL= TCP)(Host= INDAL)(Port= 1521))
    (ADDRESS= (PROTOCOL= TCP)(Host= INDAL)(Port= 1522))
    (ADDRESS= (PROTOCOL= TCP)(Host= INDAL)(Port= 1523))
    (ADDRESS= (PROTOCOL= TCP)(Host= INDAL)(Port= 1524))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME= INDAL.INDAL)
    (ORACLE_HOME= /home/oracle)
    (SID_NAME = ora)
    )
    (SID_DESC =
    (SID_NAME = extproc)
    (ORACLE_HOME = /home/oracle)
    (PROGRAM = extproc)
    )
    )
    STARTUP_WAIT_TIME_LISTENER= 0
    CONNECT_TIMEOUT_LISTENER= 20
    TRACE_LEVEL_LISTENER= OFF

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore India
    Posts
    2
    This is the exact message i have recieved

    TNS-12560:TNS protocol adapter error
    TNS-00530 Protocol adapter error
    Intel SVR4 Unix error :63: Out of stream Resources
    TIA
    Anand

Posting Permissions

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