ORA-00600: internal error code, arguments: [4194], [15], [4], [], [], [], [], [], [], [], [], []
ERROR From Alert
Fri Mar 09 16:16:29 2018
Recovery of Online Redo Log: Thread 1 Group 5 Seq 3629 Reading mem 0
Mem# 0: D:\ORACLE\DATABASE\ORADATA\GINESYS\REDO05.LOG
Mem# 1: D:\ORACLE\DATABASE\ORADATA\GINESYS\REDO05A.LOG
Block recovery completed at rba 3629.123.16, scn 1.2379589176
Errors in file D:\ORACLE\DATABASE\diag\rdbms\ginesys\ginesys\trace\ginesys_pmon_3288.trc (incident=21619):
ORA-00600: internal error code, arguments: [4194], [15], [4], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Mar 09 16:16:30 2018
Errors in file D:\ORACLE\DATABASE\diag\rdbms\ginesys\ginesys\trace\ginesys_pmon_3288.trc:
ORA-00600: internal error code, arguments: [4194], [15], [4], [], [], [], [], [], [], [], [], []
USER (ospid: 3288): terminating the instance due to error 472
Fri Mar 09 16:16:31 2018
System state dump requested by (instance=1, osid=3288 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file D:\ORACLE\DATABASE\diag\rdbms\ginesys\ginesys\trace\ginesys_diag_3912.trc
Dumping diagnostic data in directory=[cdmp_20180309161631], requested by (instance=1, osid=3288 (PMON)), summary=[abnormal instance termination].
Fri Mar 09 16:16:42 2018
Instance terminated by USER, pid = 3288
Fri Mar 09 16:30:38 2018
WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD)
Starting ORACLE instance (normal)
Fri Mar 09 16:30:38 2018
SOLUTION For the above error Metalink (Doc ID 281429.1)
PS C:\Users\Administrator> lsnrctl start
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 09-MAR-2018 16:28:36
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
System parameter file is D:\Oracle\Database\Ora12cDB\network\admin\listener.ora
Log messages written to D:\Oracle\Database\diag\tnslsnr\NNOLDSERVER\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NNOLDSERVER)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=NNOLDSERVER)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
Start Date 09-MAR-2018 16:28:42
Uptime 0 days 0 hr. 0 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle\Database\Ora12cDB\network\admin\listener.ora
Listener Log File D:\Oracle\Database\diag\tnslsnr\NNOLDSERVER\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NNOLDSERVER)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "GINESYS" has 1 instance(s).
Instance "GINESYS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
PS C:\Users\Administrator> sqlplus sys/****** as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri Mar 9 16:30:21 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2104479744 bytes
Fixed Size 2404600 bytes
Variable Size 1308626696 bytes
Database Buffers 788529152 bytes
Redo Buffers 4919296 bytes
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\ORACLE\DATABASE\ORA12CDB\DA
TABASE\SPFILEGINESYS.ORA
SQL> create pfile='d:\pfile_9march.ora' from spfile;
File created.
SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
In the Pfile change parameter *.UNDO_MANAGEMENT to MANUAL
SQL> startup mount pfile='d:\pfile_9march.ora'
ORACLE instance started.
Total System Global Area 2104479744 bytes
Fixed Size 2404600 bytes
Variable Size 1308626696 bytes
Database Buffers 788529152 bytes
Redo Buffers 4919296 bytes
Database mounted.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter database open;
Database altered.
SQL> create rollback segment roll01;
Rollback segment created.
SQL> alter rollback segment roll01 online;
Rollback segment altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:\ORACLE\DATABASE\ORADATA\GINESYS\SYSTEM01.DBF
D:\ORACLE\DATABASE\ORADATA\GINESYS\INDX01
D:\ORACLE\DATABASE\ORADATA\GINESYS\SYSAUX01.DBF
D:\ORACLE\DATABASE\ORADATA\GINESYS\GINOLAP01
D:\ORACLE\DATABASE\ORADATA\GINESYS\UNDOTBS01.DBF
D:\ORACLE\DATABASE\ORADATA\GINESYS\USERS01.DBF
D:\ORACLE\DATABASE\ORADATA\GINESYS\GIN_TS_TX_DATA_01
D:\ORACLE\DATABASE\ORADATA\GINESYS\GIN_TS_SUMMARY_01
D:\ORACLE\DATABASE\ORADATA\GINESYS\GIN_TS_NOLOGGING_01
9 rows selected.
SQL> create undo tablespace undotbs02 datafile 'D:\ORACLE\DATABASE\ORADATA\GINESYS\UNDOTBS02.dbf' size 2g;
Tablespace created.
SQL> drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2104479744 bytes
Fixed Size 2404600 bytes
Variable Size 1308626696 bytes
Database Buffers 788529152 bytes
Redo Buffers 4919296 bytes
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_tablespace=undotbs02 scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2104479744 bytes
Fixed Size 2404600 bytes
Variable Size 1308626696 bytes
Database Buffers 788529152 bytes
Redo Buffers 4919296 bytes
Database mounted.
Database opened.
SQL>
No comments:
Post a Comment