Aleph 23: ue_01 process ends with: ORA-03113: end-of-file on communication channel
- Product: Aleph
- Product Version: 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
This article is relevant for TWO_TASK systems only.
The log file of process ue_01 contains the following
Oracle error: io_commit
ORA-03113: end-of-file on communication channel
Process ID: 5903
Sessi
***************************************************
* No ORACLE connection - process is terminated... *
***************************************************
Resolution
1. login as ssh user oracle
2. cd $ORACLE_HOME/network/admin
3. open the sqlnet.ora file (if is not there, then copy it from the $ORACLE_HOME/network/admin/samples directory to $ORACLE_HOME/network/admin)
4. remove everything from the sqlnet.ora file, copy these 2 lines to it:
SQLNET.EXPIRE_TIME = 10
USE_NS_PROBES_FOR_DCD=true
5. save the file.
Additional Information
A similar case for Aleph 16 is described in article ue_01 gets "end-of-file on communication channel" errors
- Article last edited: 31-Mar-2016