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

Description:
ARC fails, but it seems the problem began in the ALEPH oracle:

oracle@aleph(arc2)arc2/trace$cd /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/alert_aleph20.log
oracle@aleph(arc2)arc2/trace$more alert_aleph20.log
....

Thu Feb 24 09:33:28 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_cjq0_13023.trc:

oracle@aleph(arc2)aleph20/trace$more /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_cjq0_13023.trc
*** 2011-02-24 09:33:39.123
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-02097: parameter cannot be modified because specified value is invalid


In the log file of www_server:
**********************************
www_server.log
**********************************
2011-02-24 09:34:38 04 [000] [vrb] IN 20110224 093438
ip address: 10.10.21.28 1403
request: "/F/AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3-16069?func=short-jump&jump=000241"
Cookie: __utma <21736127.922527093.1297708962.1298553867.1298555813.31>
Cookie: __utmz <(none)t)|utmcmd8962.1.1.utmcsr>
Cookie: __utmb <21736127.2.10.1298555813>
Cookie: __utmc <21736127>
Cookie: UserContext <3fcba2546e1144ae918455864f03a479>
Cookie: ALEPH_SESSION_ID <AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3>
Header: Accept <*/*>
Header: Referer <http://www.usat.edu.pe:8991/F/AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3-15881?func=short-jump&jump=000231>
Header: Accept-Language <es-pe>
Header: User-Agent <Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)>
Header: Accept-Encoding <gzip, deflate>
Header: Host <www.usat.edu.pe:8991>
Header: Connection <Keep-Alive>
Header: Cookie <__utma=21736127.922527093.1297708962.1298553867.1298555813.31; __utmz=21736127.1297708962.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utmb=21736127.2.10.1298555813; __utmc=21736127; UserConte>

Oracle error: update_cursor z63
ORA-03135: connection lost contact
Process ID: 9910
Session ID: 390 Se

Oracle error: io_commit
ORA-03114: not connected to ORACLE

***************************************************
* No ORACLE connection - process is terminated... *
***************************************************
Load: /exlibris/aleph/u20_1/alephe/tab/tab_system_status
Load: /exlibris/aleph/u20_1/alephe/tab/server_ip_allowed
2011-02-24 09:34:38 21 [000] [vrb] IN 20110224 093438
ip address: 10.10.21.28 1544
request: "/F/AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3-16069?func=short-jump&jump=000241"

Oracle error: handle_connection
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does no

<end log file of www_server>


The failed in Aleph Oracle provoked that the system ARC was stopping:
CM-SYS-5007
Content Manager build {Build} failed to start Review the Content Manager log files and the contact your system administrator or customer support.

Resolution:
Oracle on both sides, aleph and arc, was checked and found OK.
OPAC and ARC reports were ran and found to be without error.
The last ORA error was shown on 24 Feb. Is it posible that the error was fixed or disappeared due to some change in the network connection?

• Article last edited: 10/8/2013