Tuesday, 21 August 2018

ORA-03113: end-of-file on communication channel Process ID: 10808 Solved

C:\WINDOWS\system32>SQLPLUS SYS AS SYSDBA

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 21 16:36:42 2018

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1469792256 bytes
Fixed Size                  2175848 bytes
Variable Size            1107299480 bytes
Database Buffers          352321536 bytes
Redo Buffers                7995392 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10808
Session ID: 5 Serial number: 3


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\WINDOWS\system32>sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 21 16:42:59 2018

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter password:
Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1469792256 bytes
Fixed Size                  2175848 bytes
Variable Size            1107299480 bytes
Database Buffers          352321536 bytes
Redo Buffers                7995392 bytes


SQL> alter database mount;

Database altered.

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database open;

Database altered.

No comments:

Post a Comment