Re: Upgrade DB from 8.1.6 to 8.1.7

Here are my notes for 8.1.6.2 to 8.1.7.2 with APPS 11i. Email me if you need further help. JimmyN

PART (A) UPGRADE RDB (***1***) Follow note: 148903.1 apply patch 1937592 (***2***) NOTE 62291.1, INIT.ora parameters: _optimizer_features_enable=8.1.7 & _sqlexec_progression_enabled=true & optimizer_max_permutations=2000 are in ifilecbo.ora (***3***) shutdown db, set _system_trig_enabled=false, java_pool_size=500MB, reran $ORACLE_HOME/javavm/install/initjvm.sql per bug 1380825; PLS-201: identifier'DBA_JAVA_POLICY' must be declared" According to the jvmrmsec.sql script: "The following form will generate errors if the view dba_java_policy is not yet defined, as will typically be the case when this script is called from init_security. These errors can be ignored." ERRORS:  Create or replace java system -->

PART (B) UPGRADE JAVA Note:117127.1 (***4***) ran java scripts according to Note:161432.1 (***5***) bug 1923050 set java_soft_session_limit=50MB SELECT count(*) from dba_objects where object_type like '%JAVA%' should be 10404

"PART(C) UPGRADE INTERMEDIA The sequence of the steps to upgrade at once are (variables + directories in Unix style): sqlplus /nolog sql> connect / as sysdba sql> spool text_81720_upg.lis sql> shutdown immediate sql> startup mount restrict sql> alter system set job_queue_processes=0 sql> alter database open sql> @$ORACLE_HOME/ctx/admin/upgrade/s0801060.sql (only when version was 8.1.5.x) sql> @$ORACLE_HOME/ctx/admin/upgrade/s0801070.sql sql> connect ctxsys/ctxsys sql> @$ORACLE_HOME/ctx/admin/upgrade/u0801070.sql sql>
@$ORACLE_HOME/ctx/admin/upgrade/u0801071.sql sql>
@$ORACLE_HOME/ctx/admin/upgrade/u0801072.sql sql>
@$ORACLE_HOME/ctx/admin/dr0typec.pkh sql> @$ORACLE_HOME/ctx/admin/dr0pkh.sql
sql> @$ORACLE_HOME/ctx/admin/dr0plb.sql sql>
@$ORACLE_HOME/ctx/admin/dr0type.plb sql> @$ORACLE_HOME/ctx/admin/dr0typec.plb
sql> @$ORACLE_HOME/ctx/admin/dr0itypc.sql sql> spool off sql> select object_name,object_type from user_objects where status!='VALID'& #059; sql> exit Check the generated spool file for errors: grep -i oratext _81720_upg.lis|sort|more Check if invalid objects do exist and if present

recompile them.                  "