Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Error in NCIP-server etc. probably caused by Oracle error

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    NCIP-server , SIP2-server and other programs sometimes stops with an error.
    From the ncip_server log:

    2011-07-22 13:11:59 50
    Read 1426 Bytes
    Error: create_library_file_name - no env variable found for _dev
    defaulting to aleph_dev.... tab100
    Error: create_library_file_name - no env variable found for _dev
    defaulting to aleph_dev.... tab100_

    Oracle error: handle_connection
    ORA-12537: TNS:connection closed

    Info: Empty table /tmp/utf_files/exlibris/aleph/u18_1/u18_5/alephe/error_/ncip_server
    Info: Empty table /tmp/utf_files/exlibris/aleph/u18_1/u18_5/alephe/error_/global
    Info: Empty table /tmp/utf_files/exlibris/aleph/a18_1/aleph/error_/ncip_server
    Info: Empty table /tmp/utf_files/exlibris/aleph/a18_1/aleph/error_/global
    Load: /exlibris/aleph/u18_1/u18_5/alephe/tab/tab100
    2011-07-22 13:11:59 Error 5000 Not defined in file ncip_server.

    The system run TWO_TASK, and on the Oracle server we get this error in /exlibris/app/oracle/product/102/network/log/listener.log:

    22-JUL-2011 13:11:59 * (connect_data=(sid=abc18)(server=DEDICATED)(CID=(PROGRAM=ncip_server_main)(HOST=dc03vg0012eu)(USER=aleph))) * (ADDRESS=(PROTOCOL=tcp)(HOST=95.172.90.22)(PORT=61339)) * establish * abc18 * 12518
    TNS-12518: TNS:listener could not hand off client connection
    TNS-12547: TNS:lost contact
    TNS-12560: TNS:protocol adapter error
    TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

    At the same time in i /exlibris/app/oracle/admin/abc18/udump files with this Oracle error is created:

    ORA-00020: maximum number of processes 150 exceeded

    Resolution:
    I have made a crontab job that restarts the sip2_server at 09:00 each morning.

    This should keep the number of processes in Oracle at at acceptable level.


    • Article last edited: 10/8/2013
    //doorbell.io feedback widged