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
Here is my init.ora fileCode: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>
Starting up: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]$
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




Reply With Quote