ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 1 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Hai in this Article I will demonstrate how to upgrade EBS (R12.1.3) database from 11.1.0.7 to 11.2.0.2 in Linux 5.7_x64 Interoperability Notes Oracle EBS R12 with Oracle Database 11gR2 (11.2.0.2) (Doc ID 1367644.1) Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)

Pre - Upgrade Steps: 1. Install Oracle 11.2.0.2 Software Only 2. Install Examples CD 3. Copy Listner tns folder to 11gR2 Home and change oracle HOME 4. shutdown Application and database Listener 5. Apply Application Patches using adpatch Upgrade Steps: 1. run pre upgrade Commands from 11.1.0.7 Home and fix issues 2. edit initfile parameters 3. run dbua command from 11.2.0.2 Home Post - Upgrade Steps: 1. Compile invalid Objects 2. Running of Scripts 3. Gather statistics 4. Recreate grants and synonyms using adadmin (42) 5. Running Autoconfig on db and apps Tier

My Machine's Existing software and Directories details: [root@rac1 ~]# cat /etc/enterprise-release Enterprise Linux Enterprise Linux Server release 5.7 (Carthage) [root@rac1 ~]# arch x86_64 [root@rac1 ~]# hostname rac1.dell.com [root@rac1 ~]# hostname -i 192.168.1.11 [root@rac1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 190G 13G 168G 7% / /dev/sda5 723G 137G 550G 20% /u01 /dev/sda3 29G 364M 27G 2% /tmp http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 2 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux tmpfs /dev/sr0 .host:/

4.0G 3.6G 466G

0 3.6G 188G

4.0G 0% /dev/shm 0 100% /media/OL5.7 x86_64 dvd 20110728 279G 41% /mnt/hgfs

[root@rac1 ~]# cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.1.11 rac1.dell.com rac1 [root@rac1 ~]# cat /etc/oratab PROD:/u01/db/tech_st/11.1.0:N [root@rac1 ~]# cat /etc/oraInst.loc inventory_loc=/u01/oraInventory/ inst_group=dbaerp [root@rac1 ~]# chmod -R 775 /etc/oraInst.loc [root@rac1 ~]# mkdir -p /u01/oraInventory/ [root@rac1 ~]# mkdir -p /u01/db/tech_st/11.2.0 [root@rac1 ~]# chown -R oraerp:dbaerp /u01 [root@rac1 ~]# chmod -R 775 /u01/ [root@rac1 ~]# chmod -R 775 /u01/oraInventory/ [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ id uid=54322(oraerp) gid=54323(dbaerp) groups=54323(dbaerp) [oraerp@rac1 ~]$

Size of Database and Apps [oraerp@rac1 ~]$ cd /u01/ [oraerp@rac1 u01]$ du -sh * 37G apps 101G db [oraerp@rac1 ~]$

