| oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options [message #603574] |
Tue, 17 December 2013 10:34  |
cakeday
Messages: 31
Registered: May 2010
|
Member |
|
|
hi all: I am trying to upgrade oracle db from version 9.2.0.7.0 to 11.2.0.3;
I have ran the utlu112i.sql and made changes as requested.
when i try to startup upgrade, i get the following error:
SQL> startup upgrade pfile='/p049/admin/pfile/initP049.ora_11g'
SP2-0714: invalid combination of STARTUP options
so i do the following..
SQL> startup nomount pfile='/p049/admin/pfile/initP049.ora_11g'
LRM-00101: unknown parameter name 'diagnostic_dest'
ORA-01078: failure in processing system parameters
= = =
what am i doing wrong?? please help!
= = =
my upgrade init file is,
*.db_cache_size=9395240960
*.java_pool_size=268435456
*.large_pool_size=268435456
*.pga_aggregate_target=9395240960
*.shared_pool_size=2147483648
*.audit_trail='true'# if you want auditing
*.compatible='10.2.0'
*.control_file_record_keep_time=16
*.control_files='/p049/sys001/control_001.ctl','/p049/sys002/control_002.ctl','/
p049/sys003/control_003.ctl'
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_cache_size=2500m
*.db_domain='sce.com'
*.db_file_multiblock_read_count=32# LARGE
*.db_files=400
*.db_keep_cache_size=250m
*.db_name='P049'
*.db_recycle_cache_size=200m
*.diagnostic_dest='/p049/oracle'
*.dml_locks=500# LARGE
*.global_names=true
*.java_pool_size=100m# eyu added 06/11/2004
*.job_queue_processes=10
*.large_pool_size=65m
*.log_archive_dest='/p049/arch001'
*.log_buffer=10485760# eyu changed from 163840 06/11/2004 # LARGE
*.log_checkpoint_interval=26000
*.log_checkpoints_to_alert=true
*.max_dump_file_size='10240'# limit trace file size to 5 Meg each
##*.memory_max_target=21000m
##*.memory_target=21000m
*.open_cursors=6500# 6/02 added after 9i migration 5/31/2003 for CWI application
as requested by Nhan
*.os_authent_prefix=''
*.parallel_max_servers=320
*.pga_aggregate_target=150m
*.processes=1800
*.query_rewrite_enabled='TRUE'
*.query_rewrite_integrity='TRUSTED'
*.sessions=1650
*.shared_pool_size=838860800
*.timed_statistics=true
*.transactions=1600
*.undo_management='AUTO'
*.undo_retention=7200
*.undo_tablespace='UNDO001'
*.workarea_size_policy='AUTO'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
