Upgrading Oracle Apps 11i Database to Oracle Database 10g Release 2 (10.2.0) - Step 4

4.Post Database Upgrade Steps.

1.Fix Korean lexers
$ sqlplus "/ as sysdba" @$ORACLE_HOME/ctx/sample/script/drkorean.sql

2.Apply RDBMS patches for Daily Business Intelligence

3.Import OLAP analytical workspaces (conditional)

4.Run adgrants.sql (conditional)
copy $APPL_TOP/admin/adgrants.sql
$ sqlplus "/ as sysdba" @adgrants.sql (or adgrants_nt.sql)
cp $APPL_TOP/admin/adgrants.sql /tmp
sqlplus "/as sysdba" @adgrants.sql APPLSYS

5.Grant create procedure privilege on CTXSYS
Copy $AD_TOP/patch/115/sql/adctxprv.sql
$ sqlplus apps/ @adctxprv.sql CTXSYS
sqlplus apps/apps @adctxprv.sql manager CTXSYS

6. Create nls/data/9idata directory
cd $ORACLE_HOME/nls/data/old
perl cr9idata.pl
Creating directory /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata ...
Copying files to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata!

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

7. Implement and run AutoConfig
Implement and run AutoConfig on the <10.2.0> as follows:

1) Copy AutoConfig to the <10.2.0>
*** On the Application Tier (as the applmgr user):
a) Log in to the APPL_TOP environment and source the APPSORA.env file
b) Create appsutil.zip file. This will create appsutil.zip in $APPL_TOP/admin/out
$ perl $AD_TOP/bin/admkappsutil.pl
c) Copy or FTP the appsutil.zip file to the <10.2.0>
*** On the Database Tier (as the oracle user):
$ cd <10.2.0>
$ . .env
$ unzip -o appsutil.zip
[applmgr@sys45 sql]$ cd $AD_TOP/bin/
[applmgr@sys45 bin]$ ls -lrt admkappsutil.pl
-rwxr-xr-x 1 applmgr dba 5683 Apr 15 15:26 admkappsutil.pl
[applmgr@sys45 bin]$ perl admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /oracle/app/apps/sarappl/admin/log/MakeAppsUtil_05141101.log
output located at /oracle/app/apps/sarappl/admin/out/appsutil.zip
MakeAppsUtil completed successfully.


cp appsutil.zip to Oracle 10g home

[oracle@sys45 10.2.0.1]$unzip -o appsutil.zip

2) Generate your Database Context File.
Execute the following commands to create your Database Context File:
cp .env /tmp
edit .env
Change Oracle_home path all
Change perl path


$ cd <10.2.0>
$ . .env
$ cd <10.2.0>/appsutil/bin
$ perl adbldxml.pl tier=db appsuser= appspasswd=


perl adbldxml.pl tier=db appsuser=apps appspasswd=apps


3) Generate and Apply AutoConfig Configuration files

Execute the following commands:

$ cd <10.2.0>/appsutil/bin
$ adconfig.sh contextfile=


8. Gather statistics for SYS schema
Copy $APPL_TOP/admin/adstats.sql


cp $APPL_TOP/admin/adstats.sql /tmp


sqlplus "/ as sysdba"
SQL> shutdown normal;
SQL> startup restrict;
SQL> @adstats.sql
SQL> shutdown normal;
SQL> startup;
SQL> exit;


9.Re-create custom database links (conditional)

sqlplus apps/
SQL> select db_link from dba_db_links;


10.Re-create grants and synonyms

run AD Administration and select the "Recreate grants and synonyms for APPS schema" task from the Maintain Applications Database Objects menu.
If MRC is implemented in your Applications system, then run the "Maintain Multiple Reporting Currencies schema" task to re-create MRC triggers in the Apps schema.

Apply Oracle Receivables patch
Apply Oracle Receivables patch 5753621.

11.Restart Applications server processes (conditional)

$COMMON_TOP/admin/scripts/SID_host/

adstpall.sh apps/apps
adstrall.sh apps/apps