Sunday, May 19, 2013

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

Scenerio
----------


Oracle 9.2.0.1 on Windows

After a power failure, when tried to startup the database normally, it did not start.
The database status was 'MOUNTED'. When tried with 'alter database open; the error was :
 
ORA-00600: internal error code, arguments: [kcratr1_lostwrt],[], [],[], [],[], [], []

Work around
---------------

SQL> Shutdown Immediate;
SQL> STARTUP MOUNT;
SQL> RECOVER DATABASE;
SQL> ALTER DATABASE OPEN;



Tuesday, May 7, 2013

ORA-12547: TNS: lost contact

Scenerio
----------
Local connection fails when connecting with / as sysdba

$ sqlplus
SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 7 12:15:02 2013
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name : / as sysdba
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:

Work around
---------------

Relink the Oracle binaries by executing the following command,

$ cd ORACLE_HOME/bin
$ relink all


$ sqlplus

SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 7 12:17:05 2013

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production