Gurus,
I receive the following error when attempting to startup my database.
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 1 13:01:28 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile = '/oracle/app/product/11.2.0/db_1/dbs/initrohl.ora'
ORACLE instance started.
Total System Global Area 2020970496 bytes
Fixed Size 2227416 bytes
Variable Size 1627390760 bytes
Database Buffers 385875968 bytes
Redo Buffers 5476352 bytes
ORA-03113: end-of-file on communication channel
Process ID: 977
Session ID: 178 Serial number: 3
SQL>
Any ideas on what I should try before I reach out to Oracle support?
Alert log details:
Mon Jun 01 12:25:52 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production.
ORACLE_HOME = /oracle/app/product/11.2.0/db_1
System name: SunOS
Node name: lago4prod
Release: 5.10
Version: Generic_147441-01
Machine: i86pc
Using parameter settings in client-side pfile /oracle/app/product/11.2.0/db_1/dbs/initrohl.ora on machine lago4prod
System parameters with non-default values:
processes = 300
sessions = 472
nls_length_semantics = "CHAR"
memory_target = 1936M
control_files = "/oracle/oradata/rohl/control01.ctl"
control_files = "/oracle/oradata/rohl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/oracle/archivelogs"
log_archive_format = "%t_%s_%r.dbf"
undo_tablespace = "UNDOTBS1"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=rohlXDB)"
cursor_sharing = "FORCE"
audit_file_dest = "/oracle/orabase/admin/rohl/adump"
audit_trail = "DB"
db_name = "rohl"
open_cursors = 300
optimizer_index_cost_adj = 10
optimizer_index_caching = 15
parallel_force_local = TRUE
diagnostic_dest = "/oracle/orabase"
Mon Jun 01 12:25:53 2015
PMON started with pid=2, OS id=5660
Mon Jun 01 12:25:54 2015
PSP0 started with pid=3, OS id=5662
Mon Jun 01 12:25:55 2015
VKTM started with pid=4, OS id=5664 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Jun 01 12:25:55 2015
GEN0 started with pid=5, OS id=5668
Mon Jun 01 12:25:55 2015
DIAG started with pid=6, OS id=5670
Mon Jun 01 12:25:55 2015
DBRM started with pid=7, OS id=5672
Mon Jun 01 12:25:55 2015
DIA0 started with pid=8, OS id=5674
Mon Jun 01 12:25:55 2015
MMAN started with pid=9, OS id=5676
Mon Jun 01 12:25:55 2015
DBW0 started with pid=10, OS id=5678
Mon Jun 01 12:25:55 2015
LGWR started with pid=11, OS id=5680
Mon Jun 01 12:25:55 2015
CKPT started with pid=12, OS id=5682
Mon Jun 01 12:25:55 2015
SMON started with pid=13, OS id=5684
Mon Jun 01 12:25:56 2015
RECO started with pid=14, OS id=5686
Mon Jun 01 12:25:56 2015
MMON started with pid=15, OS id=5688
Mon Jun 01 12:25:56 2015
MMNL started with pid=16, OS id=5690
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
DISM started, OS id=5696
ORACLE_BASE from environment = /oracle/orabase
Mon Jun 01 12:26:01 2015
ALTER DATABASE MOUNT
USER (ospid: 5701): terminating the instance
Mon Jun 01 12:26:06 2015
System state dump requested by (instance=1, osid=5701), summary=[abnormal instance termination].
System State dumped to trace file /oracle/orabase/diag/rdbms/rohl/rohl/trace/rohl_diag_5670.trc
Dumping diagnostic data in directory=[cdmp_20150601122606], requested by (instance=1, osid=5701), summary=[abnormal instance termination].
Instance terminated by USER, pid = 5701