ORA-03113: end-of-file on communication channel"
En el tracefile observo lo siguiente:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.1.7
System name: Linux
Node name: CentOS-XXXXX
Release: 2.4.9-e.74smp
Version: #1 SMP Thu Jan 22 10:28:33 EST 2009
Machine: i686
Instance name: xxxxx
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 19434, image: oracle@CentOS-XXXX
*** SESSION ID:(11.1) 2009-05-28 13:05:45.750
Exception signal: 11 (SIGSEGV)
*** 2009-05-28 13:05:45.854
ksedmp: internal or fatal error
Current SQL statement for this session:
BEGIN
dbms_java.server_startup
; END;
----- PL/SQL Call Stack -----
object line object
handle number name
51ea7318 0 package body SYS.DBMS_JAVA
51e99d34 2 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
Es obvio que el error esta relacionado con JVM del RDBMS.
Buscando en metalink encuentro:
Full JVM removal on 8.1.7 (includes re-installation steps) Doc ID: 159801.1
Purpose
-------------------
Assist in accomplishing a clean removal of a complete JVM installation on 8.1.7.
In the 8.1.7 version of the rdbms server there exists the potential to have a
wide variety of "java-related" functionality introduced into the database.
For an overview and description of the functionality alluded to,
please see Note 156477.1 "JVM installation on 8.1.7".
In prior versions of 8i it may have been sufficient to simply execute the
$ORACLE_HOME/javavm/install/rmjvm.sql script to remove the JVM from the database.
This isn't the case in the 8.1.7 version.
If other java-related scripts were executed in 8.1.7, for example,
initrepapi.sql, initxml.sql, and init_jis.sql there are additional steps needed
for a complete JVM removal. If only the initjvm.sql script has been run on 8.1.7 and no
other java-related scripts have been run subsequent to it, then the rmjvm.sql
script by itself should still be sufficient for JVM removal.
Siguiendo todos los paso:
- Elimino JVM del Oracle
- Check the System Requirements for a JVM Installation DocId: 204935.1
- Cambio _SYSTEM_TRIG_ENABLED=TRUE en el initXXX.ora,
- Re-instalo la JVM.
- Reinicio la base
