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.....
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