Clear Oracle Trace files in Linux

In udump folder

# find *.trc -mtime +5 -exec rm {} \;

This removes files older than 5 days

Oracle connection error

Error on connecting to Oracle, only sys as sysdba could connect but wih no access to objects. If I tried to shutdown I got this message.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

On starting up I get the following.

SQL> startup
ORACLE instance started.

Total System Global Area 496049544 bytes
Fixed Size 454024 bytes
Variable Size 209715200 bytes
Database Buffers 285212672 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01113: file 148 needs media recovery
ORA-01110: data file 148: 'H:\ORACLE\ORADATA\CALLS_TAB38.DBF'

It seems one of the data files was corrupt.

Solution
========
SQL>shutdown
SQL>startup mount
SQL>recover database
SQL>alter database open;

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

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

Solution SQL>alter system flush buffer_cache;

Am Back!!

It has been slightly over a year since I last "blogged". I guess I am back....