ORA-03113: end-of-file on communication channel

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 6 12:27:17 2017

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

Connected to an idle instance.

SQL> startup pfile='/home/oracle/pfile/initORADB.ora';
ORACLE instance started.

Total System Global Area 1.6034E+10 bytes
Fixed Size                  2262200 bytes
Variable Size            1.1241E+10 bytes
Database Buffers         4764729344 bytes
Redo Buffers               26484736 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 16974138
Session ID: 195 Serial number: 3

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 6 12:32:04 2017

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

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1.6034E+10 bytes

Fixed Size                  2262200 bytes

Variable Size            1.1241E+10 bytes

Database Buffers         4764729344 bytes

Redo Buffers               26484736 bytes

SQL> alter database mount;

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 clear unarchived logfile group 1;

Database altered.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1.6034E+10 bytes

Fixed Size                  2262200 bytes

Variable Size            1.1241E+10 bytes

Database Buffers         4764729344 bytes

Redo Buffers               26484736 bytes

Database mounted.

Database opened.

Note: To set the log archive destination :

SQL> startup nomount;

SQL> alter system set log_archive_start=TRUE SCOPE=SPFILE;

System altered.

SQL> alter system set log_archive_dest_1=’LOCATION=+FRA/oradb/archivelog’ SCOPE=SPFILE;

System altered.