Database Instance unable to start
Hi,
I am trying to start up my database but I receive the following errors, any ideas why? I have posted the init.ora and the beginning of the database startup
Code:
SQL> startup pfile='/tmp/terry.ora'
ORACLE instance started.
Total System Global Area 6747725824 bytes
Fixed Size 2213976 bytes
Variable Size 6241126312 bytes
Database Buffers 469762048 bytes
Redo Buffers 34623488 bytes
ORA-03113: end-of-file on communication channel
Process ID: 17491
Session ID: 195 Serial number: 1
SQL>
Here is my init.ora file
Code:
[oracle@mondbop001 {SOCPROD1} tmp]$ more terry.ora
SOCPROD2.__db_cache_size=469762048
SOCPROD1.__db_cache_size=469762048
SOCPROD2.__java_pool_size=67108864
SOCPROD1.__java_pool_size=134217728
SOCPROD1.__large_pool_size=67108864
SOCPROD2.__large_pool_size=67108864
SOCPROD2.__oracle_base='/u01/app/grid'#ORACLE_BASE set from environment
SOCPROD1.__oracle_base='/u01/app/grid'#ORACLE_BASE set from environment
SOCPROD1.__pga_aggregate_target=5167382528
SOCPROD2.__pga_aggregate_target=5167382528
SOCPROD1.__sga_target=1610612736
SOCPROD2.__sga_target=1610612736
SOCPROD1.__shared_io_pool_size=0
SOCPROD2.__shared_io_pool_size=0
SOCPROD2.__shared_pool_size=872415232
SOCPROD1.__shared_pool_size=872415232
SOCPROD1.__streams_pool_size=0
SOCPROD2.__streams_pool_size=67108864
*.archive_lag_target=0
*.audit_file_dest='/u01/app/oracle/admin/SOCPROD/adump'
*.audit_trail='NONE'
*.cluster_database=TRUE
*.compatible='11.2.0.0.0'
*.control_files='+DAT1/socprod/controlfile/current.260.729791749'
*.db_block_size=8192
*.db_create_file_dest='+DAT1'
*.db_domain=''
*.db_flashback_retention_target=720
*.db_name='SOCPROD'
*.db_recovery_file_dest_size=188978561024
*.db_unique_name='SOCPRODCAV'
*.dg_broker_config_file1='+DAT1/socprodcav/dr1.dat'
*.dg_broker_start=TRUE
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SOCPRODXDB)'
*.fal_server='SOCPRODCRO'
SOCPROD1.instance_number=1
SOCPROD2.instance_number=2
*.job_queue_processes=1000
*.log_archive_config='dg_config=(SOCPRODCAV,SOCPRODCRO)'
*.log_archive_dest_2='service="SOCPRODCRO"','LGWR SYNC AFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=
"SOCPRODCRO" net_timeout=30','valid_for=(all_logfiles,primary_role)'
*.log_archive_dest_3=''
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
SOCPROD2.log_archive_format='%t_%s_%r.dbf'
SOCPROD1.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=5
*.log_archive_min_succeed_dest=1
SOCPROD2.log_archive_trace=0
SOCPROD1.log_archive_trace=0
*.memory_target=6730809344
*.nls_language='ENGLISH'
*.nls_territory='UNITED KINGDOM'
*.open_cursors=300
*.pga_aggregate_target=5114953728
*.processes=1000
*.recyclebin='OFF'
*.remote_listener='caversham1-scan.prod.mon.bbc.co.uk:1521'
*.remote_login_passwordfile='exclusive'
*.session_cached_cursors=100
*.sga_target=1610612736
*.smtp_out_server='10.182.216.104:25'
*.standby_file_management='AUTO'
SOCPROD2.thread=2
SOCPROD1.thread=1
*.trace_enabled=FALSE
SOCPROD2.undo_tablespace='UNDOTBS2'
SOCPROD1.undo_tablespace='UNDOTBS1'
[oracle@mondbop001 {SOCPROD1} tmp]$
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters option.
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initSOCPROD1.ora
My question is why does it attempt to use initSOCPROD1.ora and not the pfile I specified at startup?
Many thanks
