Home » RDBMS Server » Server Administration » oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options (oracle version 9i to 11g; aix.)
oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options [message #603574] Tue, 17 December 2013 10:34 Go to next message
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 #603577 is a reply to message #603574] Tue, 17 December 2013 10:48 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
you should use actual V9 pfile to start the DB
Re: oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options [message #603579 is a reply to message #603574] Tue, 17 December 2013 10:54 Go to previous messageGo to next message
John Watson
Messages: 7262
Registered: January 2010
Location: Global Village
Senior Member
Are you trying to startup using the 9.x version of SQL*Plus? UPGRADE was not an option back then.
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 Go to previous messageGo to next message
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 #603581 is a reply to message #603580] Tue, 17 December 2013 10:55 Go to previous messageGo to next message
cakeday
Messages: 31
Registered: May 2010
Member
so, if upgrade was not an option then how do i startup the DB in upgrade mode?
Re: oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options [message #603583 is a reply to message #603581] Tue, 17 December 2013 10:56 Go to previous messageGo to next message
John Watson
Messages: 7262
Registered: January 2010
Location: Global Village
Senior Member
Think, man. And read your upgrade manual. Where might you have a copy of SQL*Plus that understands UPGRADE?
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 Go to previous messageGo to next message
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
Re: oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options [message #603597 is a reply to message #603591] Tue, 17 December 2013 12:07 Go to previous message
John Watson
Messages: 7262
Registered: January 2010
Location: Global Village
Senior Member
This seems clear enough:
Quote:
Direct upgrade from 9.2.0.7 is not supported

You'll have to upgrade to 9.2.0.8 first. It is all in the upgrade guide, you know.
Previous Topic: Cross Platform Database
Next Topic: Restricting characters in a UTF8 database
Goto Forum:
  


Current Time: Wed Feb 21 06:30:07 CST 2018

Total time taken to generate the page: 0.01792 seconds