Wednesday, 2 July 2014

Oracle Shut Downing Steps

> sqlplus /nolog

SQL> connect / as sysdba

Connected.

SQL> shutdown abort

ORACLE Instance shut down.

SQL> startup nomount

ORACLE Instance started

SQL> alter database mount;

SQL> alter database open;
Which still gave the error:

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

I then found the advice to do the following:

SQL> startup mount

ORACLE Instance started

SQL> recover database

Media recovery complete

SQL> alter database open

Database altered

No comments:

Post a Comment