Invalid objects check [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . PROD_rac1.env [oraerp@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Sun Mar 19 07:54:54 2017 Copyright (c) 1982, 2008, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> show user USER is "SYS" SQL> http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 3 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------30 SQL> SQL> column owner format A12 column object_type format A13 select owner,object_type,COUNT(*) from dba_objects where status='INVALID' group by owner, object_type; OWNER OBJECT_TYPE COUNT(*) ------------ ------------- ---------APPS PACKAGE BODY 30

Invalid objects are only for the APPS user. We can move further If there are any invalid objects for SYS user then try to fix that first.

For better performance in Upgrade 1. 2. 3.

Run “Gather Schema Statistics” for ALL users Compile Apps Schecma using adadmin (31), before upgrade Run Concurrent Request “Purge Concurrent Request and/or Manager Data”.

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 4 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Let’s Check Database version before proceeding to UPGRADE

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 5 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Application and Database Patches Application Patches for EBS-R12.1.3 [oracle@rac1 ~]$ [oracle@rac1 ~]$ cd /shrf/patches/apps_patches_11202/ [oracle@rac1 apps_patches_11202]$ ll total 28412 -rwxr-xr-x 1 oraerp dbaerp 28978624 Mar 1 16:48 p8919489_R12.TXK.B_R12_GENERIC.zip -rwxr-xr-x 1 oraerp dbaerp 59037 Mar 1 16:48 p9062910_12.1.0_R12_GENERIC.zip -rwxr-xr-x 1 oraerp dbaerp 9340 Mar 1 16:48 p9852070_R12.TXK.B_R12_GENERIC.zip [oracle@rac1 apps_patches_11202]$

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 6 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Database Patches for 11.2.0.2 RDBMS [oracle@rac1 ~]$ [oracle@rac1 ~]$ cd /shrf/patches/db_patches_11202/ [oracle@rac1 db_patches_11202]$ ll total 904 -rwxr-xr-x 1 oraerp dbaerp 61742 Mar 1 16:48 p10149223_112020_Linux-x8664.zip -rwxr-xr-x 1 oraerp dbaerp 179103 Mar 1 16:48 p10160615_112020_Linux-x8664.zip -rwxr-xr-x 1 oraerp dbaerp 235602 Mar 1 16:48 p10229719_112020_Linux-x8664.zip -rwxr-xr-x 1 oraerp dbaerp 102277 Mar 1 16:48 p12400751_112020_Linux-x8664.zip -rwxr-xr-x 1 oraerp dbaerp 123965 Mar 1 16:48 p12942119_112020_Linux-x8664.zip -rwxr-xr-x 1 oraerp dbaerp 20642 Mar 1 16:48 p13001379_112020_Generic.zip -rwxr-xr-x 1 oraerp dbaerp 99545 Mar 1 16:48 p13004894_112020_Linux-x8664.zip -rwxr-xr-x 1 oraerp dbaerp 52225 Mar 1 16:48 p4247037_112020_Generic.zip [oracle@rac1 db_patches_11202]$

Prepare to create 11.2.0. Oracle home [oracle@rac1 ~]$ [oracle@rac1 ~]$ mkdir -p /u01/db/tech_st/11.2.0

and install all the required RPMS for 11gR2, check the below link for list of RPMS https://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCGJC EA

Installation of RDBMS 11.2.0.2 Software Note :Before install 11gR2 check you r central Inventory details in /etc/oraInst.loc file and 775 permission as shown above [oracle@rac1 db_11202_x64]$ ll total 1704800 drwxr-xr-x 8 oraerp dbaerp 4096 Nov 16 2010 database drwxr-xr-x 6 oraerp dbaerp 4096 Nov 12 2010 examples -rwxrwxrwx 1 oraerp dbaerp 1307536871 Feb 19 08:51 p10098816_112020_Linux-x86-64_1of7.zip -rwxrwxrwx 1 oraerp dbaerp 1049912579 Feb 19 09:02 p10098816_112020_Linux-x86-64_2of7.zip -rwxrwxrwx 1 oraerp dbaerp 476740652 Feb 19 11:32 p10098816_112020_Linux-x86-64_6of7.zip [oracle@rac1 db_11202_x64]$

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 7 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 8 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 9 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 10 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 11 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 12 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 13 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 14 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 15 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 16 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Click Fix & Check Again button

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 17 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Execute Fixup Scripts [root@rac1 ~]# [root@rac1 ~]# /tmp/CVU_11.2.0.2.0_oraerp/runfixup.sh /usr/bin/id Response file being used is :/tmp/CVU_11.2.0.2.0_oraerp/fixup.response Enable file being used is :/tmp/CVU_11.2.0.2.0_oraerp/fixup.enable Log file location: /tmp/CVU_11.2.0.2.0_oraerp/orarun.log uid=54322(oraerp) gid=54323(dbaerp) groups=54323(dbaerp) [root@rac1 ~]#

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 18 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 19 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 20 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 21 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Execute Configuration Scripts: [root@rac1 ~]# [root@rac1 ~]# /u01/db/tech_st/11.2.0/root.sh Running Oracle 11g root script... The following environment variables are set as: ORACLE_OWNER= oraerp ORACLE_HOME= /u01/db/tech_st/11.2.0 Enter the full pathname of the local bin directory: [/usr/local/bin]: (PRESS ENTER) Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 22 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Finished product-specific root actions. [root@rac1 ~]#

Check the Installer log file for any error

Install Oracle Database 11g Products from the 11g Examples CD

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 23 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 24 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Select NEW HOME location @ “Software Location”

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 25 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 26 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 27 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Before Proceeding Further take Cold Backup Copy of files ( :%s/11.1.0/11.2.0/g ) 1. Copy Listener & tns folder from OLD_HOME to NEW_HOME and change

values of ORACLE_HOME(11.1.0) to NEW_HOME(11.2.0) [oraerp@rac1 network]$ [oraerp@rac1 network]$ pwd /u01/db/tech_st/11.1.0/network [oraerp@rac1 network]$ http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 28 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux [oraerp@rac1 network]$ cp -R admin/ /u01/db/tech_st/11.2.0/network/ [oraerp@rac1 ~]$ vi /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/listener.ora [oraerp@rac1 ~]$ vi /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/tnsnames.ora [oraerp@rac1 ~]$ vi /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/sqlnet.ora 2. Copy upgrade scripts from NEW_HOME [oraerp@rac1 ~]$ cp /u01/db/tech_st/11.2.0/rdbms/admin/utlu112i.sql /shrf/db_scripts/ [oraerp@rac1 ~]$ cp /u01/db/tech_st/11.2.0/rdbms/admin/utlrp.sql /shrf/db_scripts/ 3. Copy files from Application Server [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ cp $APPL_TOP/admin/adgrants.sql /shrf/db_scripts/ [oraerp@rac1 ~]$ cp $AD_TOP/patch/115/sql/adctxprv.sql /shrf/db_scripts/ [oraerp@rac1 ~]$ cp $FND_TOP/patch/115/sql/wfaqupfix.sql /shrf/db_scripts/ [oraerp@rac1 ~]$ cp $APPL_TOP/admin/adstats.sql /shrf/db_scripts/ [oraerp@rac1 [oraerp@rac1 total 580 -rwxr-xr-x 1 -rwxr-xr-x 1 -rwxr-xr-x 1 -rwxr-xr-x 1 -rw-r--r-- 1 -rwxr-xr-x 1 [oraerp@rac1

~]$ cd /shrf/db_scripts/ db_scripts]$ ll oraerp dbaerp 1664 Mar oraerp dbaerp 53060 Mar oraerp dbaerp 2752 Mar oraerp dbaerp 3221 Mar oraerp dbaerp 204205 Mar oraerp dbaerp 4631 Mar db_scripts]$

18 18 18 18 18 18

14:39 14:39 14:39 14:42 12:44 14:39

adctxprv.sql adgrants.sql adstats.sql utlrp.sql utlu112i.sql wfaqupfix.sql

New Env. File for 11gR2 [root@rac1 ~]# [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ cat 11gR2.env export ORACLE_SID=PROD export ORACLE_BASE=/u01 export ORACLE_HOME=/u01/db/tech_st/11.2.0 export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH export ORA_NLS10=/u01/db/tech_st/11.2.0/nls/data/9idata http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 29 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux export TNS_ADMIN=$ORACLE_HOME/network/admin/PROD_rac1 [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$

Create nls/data/9idata directory [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ perl /u01/db/tech_st/11.2.0/nls/data/old/cr9idata.pl Creating directory /u01/db/tech_st/11.2.0/nls/data/9idata ... Copying files to /u01/db/tech_st/11.2.0/nls/data/9idata... Copy finished. Please reset environment variable ORA_NLS10 to /u01/db/tech_st/11.2.0/nls/data/9idata! [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$

Application Patches Status (enable maintenance mode and apply patches using adpatch) [root@rac1 ~]# [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ sqlplus apps/apps SQL*Plus: Release 10.1.0.5.0 - Production on Sat Mar 18 12:22:10 2017 Copyright (c) 1982, 2005, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select bug_number from ad_bugs where bug_number='8919489'; BUG_NUMBER -----------------------------8919489 8919489 SQL> select bug_number from ad_bugs where bug_number='9062910'; BUG_NUMBER -----------------------------9062910 SQL> select bug_number from ad_bugs where bug_number='9852070'; BUG_NUMBER http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 30 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux -----------------------------9852070 SQL>

Apply additional 11.2.0.2 RDBMS patches [root@rac1 ~]# [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ which opatch /u01/db/tech_st/11.2.0/OPatch/opatch [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ opatch version Invoking OPatch 11.2.0.1.1 OPatch Version: 11.2.0.1.1 OPatch succeeded. [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ opatch lsinventory [oraerp@rac1 4247037]$ [oraerp@rac1 4247037]$ opatch apply Invoking OPatch 11.2.0.1.1 Oracle Interim Patch Installer version 11.2.0.1.1 Copyright (c) 2009, Oracle Corporation. All rights reserved. Oracle Home Central Inventory from OPatch version OUI version OUI location Log file location 18_12-26-44PM.log

: : : : : : :

/u01/db/tech_st/11.2.0 /u01/oraInventory/ /etc/oraInst.loc 11.2.0.1.1 11.2.0.2.0 /u01/db/tech_st/11.2.0/oui /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-

Patch history file: /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch_history.txt ApplySession applying interim patch '4247037' to OH '/u01/db/tech_st/11.2.0' Running prerequisite checks... OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only. Backing up files and inventory (not for auto-rollback) for the Oracle Home

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 31 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Backing up files affected by the patch '4247037' for restore. This might take a while... Backing up files affected by the patch '4247037' for rollback. This might take a while... Patching component oracle.sdo.locator, 11.2.0.2.0... Copying file to "/u01/db/tech_st/11.2.0/md/admin/catmgdidcode.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/catnomgdidcode.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidcodetype.plb" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidcodetype.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidcodeutl.plb" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidcodeutl.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdiddeinstall.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidepctype.plb" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidepctype.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidinstall.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidmetadata.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidmetatable.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdidprivs.plb" Copying file to "/u01/db/tech_st/11.2.0/md/admin/mgdsys.sql" Copying file to "/u01/db/tech_st/11.2.0/md/admin/prvtmgdidcodetypeb.plb" Copying file to "/u01/db/tech_st/11.2.0/md/admin/prvtmgdidcodeutlb.plb" Copying file to "/u01/db/tech_st/11.2.0/md/admin/prvtmgdidepctypeb.plb" Copying file to "/u01/db/tech_st/11.2.0/md/support/patchset_mgdsys_validity.sql" ApplySession adding interim patch '4247037' to inventory Verifying the update... Inventory check OK: Patch ID 4247037 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 4247037 are present in Oracle Home. OPatch succeeded. [oraerp@rac1 4247037]$ [oraerp@rac1 10149223]$ [oraerp@rac1 10149223]$ opatch apply Invoking OPatch 11.2.0.1.1 Oracle Interim Patch Installer version 11.2.0.1.1 Copyright (c) 2009, Oracle Corporation. All rights reserved. Oracle Home Central Inventory from OPatch version OUI version OUI location Log file location 18_12-28-52PM.log

: : : : : : :

/u01/db/tech_st/11.2.0 /u01/oraInventory/ /etc/oraInst.loc 11.2.0.1.1 11.2.0.2.0 /u01/db/tech_st/11.2.0/oui /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 32 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Patch history file: /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch_history.txt ApplySession applying interim patch '10149223' to OH '/u01/db/tech_st/11.2.0' Running prerequisite checks... OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/db/tech_st/11.2.0') Is the local system ready for patching? [y|n]

y User Responded with: Y Backing up files and inventory (not for auto-rollback) for the Oracle Home Backing up files affected by the patch '10149223' for restore. This might take a while... Backing up files affected by the patch '10149223' for rollback. This might take a while... Patching component oracle.rdbms, 11.2.0.2.0... Updating archive file "/u01/db/tech_st/11.2.0/lib/libserver11.a" "lib/libserver11.a/kkqu.o" Running make for target ioracle ApplySession adding interim patch '10149223' to inventory

with

Verifying the update... Inventory check OK: Patch ID 10149223 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 10149223 are present in Oracle Home. The local system has been patched and can be restarted. OPatch succeeded. [oraerp@rac1 10149223]$

Apply all the recommended patches in same way [oraerp@rac1 10160615]$ OPatch succeeded. [oraerp@rac1 10229719]$ OPatch succeeded. [oraerp@rac1 12400751]$ OPatch succeeded. [oraerp@rac1 13001379]$ OPatch succeeded. [oraerp@rac1 13004894]$ OPatch succeeded.

opatch apply opatch apply opatch apply opatch apply opatch apply

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 33 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux [oraerp@rac1 13004894]$ opatch lsinventory Invoking OPatch 11.2.0.1.1 Oracle Interim Patch Installer version 11.2.0.1.1 Copyright (c) 2009, Oracle Corporation. All rights reserved. Oracle Home Central Inventory from OPatch version OUI version OUI location Log file location 18_12-34-17PM.log

: : : : : : :

/u01/db/tech_st/11.2.0 /u01/oraInventory/ /etc/oraInst.loc 11.2.0.1.1 11.2.0.2.0 /u01/db/tech_st/11.2.0/oui /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-

Patch history file: /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch_history.txt Lsinventory Output file location : /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2017-03-18_12-3417PM.txt ------------------------------------------------------------------------------Installed Top-level Products (2): Oracle Database 11g 11.2.0.2.0 Oracle Database 11g Examples 11.2.0.2.0 There are 2 products installed in this Oracle Home. Interim patches (7) : Patch 13004894 : applied on Sat Mar 18 12:33:23 AST 2017 Unique Patch ID: 14143364 Created on 28 Sep 2011, 10:06:58 hrs PST8PDT Bugs fixed: 13004894 Patch 13001379 : applied on Sat Mar 18 12:32:34 AST 2017 Unique Patch ID: 14718548 Created on 31 Mar 2012, 04:48:44 hrs PST8PDT Bugs fixed: 13001379 Patch 12400751 : applied on Sat Mar 18 12:32:11 AST 2017 Unique Patch ID: 13880767 Created on 28 Jun 2011, 00:48:59 hrs PST8PDT Bugs fixed: http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 34 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux 12400751 Patch 10229719 : applied on Sat Mar 18 12:31:03 AST 2017 Unique Patch ID: 13186657 Created on 28 Nov 2010, 23:27:11 hrs PST8PDT Bugs fixed: 10229719 Patch 10160615 : applied on Sat Mar 18 12:30:13 AST 2017 Unique Patch ID: 13348800 Created on 17 Jan 2011, 05:06:03 hrs PST8PDT Bugs fixed: 10160615 Patch 10149223 : applied on Sat Mar 18 12:29:11 AST 2017 Unique Patch ID: 13073567 Created on 25 Oct 2010, 03:35:14 hrs PST8PDT Bugs fixed: 10149223 Patch 4247037 : applied on Sat Mar 18 12:26:48 AST 2017 Unique Patch ID: 13016142 Created on 17 SEP 2009, 09:52:00 hrs US/Pacific Bugs fixed: 4247037

------------------------------------------------------------------------------OPatch succeeded. [oraerp@rac1 13004894]$

2. UPGRADE STEPS Run utlu112i.sql from 11.1.0.7 Home [oraerp@rac1 [oraerp@rac1 [oraerp@rac1 [oraerp@rac1 total 204 -rw-r--r-- 1 [oraerp@rac1 [oraerp@rac1

~]$ ~]$ . PROD_rac1.env ~]$ cd /shrf/db_scripts/ db_scripts]$ ll utlu112i.sql oraerp dbaerp 204205 Mar 18 12:44 utlu112i.sql db_scripts]$ db_scripts]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Sat Mar 18 12:48:23 2017

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 35 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Copyright (c) 1982, 2008, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> @utlu112i.sql Oracle Database 11.2 Pre-Upgrade Information Tool 03-18-2017 12:48:39 Script Version: 11.2.0.2.0 Build: 001 . ********************************************************************** Database: ********************************************************************** --> name: PROD --> version: 11.1.0.7.0 --> compatible: 11.1.0 --> blocksize: 8192 --> platform: Linux x86 64-bit --> timezone file: V10 . ********************************************************************** Tablespaces: [make adjustments in the current environment] ********************************************************************** --> SYSTEM tablespace is adequate for the upgrade. .... minimum required size: 11707 MB --> CTXD tablespace is adequate for the upgrade. .... minimum required size: 16 MB --> ODM tablespace is adequate for the upgrade. .... minimum required size: 10 MB --> APPS_UNDOTS1 tablespace is adequate for the upgrade. .... minimum required size: 260 MB --> APPS_TS_TX_DATA tablespace is adequate for the upgrade. .... minimum required size: 25978 MB --> APPS_TS_QUEUES tablespace is adequate for the upgrade. .... minimum required size: 173 MB --> SYSAUX tablespace is adequate for the upgrade. .... minimum required size: 1158 MB . ********************************************************************** Flashback: OFF ********************************************************************** ********************************************************************** Update Parameters: [Update Oracle Database 11.2 init.ora or spfile] Note: Pre-upgrade tool was run on a lower version 64-bit database. ********************************************************************** --> If Target Oracle is 32-Bit, refer here for Update Parameters: -- No update parameter changes are required. . --> If Target Oracle is 64-Bit, refer here for Update Parameters: -- No update parameter changes are required. http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 36 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux . ********************************************************************** Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile] ********************************************************************** -- No renamed parameters found. No changes are required. . ********************************************************************** Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile] ********************************************************************** --> plsql_native_library_dir 11.2 OBSOLETE --> plsql_native_library_subdir_ 11.2 OBSOLETE . ********************************************************************** Components: [The following database components will be upgraded or installed] ********************************************************************** --> Oracle Catalog Views [upgrade] VALID --> Oracle Packages and Types [upgrade] VALID --> JServer JAVA Virtual Machine [upgrade] VALID --> Oracle XDK for Java [upgrade] VALID --> Real Application Clusters [upgrade] INVALID --> OLAP Analytic Workspace [upgrade] VALID --> OLAP Catalog [upgrade] VALID --> Oracle Text [upgrade] VALID --> Oracle XML Database [upgrade] VALID --> Oracle Java Packages [upgrade] VALID --> Oracle interMedia [upgrade] VALID --> Spatial [upgrade] VALID --> Data Mining [upgrade] VALID --> Oracle OLAP API [upgrade] VALID . ********************************************************************** Miscellaneous Warnings ********************************************************************** WARNING: --> Database is using a timezone file older than version 14. .... After the release migration, it is recommended that DBMS_DST package .... be used to upgrade the 11.1.0.7.0 database timezone version .... to the latest version which comes with the new release. WARNING: --> Database contains INVALID objects prior to upgrade. .... The list of invalid SYS/SYSTEM objects was written to .... registry$sys_inv_objs. .... The list of non-SYS/SYSTEM objects was written to .... registry$nonsys_inv_objs. .... Use utluiobj.sql after the upgrade to identify any new invalid .... objects due to the upgrade. .... USER APPS has 30 INVALID objects. WARNING: --> Your recycle bin contains 14 object(s). .... It is REQUIRED that the recycle bin is empty prior to upgrading .... your database. The command: PURGE DBA_RECYCLEBIN .... must be executed immediately prior to executing your upgrade.

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 37 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package. .... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs. .... USER APPS has dependent objects. . ********************************************************************** Recommendations ********************************************************************** Oracle recommends gathering dictionary statistics prior to upgrading the database. To gather dictionary statistics execute the following command while connected as SYSDBA: EXECUTE dbms_stats.gather_dictionary_stats; ********************************************************************** Oracle recommends removing all hidden parameters prior to upgrading. To view existing hidden parameters execute the following command while connected AS SYSDBA: SELECT name,description from SYS.V$PARAMETER WHERE name LIKE '\_%' ESCAPE '\' Changes will need to be made in the init.ora or spfile. ********************************************************************** Oracle recommends reviewing any defined events prior to upgrading. To view existing non-default events execute the following commands while connected AS SYSDBA: Events: SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2 WHERE UPPER(name) ='EVENT' AND isdefault='FALSE' Trace Events: SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2 WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE' Changes will need to be made in the init.ora or spfile. ********************************************************************** The DMSYS schema exists in the database. Prior to performing an upgrade Oracle recommends that the DMSYS schema, and its associated objects be removed from the database. Refer to the Oracle Data Mining Administration Guide for the instructions on how to perform this task. ********************************************************************** SQL> SQL> http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 38 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Clear Your Recycle bin as per above WARNING SQL> SQL> show user USER is "SYS" SQL> SQL> PURGE DBA_RECYCLEBIN; SQL>

Gather Dictionary statistics as per Recommendations SQL> SQL> show user USER is "SYS" SQL> EXECUTE dbms_stats.gather_dictionary_stats; SQL>

Stop application Services and Database Listener for EBS [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ adopmnctl.sh status You are running adopmnctl.sh version 120.6.12010000.4 Checking status of OPMN managed processes... Processes in Instance: PROD_rac1.rac1.dell.com ---------------------------------+--------------------+---------+--------ias-component | process-type | pid | status ---------------------------------+--------------------+---------+--------OC4JGroup:default_group | OC4J:oafm | 7834 | Alive OC4JGroup:default_group | OC4J:forms | 7762 | Alive OC4JGroup:default_group | OC4J:oacore | 7612 | Alive HTTP_Server | HTTP_Server | 7555 | Alive adopmnctl.sh: exiting with status 0 adopmnctl.sh: check the logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adopmnctl.txt for more information ... [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ adstpall.sh apps/apps adstpall.sh: exiting with status 0 [oraerp@rac1 ~]$ adopmnctl.sh status You are running adopmnctl.sh version 120.6.12010000.4

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 39 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Checking status of OPMN managed processes... Unable to connect to opmn. Opmn may not be up. adopmnctl.sh: exiting with status 0 adopmnctl.sh: check the logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adopmnctl.txt for more information ... [oraerp@rac1 [oraerp@rac1 [oraerp@rac1 [oraerp@rac1

~]$ ~]$ ~]$ . PROD_rac1.env ~]$ lsnrctl stop PROD

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 18-MAR-2017 13:03:33 Copyright (c) 1991, 2008, Oracle.

All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.dell.com)(PORT=1531))) The command completed successfully [oraerp@rac1 ~]$

Editing Pfile Comment on local_listener In order to avoid the following error during upgrade remove local_listener parameter, else you will get following error ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name ‘*******‘ ORA-01078: failure in processing system parameters

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 40 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

[oraerp@rac1 ~]$ [oraerp@rac1 ~]$ . PROD_rac1.env [oraerp@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Sat Mar 18 13:05:03 2017 SQL> show parameter local_listener NAME TYPE VALUE ------------------------------------ ----------- ----------------------------local_listener string PROD_LOCAL SQL> SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> exit

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 41 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oraerp@rac1 ~]$ [oraerp@rac1 dbs]$ cd /u01/db/tech_st/11.1.0/dbs/ [oraerp@rac1 dbs]$ vi initPROD.ora [oraerp@rac1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Sat Mar 18 13:11:41 2017 Copyright (c) 1982, 2008, Oracle.

All rights reserved.

Connected to an idle instance. SQL> startup Database mounted. Database opened. SQL> show parameter local_listener NAME TYPE VALUE ------------------------------------ ----------- ----------------------------local_listener string SQL> NOTE: I have commented(#) on local_listener parameter

Upgradation (took almost 2hr for 100GB data on 8Gb RAM) NOTE: Before you run dbua check /etc/oratab file for entry of your Current database details as shown above PROD:/u01/db/tech_st/11.1.0:N [root@rac1 ~]# [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ cd /u01/db/tech_st/11.2.0/bin/ [oraerp@rac1 bin]$ ll dbua -rwxr-xr-x 1 oraerp dbaerp 7873 Mar 18 12:04 dbua [oraerp@rac1 bin]$ ./dbua -initParam "_disable_fast_validate=TRUE"

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 42 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 43 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 44 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 45 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 46 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 47 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 48 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 49 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 50 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 51 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

You can check the log file during upgrade [root@rac1 ~]# cd /u01/cfgtoollogs/dbua/PROD/upgrade1/ [oraerp@rac1 upgrade1]$ ll total 29952 -rw-r----- 1 oraerp dbaerp 4688 Mar 18 13:30 mapfile.txt -rw-r----- 1 oraerp dbaerp 30323250 Mar 18 13:57 Oracle_Server.log -rw-r----- 1 oraerp dbaerp 2850 Mar 18 13:39 Oracle_Text.log -rw-r----- 1 oraerp dbaerp 1499 Mar 18 13:39 PreUpgrade.log -rw-r----- 1 oraerp dbaerp 9274 Mar 18 13:39 PreUpgradeResults.html -rw-r----- 1 oraerp dbaerp 257 Mar 18 13:39 SpaceUsage.txt -rw-r----- 1 oraerp dbaerp 68370 Mar 18 13:42 sqls.log -rw-r----- 1 oraerp dbaerp 187190 Mar 18 13:56 trace.log -rw-r----- 1 oraerp dbaerp 1127 Mar 18 13:30 Upgrade_Directive.log -rw-r----- 1 oraerp dbaerp 3320 Mar 18 13:29 upgrade.xml [oraerp@rac1 upgrade1]$ [oraerp@rac1 upgrade1]$ tail -f /u01/cfgtoollogs/dbua/PROD/upgrade1/Oracle_Server.log

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 52 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Ignore the following error ORA-01408

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 53 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 54 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 55 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 56 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 57 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Check the Upgrade Log for any Errors Check the invalid objects and compile [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ cd /shrf/db_scripts/ [oraerp@rac1 db_scripts]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 15:59:23 2017 Copyright (c) 1982, 2010, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------71 SQL> SQL> column owner format A12 column object_type format A13 select owner,object_type,COUNT(*) from dba_objects where status='INVALID' group by owner, object_type; OWNER -----------APPS APPS

OBJECT_TYPE COUNT(*) ------------- ---------PACKAGE BODY 58 MATERIALIZED 13 VIEW

SQL> SQL> @/u01/db/tech_st/11.2.0/rdbms/admin/utlrp.sql TIMESTAMP ------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_BGN 2017-03-18 16:00:59 DOC> DOC>

The following PL/SQL block invokes UTL_RECOMP to recompile invalid objects in the database. Recompilation time is proportional to the

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 58 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC> DOC>#

number of invalid objects in the database, so this command may take a long time to execute on a database with a large number of invalid objects. Use the following queries to track recompilation progress: 1. Query returning the number of invalid objects remaining. This number should decrease with time. SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6); 2. Query returning the number of objects compiled so far. This number should increase with time. SELECT COUNT(*) FROM UTL_RECOMP_COMPILED; This script automatically chooses serial or parallel recompilation based on the number of CPUs available (parameter cpu_count) multiplied by the number of threads per CPU (parameter parallel_threads_per_cpu). On RAC, this number is added across all RAC nodes. UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel recompilation. Jobs are created without instance affinity so that they can migrate across RAC nodes. Use the following queries to verify whether UTL_RECOMP jobs are being created and run correctly: 1. Query showing jobs created by UTL_RECOMP SELECT job_name FROM dba_scheduler_jobs WHERE job_name like 'UTL_RECOMP_SLAVE_%'; 2. Query showing UTL_RECOMP jobs that are running SELECT job_name FROM dba_scheduler_running_jobs WHERE job_name like 'UTL_RECOMP_SLAVE_%';

PL/SQL procedure successfully completed. TIMESTAMP ------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_END 2017-03-18 16:01:30 DOC> The following query reports the number of objects that have compiled DOC> with errors (objects that compile with errors have status set to 3 in DOC> obj$). If the number is higher than expected, please examine the error DOC> messages reported with each object (using SHOW ERRORS) to see if they DOC> point to system misconfiguration or resource constraints that must be DOC> fixed before attempting to recompile these objects. DOC># OBJECTS WITH ERRORS ------------------0

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 59 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux DOC> The following query reports the number of errors caught during DOC> recompilation. If this number is non-zero, please query the error DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors DOC> are due to misconfiguration or resource constraints that must be DOC> fixed before objects can compile successfully. DOC># ERRORS DURING RECOMPILATION --------------------------43 Function created. PL/SQL procedure successfully completed. Function dropped. PL/SQL procedure successfully completed. SQL> SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------59 SQL> SQL> column owner format A12 column object_type format A13 select owner,object_type,COUNT(*) from dba_objects where status='INVALID' group by owner, object_type; OWNER OBJECT_TYPE COUNT(*) ------------ ------------- ---------APPS PACKAGE BODY 58 APPS MATERIALIZED 1 VIEW SQL> SQL> exit

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 60 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux 3. POST UPGRADE STEPS Run adgrants,.sql [[root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ cd /shrf/db_scripts/ [oraerp@rac1 db_scripts]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 16:04:48 2017 Copyright (c) 1982, 2010, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @adgrants.sql Connected. ----------------------------------------------------- adgrants.sql started at 2017-03-18 16:04:58 --Enter value for 1: APPLSYS Creating PL/SQL profiler objects.

----------------------------------------------------- profload.sql started at 2017-03-18 16:05:04 --Package created. Grant succeeded. Synonym created. Library created. Package body created. Testing for correct installation SYS.DBMS_PROFILER successfully loaded. PL/SQL procedure successfully completed. http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 61 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux ------------------------------------------------------- profload.sql completed at 2017-03-18 16:05:06 ---

---------------------------------------------------- proftab.sql started at 2017-03-18 16:05:06 --Table dropped. Table dropped. Table dropped. Sequence dropped. Table created. Comment created. Table created. Comment created. Table created. Comment created. Sequence created.

------------------------------------------------------- profltab.sql completed at 2017-03-18 16:05:06 --Creating PL/SQL Package AD_DBMS_METADATA. Package created. http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 62 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Package body created. End of Creating PL/SQL Package AD_DBMS_METADATA. PL/SQL procedure successfully completed. Commit complete. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oraerp@rac1 db_scripts]$

Grant create procedure privilege on CTXSYS [oraerp@rac1 db_scripts]$ [oraerp@rac1 db_scripts]$ sqlplus apps/apps @adctxprv.sql manager CTXSYS SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 16:06:37 2017 Copyright (c) 1982, 2010, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Connecting to SYSTEM Connected. PL/SQL procedure successfully completed. Commit complete. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oraerp@rac1 db_scripts]$

Set CTXSYS parameter [oraerp@rac1 db_scripts]$ [oraerp@rac1 db_scripts]$ sqlplus / as sysdba

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 63 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 16:07:12 2017 Copyright (c) 1982, 2010, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role','public'); PL/SQL procedure successfully completed. SQL>

Start database Listener form 11.2.0.2 Home [root@rac1 ~]# [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ lsnrctl start PROD LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 18-MAR-2017 16:09:26 Copyright (c) 1991, 2010, Oracle.

All rights reserved.

Starting /u01/db/tech_st/11.2.0/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.2.0 - Production System parameter file is /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/listener.ora Log messages written to /u01/db/tech_st/11.2.0/network/admin/prod.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.dell.com)(PORT=1531))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.dell.com)(PORT=1531))) STATUS of the LISTENER -----------------------Alias PROD Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 18-MAR-2017 16:09:26 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/listener.ora Listener Log File /u01/db/tech_st/11.2.0/network/admin/prod.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.dell.com)(PORT=1531))) Services Summary... http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 64 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Service "PROD" has 1 instance(s). Instance "PROD", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oraerp@rac1 ~]$

