| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> After Creating SPFILE from PFILE startup gives ora-03113
Saw a doc on Metalink that said all you had to do was reconnect and
restart the instace if an error occured after creating an spfile from a
pfile.
I checked metalink for all deprecated parameters for 9.2.0.6 and I dont have any parameters listed that are deprecated.
Anybody know.
Below is my parameter file.
#active_instance_count = functions only in a cluster with only
two instances.
aq_tm_processes = 0 archive_lag_target = 0control_file_record_keep_time = 1 #SAMS9 does not archive or use RMAN for backup
#audit_file_dest = %ORACLE_HOME%\rdbms\audit #not used
unless audit_trail is set audit_sys_operations = false audit_trail = false background_core_dump = partial background_dump_dest = c:\oracle\ora92\admin\samsdba9\bdump backup_tape_io_slaves = false bitmap_merge_area_size = 1048576 blank_trimming = false
#buffer_pool_keep = 0 #deprecated in favor of
db_keep_cache_size
#buffer_pool_recycle = 0 #deprecated in favor of
db_recycle_cache_size circuits = 0 #for shared server arch only cluster_database = false cluster_database_instances = 1
#cluster_interconnects =
commit_point_strength = 0 #relevant only in distributed database systems compatible = 9.2.0.0.0
control_files = 'c:\oracle\ora92\samsdba9\control01.ctl','c:\oracle\ora92\samsdba9\control02.ctl','c:\oracle\ora92\samsdba9\control03.ctl' core_dump_dest = c:\oracle\admin\samsdba9\cdumpdb_create_online_log_dest_1 = c:\oracle\ora92\samsdba9 db_Create_online_log_dest_2 = c:\oracle\ora92\mirror
#cpu_count = set automatically by oracle do not
set create_bitmap_area_size = 8388608 cursor_sharing = exact cursor_space_for_time = false db_16k_cache_size = 0 db_2k_cache_size = 0 db_32k_cache_size = 0 db_4k_cache_size = 0 db_8k_cache_size = 0
#db_block_buffers = deprecated
db_block_checking = false db_block_checksum = true db_block_size = 8096 db_cache_advice = on db_cache_size = 33554432 db_create_file_dest = c:\oracle\admin\samsdba9\create
db_file_multiblock_read_count = 8
#db_file_name_convert =
db_files = 200 db_keep_cache_size = 0 db_name = samsdba9 db_recycle_cache_size = 1M db_writer_processes = 1
#dblink_encrypt_login = deprecated
dbwr_io_slaves = 0 dg_broker_config_file1 = c:\oracle\ora92\database\dr1samsdba9.dat dg_broker_config_file2 = c:\oracle\ora92\database\dr2samsdba9.dat dg_broker_start = false disk_asynch_io = true
#dispatchers =
distributed_lock_timeout = 60
#dml_locks = derived as 4 * TRANSACTIONS
#drs_start = deprecated in favor of
dg_broker_start, for backward compat
#enqueue_resources = derived by oracle sessions parameter
#event =
#fal_client =
#fal_server =
#fast_start_io_target = deprecated in favor of the
fast_start_mttr_target fast_start_mttr_target = 300 fast_start_parallel_rollback = low file_mapping = false
#filesystemio_options =
#fixed_date = primarly for testing, sysdate will
return constant
#gc_files_to_lock = for RAC no effect on exclusive mode
instances
#global_context_pool_size = deprecated
global_names = false
#hash_area_size = used for Shared Server option only
hash_join_enabled = true
#OS decides if zero
hi_shared_memory_address = 0 hs_autoregister = true
#ifile = Will create spfile from paramter file
#instance_groups = For RAC only
instance_name = samsdba9
#if not RAC environment then zero
instance_number = 0
java_max_sessionspace_size = 30000000 java_pool_size = 67108864 java_soft_sessionspace_limit = 20000000 job_queue_processes = 10 large_pool_size = 8388608 license_max_sessions = 0 license_max_users = 0 license_sessions_warning = 0
#local_listener = (address =
(PROTOCOL=TCP)(HOST=)(PORT=1521))
#lock_name_space =
lock_sga = false
#log_archive_dest = deprecated in favor of
log_archive_dest_n
#log_archive_dest_1 = not used because SAMS9 does not archive
logs log_archive_dest_state_1 = enable log_archive_dest_state_2 = enable log_archive_dest_state_3 = enable log_archive_dest_state_4 = enable log_archive_dest_state_5 = enable log_archive_dest_state_6 = enable log_archive_dest_state_7 = enable log_archive_dest_state_8 = enable log_archive_dest_state_9 = enable log_archive_dest_state_10 = enable
#log_archive_duplex_dest = deprecated in favor of
LOG_ARCHIVE_DEST_n log_archive_format = ARC%S.%T log_archive_max_processes = 2 log_archive_min_succeed_dest = 1 log_archive_start = false log_archive_trace = 0 log_buffer = 524288 log_checkpoint_interval = 0 log_checkpoint_timeout = 1800 log_checkpoints_to_alert = false
#log_file_name_convert =
log_parallelism = 1
max_commit_propagation_delay = 700 max_dispatchers = 5 max_dump_file_size = unlimited max_enabled_roles = 100 max_rollback_segments = 73 max_shared_servers = 20
#nls_calendar =
nls_comp = binary
#nls_currency =
nls_date_format = DD-MON-YYYY
#nls_date_language =
#nls_dual_currency =
#nls_iso_currency =
nls_language = AMERICAN
#nls_length_semantics =
nls_nchar_conv_excp = false
#nls_numeric_characters =
#nls_sort =
nls_territory = AMERICA
#nls_timestamp_format = go back and review
#nls_timestamp_tz_format = go back and review
O7_dictionary_accessibility = false object_cache_max_size_percent = 10 object_cache_optimal_size = 102400 olap_page_pool_size = 33554432 open_cursors = 1000 open_links = 4 open_links_per_instance = 4 optimizer_dynamic_sampling = 1 optimizer_features_enable = 9.2.0 optimizer_index_caching = 0
#Indexes have regular strength
optimizer_index_cost_adj = 100 optimizer_max_permutations = 2000 optimizer_mode = choose
#oracle_trace_collection_name =
oracle_trace_collection_path = c:\oRACLE\ora92\OTRACE\ADMIN\CDF oracle_trace_collection_size = 5242880 oracle_trace_enable = false
oracle_trace_facility_name = oracled oracle_trace_facility_path = c:\oRACLE\ora92\OTRACE\ADMIN\FDF os_authent_prefix = "" os_roles = false parallel_adaptive_multi_user = false parallel_automatic_tuning = false parallel_execution_message_size = 2148Received on Fri Sep 02 2005 - 09:26:15 CDT
#parallel_instance_group =
parallel_max_servers = 5 parallel_min_percent = 0 parallel_min_servers = 0 parallel_threads_per_cpu = 2 partition_view_enabled = false pga_aggregate_target = 25165824 plsql_compiler_flags = interpreted
#plsql_native_c_compiler =
#plsql_native_library_dir =
plsql_native_library_subdir_count = 0
#plsql_native_linker =
#plsql_native_make_file_name =
#plsql_native_make_utility =
plsql_v2_compatibility = false pre_page_sga = false processes = 150 query_rewrite_enabled = true query_rewrite_integrity = enforced
#rdbms_server_dn =
read_only_open_delayed = false
#0 or 1 recovery is to be performed serially by one process.
recovery_parallelism = 0 remote_archive_enable = true remote_dependencies_mode = TIMESTAMP
#remote_listener =
remote_login_passwordfile = EXCLUSIVE remote_os_authent = false remote_os_roles = false replication_dependency_tracking = true resource_limit = false
#resource_manager_plan =
#rollback_segments =
row_locking = always serial_reuse = disable serializable = false service_names = samsdba9 session_cached_cursors = 0 session_max_open_files = 10 sessions = 170 sga_max_size = 210836200 shadow_core_dump = partial shared_memory_address = 0 shared_pool_reserved_size = 3774873 shared_pool_size = 75497472 shared_server_sessions = 165 shared_servers = 1 sort_area_retained_size = 0 sort_area_size = 524288 spfile = c:\ORACLE\ora92\DATABASE\SPFILEsamsdba9.ORA sql92_security = false sql_trace = false sql_version = native standby_archive_dest = c:\oracle\ora92\RDBMS standby_file_management = manual statistics_level = typical tape_asynch_io = true thread = 0 timed_os_statistics = 0 timed_statistics = true trace_enabled = true
#tracefile_identifier =
transaction_auditing = true transactions = 187 transactions_per_rollback_segment = 5 undo_management = auto undo_retention = 10800 undo_suppress_errors = false undo_tablespace = UNDOTBS1 use_indirect_data_buffers = false user_dump_dest = c:\oracle\admin\samsdba9\udump utl_file_dir = c:\temp,c:\samsdba9\serveroutput workarea_size_policy = auto
 |
 |