This discussion is archived
12 Replies Latest reply: Jul 23, 2013 5:32 AM by Srini Chavali-Oracle RSS

Oracle database upgrade failed due to ORA-600

venkatasudheery Newbie
Currently Being Moderated

Hi Team,

 

I was trying to upgrade my stand alone database from 10.2.0.3 to 11.2.0.1. The OS is AIX 6.0, its HACMP cluster (which one of node is down). During the upgrade at xdb the oracle upgrade process has failed with ORA error.

 

 

Please let me know what can be done as The upgrade was stopped in between.

 

from catupgrd.log

2269  2tWY2pY/umK1A6n4/gYjDbxa//lwT3KuHx5DmP4f2JH2xNd18ZWYCtlOE9VN7CG9tvYUym/1

2270  yAgCxuRupEOWlCURc1A67ggoX55JrrdMmdTY+ks3upr7gMLz2CAPZCDiD5YZlnLx6E87TD4K

2271  zC4NBjAuMRjWDUO1u7Uo7oYNxg==

2272 

2273  /

CREATE OR REPLACE package body dbms_stats wrapped

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

ERROR:

ORA-03114: not connected to ORACLE

ERROR:

ORA-03114: not connected to ORACLE

ERROR:

ORA-03114: not connected to ORACLE

 

 

ALERT LOG:

 

SERVER COMPONENT id=XML: status=VALID, version=11.2.0.1.0, timestamp=2013-07-19 19:47:48

 

Fri Jul 19 19:48:42 2013

 

Thread 1 cannot allocate new log, sequence 3993

 

Checkpoint not complete

 

  Current log# 2 seq# 3992 mem# 0: /data/oradata/xxxxxx/redo02.log

 

Thread 1 advanced to log sequence 3993 (LGWR switch)

 

  Current log# 3 seq# 3993 mem# 0: /data/oradata/xxxxxx/redo03.log

 

Fri Jul 19 19:50:00 2013

 

Thread 1 advanced to log sequence 3994 (LGWR switch)

 

  Current log# 1 seq# 3994 mem# 0: /data/oradata/xxxxxx/redo01.log

 

Fri Jul 19 19:50:22 2013

 

Errors in file $DIAG/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_ora_3817488.trc  (incident=1353):

 

ORA-00600: internal error code, arguments: [qmx: no ref], [], [], [], [], [], [], [], [], [], [], []

 

Incident details in: $DIAG/diag/rdbms/xxxxxx/xxxxxx/incident/incdir_1353/xxxxxx_ora_3817488_i1353.trc

 

Fri Jul 19 19:50:42 2013

 

Errors in file $DIAG/diag/rdbms/xxxxxx/xxxxxx/incident/incdir_1353/xxxxxx_ora_3817488_i1353.trc:

 

ORA-00308: cannot open archived log '/data/redolog/1_1465_616683947.arc'

 

ORA-27037: unable to obtain file status

 

IBM AIX RISC System/6000 Error: 2: No such file or directory

 

Additional information: 3

 

ORA-00600: internal error code, arguments: [qmx: no ref], [], [], [], [], [], [], [], [], [], [], []

 

Errors in file $DIAG/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_ora_3817488.trc  (incident=1354):

 

ORA-00600: internal error code, arguments: [qmx: no ref], [], [], [], [], [], [], [], [], [], [], []

 

Incident details in: $DIAG/diag/rdbms/xxxxxx/xxxxxx/incident/incdir_1354/xxxxxx_ora_3817488_i1354.trc

 

Fri Jul 19 19:50:43 2013

 

Sweep [inc][1353]: completed

 

Sweep [inc2][1353]: completed

 

Fri Jul 19 19:50:43 2013

 

Trace dumping is performing id=[cdmp_20130719195043]

 

Fri Jul 19 19:51:03 2013

 

Errors in file $DIAG/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_ora_3817488.trc  (incident=1355):

 

ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []

 

Incident details in: $DIAG/diag/rdbms/xxxxxx/xxxxxx/incident/incdir_1355/xxxxxx_ora_3817488_i1355.trc

 

Fri Jul 19 19:51:03 2013

 

Trace dumping is performing id=[cdmp_20130719195103]

 

Fri Jul 19 19:51:23 2013

 

Errors in file $DIAG/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_ora_3817488.trc:

 

Errors in file $DIAG/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_ora_3817488.trc  (incident=1356):

 

ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []

 

Incident details in: $DIAG/diag/rdbms/xxxxxx/xxxxxx/incident/incdir_1356/xxxxxx_ora_3817488_i1356.trc

 

Fri Jul 19 19:51:24 2013

 

Trace dumping is performing id=[cdmp_20130719195124]

 

Fri Jul 19 19:51:37 2013

 

Errors in file $DIAG/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_ora_3817488.trc  (incident=1357):

 

ORA-00700: soft internal error, arguments: [kgerev1], [600], [600], [700], [], [], [], [], [], [], [], []

 

Incident details in: $DIAG/diag/rdbms/xxxxxx/xxxxxx/incident/incdir_1357/xxxxxx_ora_3817488_i1357.trc

 

Fri Jul 19 19:51:38 2013

 

Trace dumping is performing id=[cdmp_20130719195138]

 

Please let me know how to proceed further.

 

Thanks and Regards

Venkata Sudheer

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points