Hi when ever I try to start up my Oracle DB i Get the following error:
SQL> startup;
ORACLE instance started.
Total System Global Area 1987563520 bytes
Fixed Size 2214696 bytes
Variable Size 1358955736 bytes
Database Buffers 620756992 bytes
Redo Buffers 5636096 bytes
ORA-03113: end-of-file on communication channel
Process ID: 4242
Session ID: 191 Serial number: 1
Below is the contents from the end of my alert.log
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /home/matt/app/matt/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 150
memory_target = 1904M
control_files = "/home/matt/app/matt/oradata/orcl/control01.ctl"
control_files = "/home/matt/app/matt/flash_recovery_area/orcl/control02.ctl"
db_block_size = 8192
db_flash_cache_size = 0
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/home/matt/app/matt/flash_recovery_area"
db_recovery_file_dest_size= 3882M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = "localdomain"
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
job_queue_processes = 1000
audit_file_dest = "/home/matt/app/matt/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "/home/matt/app/matt"
Mon Aug 23 19:20:39 2010
PMON started with pid=2, OS id=4201
Mon Aug 23 19:20:39 2010
VKTM started with pid=3, OS id=4203
VKTM running at (100ms) precision
Mon Aug 23 19:20:39 2010
GEN0 started with pid=4, OS id=4207
Mon Aug 23 19:20:39 2010
DIAG started with pid=5, OS id=4209
Mon Aug 23 19:20:39 2010
DBRM started with pid=6, OS id=4211
Mon Aug 23 19:20:39 2010
PSP0 started with pid=7, OS id=4213
Mon Aug 23 19:20:39 2010
DIA0 started with pid=8, OS id=4215
Mon Aug 23 19:20:39 2010
MMAN started with pid=9, OS id=4217
Mon Aug 23 19:20:39 2010
DBW0 started with pid=10, OS id=4219
Mon Aug 23 19:20:39 2010
LGWR started with pid=11, OS id=4221
Mon Aug 23 19:20:39 2010
CKPT started with pid=12, OS id=4223
Mon Aug 23 19:20:39 2010
SMON started with pid=13, OS id=4225
Mon Aug 23 19:20:39 2010
RECO started with pid=14, OS id=4227
Mon Aug 23 19:20:39 2010
MMON started with pid=15, OS id=4229
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Aug 23 19:20:39 2010
MMNL started with pid=16, OS id=4231
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /home/matt/app/matt
Mon Aug 23 19:20:40 2010
ALTER DATABASE MOUNT
USER (ospid: 4242): terminating the instance
Instance terminated by USER, pid = 4242
Can anyone help me with what I should do or what the problem is?
Edited by: user9200169 on Aug 23, 2010 10:26 AM