Validate Workflow ruleset [root@rac1 ~]# [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ cd /shrf/db_scripts/ [oraerp@rac1 db_scripts]$ sqlplus apps/apps @wfaqupfix.sql APPLSYS APPS SQL*Plus: Release 10.1.0.5.0 - Production on Sat Mar 18 16:09:51 2017 Copyright (c) 1982, 2005, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options PL/SQL procedure successfully completed. Commit complete. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oraerp@rac1 db_scripts]$

Creation of Appsutil Direcorty [[root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ perl $AD_TOP/bin/admkappsutil.pl Starting the generation of appsutil.zip Log file located at /u01/inst/apps/PROD_rac1/admin/log/MakeAppsUtil_03181612.log output located at /u01/inst/apps/PROD_rac1/admin/out/appsutil.zip MakeAppsUtil completed successfully. [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ cp /u01/inst/apps/PROD_rac1/admin/out/appsutil.zip /u01/db/tech_st/11.2.0/ [oraerp@rac1 ~]$ [oraerp@rac1 ~]$ cd /u01/db/tech_st/11.2.0/ [oraerp@rac1 11.2.0]$ [oraerp@rac1 11.2.0]$ unzip -o appsutil.zip [oraerp@rac1 11.2.0]$ http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 65 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Buliding xml file for database using adbldxml.pl [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ cd /u01/db/tech_st/11.2.0/appsutil/bin/ [oraerp@rac1 bin]$ perl adbldxml.pl Starting context file generation for db tier.. Using JVM from /u01/db/tech_st/11.2.0/jdk/jre/bin/java to execute java programs.. APPS Password: apps The log file for this adbldxml session is located at: /u01/db/tech_st/11.2.0/appsutil/log/adbldxml_03181617.log UnsatisfiedLinkError exception loading native library: njni11 java.lang.UnsatisfiedLinkError: no njni11 in java.library.path Could not Connect to the Database with the above parameters, Please answer the Questions below Enter Hostname of Database server: rac1.dell.com Enter Port of Database server: 1531 Enter SID of Database server: PROD Enter the value for Display Variable: 1.0 The context file has been created at: /u01/db/tech_st/11.2.0/appsutil/PROD_rac1.xml [oraerp@rac1 bin]$

Run Auto config on dbTier using adconfig.pl [root@rac1 ~]# su – oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ cd u01/db/tech_st/12.1.0/appsutil/bin [oraerp@rac1 bin]$ perl adconfig.pl Enter the full file path to the Context file: /u01/db/tech_st/11.2.0/appsutil/PROD_rac1.xml Enter the APPS user password:apps The log file for this session is located at: /u01/db/tech_st/11.2.0/appsutil/log/PROD_rac1/03181618/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 66 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Using ORACLE_HOME location : /u01/db/tech_st/11.2.0 Classpath : :/u01/db/tech_st/11.2.0/jdbc/lib/ojdbc5.jar:/u01/db/tech_st/11.2.0/appsutil/j ava/xmlparserv2.jar:/u01/db/tech_st/11.2.0/appsutil/java:/u01/db/tech_st/11.2 .0/jlib/netcfg.jar:/u01/db/tech_st/11.2.0/jlib/ldapjclnt11.jar Using Context file : /u01/db/tech_st/11.2.0/appsutil/PROD_rac1.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Updating rdbms version in Context file to db112 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ... AutoConfig completed successfully. [oraerp@rac1 bin]$

Gather Statistics for “SYS” schema [root@rac1 ~]# su – oraerp [oraerp@rac1 ~]$ . 11gR2.env [oraerp@rac1 ~]$ cd /shrf/db_scripts/ [oraerp@rac1 db_scripts]$ ll adstats.sql -rwxr-xr-x 1 oraerp dbaerp 2752 Mar 18 14:39 adstats.sql [oraerp@rac1 db_scripts]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 16:23:16 2017 Copyright (c) 1982, 2010, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter system enable restricted session; System altered. SQL> @adstats.sql Connected. -------------------------------------------------http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 67 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux --- adstats.sql started at 2017-03-18 16:23:31 --Checking for the DB version and collecting statistics ... PL/SQL procedure successfully completed.

-------------------------------------------------- adstats.sql ended at 2017-03-18 16:32:02 --Commit complete. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oraerp@rac1 db_scripts]$ [oraerp@rac1 db_scripts]$ [oraerp@rac1 db_scripts]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 16:35:41 2017 Copyright (c) 1982, 2010, Oracle.

All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter system disable restricted session; System altered. SQL>

Re-create Grants and Synonyms using ADADMIN (4-2) [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ adadmin Saving product information. AD code level : [B.3] AD Administration Main Menu -------------------------------------------------1.

Generate Applications Files menu

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 68 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux 2.

Maintain Applications Files menu

3.

Compile/Reload Applications Database Entities menu

4.

Maintain Applications Database Entities menu

5.

Change Maintenance Mode

6.

Exit AD Administration

Enter your choice [6] : 4 Maintain Applications Database Entities --------------------------------------------------1.

Validate APPS schema

2.

Re-create grants and synonyms for APPS schema

3.

Maintain multi-lingual tables

4.

Check DUAL table

5.

Return to Main Menu

Enter your choice [5] : 2 AD utilities can support a maximum of 999 workers. Your current database configuration supports a maximum of 123 workers. Oracle recommends that you use between 2 and 4 workers. Enter the number of workers [2] : (PRESS ENTER)

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 69 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Run Autoconfig on AppsTier [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ cd $ADMIN_SCRIPTS_HOME [oraerp@rac1 scripts]$ ./adautocfg.sh Enter the APPS user password: apps The log file for this session is located at: /u01/inst/apps/PROD_rac1/admin/log/03061800/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : /u01/inst/apps/PROD_rac1 Classpath : /u01/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/apps/apps_st/comn/java/cla sses Using Context file : /u01/inst/apps/PROD_rac1/appl/admin/PROD_rac1.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Configuring templates from all of the product tops... Configuring AD_TOP........COMPLETED Configuring FND_TOP.......COMPLETED Configuring ICX_TOP.......COMPLETED Configuring MSC_TOP.......COMPLETED Configuring IEO_TOP.......COMPLETED Configuring BIS_TOP.......COMPLETED Configuring AMS_TOP.......COMPLETED Configuring CCT_TOP.......COMPLETED Configuring WSH_TOP.......COMPLETED Configuring CLN_TOP.......COMPLETED Configuring OKE_TOP.......COMPLETED Configuring OKL_TOP.......COMPLETED Configuring OKS_TOP.......COMPLETED Configuring CSF_TOP.......COMPLETED Configuring IGS_TOP.......COMPLETED Configuring IBY_TOP.......COMPLETED Configuring JTF_TOP.......COMPLETED Configuring MWA_TOP.......COMPLETED Configuring CN_TOP........COMPLETED Configuring CSI_TOP.......COMPLETED Configuring WIP_TOP.......COMPLETED Configuring CSE_TOP.......COMPLETED Configuring EAM_TOP.......COMPLETED http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 70 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Configuring Configuring Configuring Configuring Configuring Configuring Configuring Configuring

FTE_TOP.......COMPLETED ONT_TOP.......COMPLETED AR_TOP........COMPLETED AHL_TOP.......COMPLETED OZF_TOP.......COMPLETED IES_TOP.......COMPLETED CSD_TOP.......COMPLETED IGC_TOP.......COMPLETED

AutoConfig completed successfully. [oraerp@rac1 scripts]$

Restart Applications server processes [root@rac1 ~]# su - oraerp [oraerp@rac1 ~]$ . APPSPROD_rac1.env [oraerp@rac1 ~]$ cd $ADMIN_SCRIPTS_HOME [oraerp@rac1 scripts]$ adstrtall.sh ---------adstrtal.sh: Exiting with status 0 adstrtal.sh: check the logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adstrtal.log for more information ... [oraerp@rac1 scripts]$ adopmnctl.sh status You are running adopmnctl.sh version 120.6.12010000.4 Checking status of OPMN managed processes... Processes in Instance: PROD_rac1.rac1.dell.com ---------------------------------+--------------------+---------+--------ias-component | process-type | pid | status ---------------------------------+--------------------+---------+--------OC4JGroup:default_group | OC4J:oafm | 7834 | Alive OC4JGroup:default_group | OC4J:forms | 7762 | Alive OC4JGroup:default_group | OC4J:oacore | 7612 | Alive HTTP_Server | HTTP_Server | 7555 | Alive adopmnctl.sh: exiting with status 0 adopmnctl.sh: check the logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adopmnctl.txt for more information ... [oraerp@rac1 scripts]$

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 71 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux Check the Database status from Front end and run Active user req.

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 72 of 73

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

Hope this Artice Helps who are looking for upgrading their EBS database from 11.10.7 to 11.2.0.2 Thanks for Reading Regards, Mohammed Areefuddin

http://my-orcl.blogspot.com/2017/03/oracle-ebs-database-upgrade-from-11107_18.html

Page 73 of 73

Oracle database upgrade to 11202 in Apps R1213.pdf

11.1.0.7 to 11.2.0.2 in Linux ... Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ... Install Oracle 11.2.0.2 Software Only.
Download PDF
4MB Sizes 1 Downloads 83 Views
Report

Recommend Documents

Read Online OCP Upgrade to Oracle Database 12c ...
privileges, data redaction, and other. Oracle security features ... Oracle Recovery Manager backup and recovery improvements Oracle. Database Resource ...
So you want to connect to an Oracle Database?
Connect to an Oracle Database from within Visual Basic 6 (Part 1) ... One of the things I am most frequently asked about is using Visual Basic 6 to connect to an ...
Using xDB to Offload Oracle Reporting Database to Postgres-script ...
Using xDB to Offload Oracle Reporting Database to Postgres-script-2.pdf. Using xDB to Offload Oracle Reporting Database to Postgres-script-2.pdf. Open.
Oracle Apps BY RAZIA BANU.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Main menu.
Oracle Apps Info – Krishna Reddy - GitHub
May 13, 2015 - In the abvoe program, we have hard coded the value 10 and 20 in the program. ...... with the concurrent request data extracts to generate output in PDF, HTML, RTF, ..... URI or mount them into the web server directory structure and acc
Oracle Apps DBA Training Contents
Oracle Apps DBA Training Contents. 1) Oracle Applications Background. 2) Oracle Applications E-business Suite Current,Logical, physical and functional ...
oracle apps dba tutorial pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. oracle apps dba ...