December 22 2014

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

ORA-00600: internal error code, arguments: [4194]
SQL> create undo tablespace undotbs2 datafile ‘/u01/app/oracle/oradata/orcl/undotbs02.dbf’ size 1000M;
create undo tablespace undotbs2 datafile ‘/u01/app/oracle/oradata/orcl/undotbs02.dbf’ size 1000M
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4194], [ody
“SYS.DBMS_STANDARD”otbs02.dbf*
SQL> shutdown immediate
ORA-03135: connection lost contact
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@gsoracle admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 19 14:55:55 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 7532736512 bytes
Fixed Size 2243032 bytes
Variable Size 1560282664 bytes
Database Buffers 5955911680 bytes
Redo Buffers 14299136 bytes
Database mounted.
Database opened.
SQL> create undo tablespace undotbs2 datafile ‘/u01/app/oracle/oradata/orcl/undotbs02.dbf’ size 1000M;
create undo tablespace undotbs2 datafile ‘/u01/app/oracle/oradata/orcl/undotbs02.dbf’ size 1000M
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 2877
Session ID: 191 Serial number: 3

SQL> create pfile from spfile;

File created.

*.undo_tablespace=’SYSTEM’
undo_management=’MANUAL’

SQL> create spfile from pfile;

File created.
SQL> create undo tablespace undotbs2 datafile ‘/u01/app/oracle/oradata/orcl/undotbs02.dbf’ size 1000M;

Tablespace created.

SQL> drop tablespace undotbs1;

Tablespace dropped.

SQL> alter system set undo_tablespace=”undotbs2” scope=spfile;

System altered.

SQL> alter system set undo_management=auto scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 7532736512 bytes
Fixed Size 2243032 bytes
Variable Size 1560282664 bytes
Database Buffers 5955911680 bytes
Redo Buffers 14299136 bytes
Database mounted.
Database opened.

 

 

这个错误是说undo表空间有了问题 重建就可以了



Copyright 2019. All rights reserved.

Posted 2014年12月22日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *