| 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'
|
|
|
|
|
|
|
|
| Re: oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options [message #603580 is a reply to message #603577] |
Tue, 17 December 2013 10:54  |
cakeday
Messages: 31
Registered: May 2010
|
Member |
|
|
hi. Thank You. I am able to use the v9 version of the init file to start the Db normally (in the 9i mode). but i need to start the db in the UPGRADE mode, so i can proceed with the upgrade.
So i made changes to the v9 init file based on the recommendations given by the ultu112i.sql file and after that i am not able to start the db in the upgrade mode.
the init file that i have pasted in my original post is the upgrade version init file.
= = =
SQL> startup pfile='/p049/admin/pfile/initP049.ora.orig'
ORACLE instance started.
Total System Global Area 756024712 bytes
Fixed Size 742792 bytes
Variable Size 385875968 bytes
Database Buffers 369098752 bytes
Redo Buffers 307200 bytes
Database mounted.
Database opened.
|
|
|
|
|
|
|
|
| Re: oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options [message #603591 is a reply to message #603583] |
Tue, 17 December 2013 11:37 |
cakeday
Messages: 31
Registered: May 2010
|
Member |
|
|
ok. u were right, i was running the upgrade from the incorrect oracle home.
so now that, i am able to start the DB in the upgrade mode, i get the following error?
is there good documentation on upgrade from 9.2.0.7 to 11.2.0.3 ? i was unable to find any.. pleaes help.
===
No errors.
DOC>#######################################################################
DOC>#######################################################################
DOC> The following check_edition_exists procedure may result in this error:
DOC>
DOC> ERROR at line 1:
DOC> ORA-20000: Editioning view exists for non-edition enabled schema
DOC> ORA-06512: at "SYS.CHECK_EDITION_EXISTS", line 21
DOC> ORA-06512: at line 2
DOC>
DOC> if there exists non-edition enabled schemas that have editioning
DOC> views. One of the following corrective actions must be taken before
DOC> the upgrade will proceed.
DOC>
DOC> 1. Drop these editioning views.
DOC> 2. Edition enable the schemas using the alter user statement.
DOC> 3. Replace the editioning views with regular views.
DOC>
DOC> Perform a "ALTER SYSTEM CHECKPOINT" prior to "SHUTDOWN ABORT" and take
DOC> a corrective action described above.
DOC>
DOC> Restriction is for:
DOC> 1) When source database is 11.2.0.1 and is being upgraded to 11.2.0.2.
DOC> 2) To identify the particular schema/views run the pre-upgrade script
DOC> /rdbms/admin/utlu112i.sql in normal mode on the source database.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
Procedure created.
PL/SQL procedure successfully completed.
Procedure dropped.
Function created.
SELECT version_script AS file_name FROM DUAL
*
ERROR at line 1:
ORA-20000: Upgrade not supported from version 9.2.0.7.0
ORA-06512: at "SYS.VERSION_SCRIPT", line 51
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
