Areef DBA: 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

tmpfs 4.0G 0 4.0G 0% /dev/shm

/dev/sr0 3.6G 3.6G 0 100% /media/OL5.7 x86_64 dvd 20110728

.host:/ 466G 188G 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 ~]$

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

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>

SQL> select count(*) from dba_objects where status='INVALID';

COUNT(*)

----------

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 do following Activity (MANDATORY)

1. Run Concurrent Request "Gather Schema Statistics" for "ALL" Users.

2. Compile Apps Schecma using adadmin (3à1), before upgrade

3. Run Connurrent Request "Purge Concurrent Request and/or Manager Data"

Let’s Check Database version before proceeding to UPGRADE

Application and Database Patches

Application Patches for 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]$

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-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 179103 Mar 1 16:48 p10160615_112020_Linux-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 235602 Mar 1 16:48 p10229719_112020_Linux-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 102277 Mar 1 16:48 p12400751_112020_Linux-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 123965 Mar 1 16:48 p12942119_112020_Linux-x86-64.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-x86-64.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 ~]$ mkdir -p /u01/db/tech_st/11.2.0

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]$

Click Fix & Check Again button

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 ~]#

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

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

Before Proceeding Further take Cold Backup

Copy of files ( vi editor :%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]$ 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 ~]$ cd /shrf/db_scripts/

[oraerp@rac1 db_scripts]$ ll

total 580

-rwxr-xr-x 1 oraerp dbaerp 1664 Mar 18 14:39 adctxprv.sql

-rwxr-xr-x 1 oraerp dbaerp 53060 Mar 18 14:39 adgrants.sql

-rwxr-xr-x 1 oraerp dbaerp 2752 Mar 18 14:39 adstats.sql

-rwxr-xr-x 1 oraerp dbaerp 3221 Mar 18 14:42 utlrp.sql

-rw-r--r-- 1 oraerp dbaerp 204205 Mar 18 12:44 utlu112i.sql

-rwxr-xr-x 1 oraerp dbaerp 4631 Mar 18 14:39 wfaqupfix.sql

[oraerp@rac1 db_scripts]$

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

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

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

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

------------------------------

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 4247037]$

[oraerp@rac1 4247037]$ opatch apply

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Oracle Home : /u01/db/tech_st/11.2.0

Central Inventory : /u01/oraInventory/

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.2.0.2.0

OUI location : /u01/db/tech_st/11.2.0/oui

Log file location : /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-18_12-26-44PM.log

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

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

Oracle Home : /u01/db/tech_st/11.2.0

Central Inventory : /u01/oraInventory/

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.2.0.2.0

OUI location : /u01/db/tech_st/11.2.0/oui

Log file location : /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-18_12-28-52PM.log

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]

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" with "lib/libserver11.a/kkqu.o"

Running make for target ioracle

ApplySession adding interim patch '10149223' to inventory

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 apply

OPatch succeeded.

[oraerp@rac1 10229719]$ opatch apply

OPatch succeeded.

[oraerp@rac1 12400751]$ opatch apply

OPatch succeeded.

[oraerp@rac1 13001379]$ opatch apply

OPatch succeeded.

[oraerp@rac1 13004894]$ opatch apply

OPatch succeeded.

[oraerp@rac1 13004894]$ opatch lsinventory

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Oracle Home : /u01/db/tech_st/11.2.0

Central Inventory : /u01/oraInventory/

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.2.0.2.0

OUI location : /u01/db/tech_st/11.2.0/oui

Log file location : /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-18_12-34-17PM.log

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-34-17PM.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:

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 ~]$ . PROD_rac1.env

[oraerp@rac1 ~]$ cd /shrf/db_scripts/

[oraerp@rac1 db_scripts]$ ll utlu112i.sql

total 204

-rw-r--r-- 1 oraerp dbaerp 204205 Mar 18 12:44 utlu112i.sql

[oraerp@rac1 db_scripts]$

[oraerp@rac1 db_scripts]$ sqlplus / as sysdba

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

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.

**********************************************************************

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.

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>

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...

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 ~]$ . PROD_rac1.env

[oraerp@rac1 ~]$ lsnrctl stop PROD

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 18-MAR-2017 13:03:33

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

[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

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

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 almost 1hr 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"

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

Ignore the following error ORA-01408

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

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(*)

----------

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> The following PL/SQL block invokes UTL_RECOMP to recompile invalid

DOC> objects in the database. Recompilation time is proportional to the

DOC> number of invalid objects in the database, so this command may take

DOC> a long time to execute on a database with a large number of invalid

DOC> objects.

DOC>

DOC> Use the following queries to track recompilation progress:

DOC>

DOC> 1. Query returning the number of invalid objects remaining. This

DOC> number should decrease with time.

DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

DOC>

DOC> 2. Query returning the number of objects compiled so far. This number

DOC> should increase with time.

DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;

DOC>

DOC> This script automatically chooses serial or parallel recompilation

DOC> based on the number of CPUs available (parameter cpu_count) multiplied

DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).

DOC> On RAC, this number is added across all RAC nodes.

DOC>

DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel

DOC> recompilation. Jobs are created without instance affinity so that they

DOC> can migrate across RAC nodes. Use the following queries to verify

DOC> whether UTL_RECOMP jobs are being created and run correctly:

DOC>

DOC> 1. Query showing jobs created by UTL_RECOMP

DOC> SELECT job_name FROM dba_scheduler_jobs

DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>

DOC> 2. Query showing UTL_RECOMP jobs that are running

DOC> SELECT job_name FROM dba_scheduler_running_jobs

DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>#

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

-------------------

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

---------------------------

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(*)

----------

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>

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

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.

-----------------------------------------------------

--- profload.sql completed at 2017-03-18 16:05:06 ---

--------------------------------------------------

--- proftab.sql started at 2017-03-18 16:05:06 ---

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.

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

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

SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 16:07:12 2017

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

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...

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

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]$

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.

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/java/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

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.

--------------------------------------------------

--- 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]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sat Mar 18 16:35:41 2017

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

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)

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/classes

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

Configuring FTE_TOP.......COMPLETED

Configuring ONT_TOP.......COMPLETED

Configuring AR_TOP........COMPLETED

Configuring AHL_TOP.......COMPLETED

Configuring OZF_TOP.......COMPLETED

Configuring IES_TOP.......COMPLETED

Configuring CSD_TOP.......COMPLETED

Configuring 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]$

Check the Database status from Front end and run Active user req.

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

Areef DBA

Search This Blog

Saturday, March 18, 2017

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 11.2.0.2 in Linux

No comments:

Post a Comment