Oracle login failure Error

 

The following error is reported when you log on to PL/SQL today:

Ora-01033: oracle initializationg or shutdown in progress, unable to connect to Oracle service,

The possible cause of the error is that the archive log has just been deleted, and you have checked it online. In combination with the error message, follow these steps:

-- 1. Connect to sqlplus:

> Sqlplus "/as sysdba"

-- 2. Close the database:

SQL> shutdown immediate

ORA-01109: the database is not open

The database has been detached.

The ORACLE routine has been disabled.

-- 3. Restart the database:

SQL> startup

The ORACLE routine has been started.

Total System Global Area 612368384 bytes

Fixed Size 1250428 bytes

Variable Size 230689668 bytes

Database Buffers 373293056 bytes

Redo Buffers 7135232 bytes

The database has been loaded.

ORA-16038: log 2 serial number 27 cannot be archived

ORA-19809: exceeds the limit on the number of recovery files

ORA-00312: Online log 2 thread 1:

'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORA10 \ REDO02.LOG'

-- 4. Archive REDO02.LOG:

SQL> alter database clear unarchived logfile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORA10 \ REDO02.LOG ';

The database has been changed.

-- 5. Open

SQL> alter database open;

The database has been changed.

-- 6. Shut down the database again:

SQL> shutdown immediate;

-- 7. Restart the database again and report the following error:

SQL> startup

The ORACLE routine has been started.

The database has been loaded.

ORA-16038: Log 1 Serial Number 32 unable to archive

ORA-19809: exceeds the limit on the number of recovery files

ORA-00312: Online log 1 thread 1:

'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORA10 \ REDO01.LOG'

-- 8. Archive REDO01.LOG again:

SQL> alter database clear unarchived logfile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORA10 \ REDO01.LOG ';

The database has been changed.

-- 9. Solve the problem.

SQL> conn scott/tiger @ ora10

Connected.