Thursday, July 11, 2013

ERROR: ORA-00257: archiver error. and ORA-03113: end-of-file on communication channel

If Anyone face this error so refer this command.....


Enter user-name: neeraj
Enter password:
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.


Warning: You are no longer connected to ORACLE.


SQL> startup mount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size            2213776 bytes
Variable Size          905971824 bytes
Database Buffers      687865856 bytes
Redo Buffers            7360512 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 30790
Session ID: 4519 Serial number: 5



SQL> startup mount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size            2213776 bytes
Variable Size          905971824 bytes
Database Buffers      687865856 bytes
Redo Buffers            7360512 bytes
Database mounted.

SQL> alter system set db_recovery_file_dest_size=6g scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size            2213776 bytes
Variable Size          905971824 bytes
Database Buffers      687865856 bytes
Redo Buffers            7360512 bytes
Database mounted.
Database opened.

All d best.... :)
enjoy.....

No comments:

Post a Comment