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

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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