my-orcl@Areef DBA, my-orcl@Arif DBA: ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 12.1.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 12.1.0.2 in Linux 5.7_x64

MOS DOCUMENTS

Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)

Oracle E-Business suite R12.1.3 will be shipped with database version 11.1.0.7.

Basic Question : Is ther direct upgrade from 11.1.0.7 to 12.1.0.2 (YES)

Pre Upgrade Steps

1. Install Oracle 12.1.0.2 Software Only

2. Install Examples CD

3. Copy of Files form Database & Application Servers

4. shutdown Application and database Listener

5. Apply Application Patches using adpatch

Upgrade Steps

1. run upgrade Commands from 11g home and fix issues

2. edit initfile parameters

3. run dbua command

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

NOTE: Make the apporopriate Setting as per your env. and move futher [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 ~]#

[root@rac1 ~]# cat /etc/oratab

PROD:/u01/db/tech_st/11.1.0:N

[root@rac1 ~]#

[root@rac1 ~]# cat /etc/oraInst.loc

inventory_loc=/u01/oraInventory/

inst_group=dbaerp

[root@rac1 ~]#

[root@rac1 ~]# chmod -R 775 /etc/oraInst.loc

[root@rac1 ~]# mkdir -p /u01/oraInventory/

[root@rac1 ~]# mkdir -p /u01/db/tech_st/12.1.0

[root@rac1 ~]# chown -R oraerp:dbaerp /u01

[root@rac1 ~]# chmod -R 775 /u01/

[root@rac1 ~]# chmod -R 775 /u01/oraInventory/

[root@rac1 ~]# grep SwapTotal /proc/meminfo

SwapTotal: 30716272 kB

[root@rac1 ~]#

[root@rac1 ~]# su - oraerp

[oraerp@rac1 ~]$ id

uid=54322(oraerp) gid=54323(dbaerp) groups=54323(dbaerp)

[oraerp@rac1 ~]$

For better performance in Upgrade

1. Run Gather Schema Stats,before upgrade

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

3. Purge Concurrent and manger data before upgrade

Patches for UPGRADE

Application patches for upgrading

[root@rac1 apps_patches_12102]# ll

total 29668

-rwxr-xr-x 1 oraerp dbaerp 424067 Mar 1 16:50 p12923944_R12.FND.B_R12_LINUX.zip

-rwxr-xr-x 1 oraerp dbaerp 14042 Mar 1 16:50 p13473483_R12.IBE.B_R12_GENERIC.zip

-rwxr-xr-x 1 oraerp dbaerp 1563085 Mar 1 16:50 p16289505_12.1.0_R12_LINUX.zip

-rwxr-xr-x 1 oraerp dbaerp 3875279 Mar 1 16:50 p18843706_R12.CSP.B_R12_GENERIC.zip

-rwxr-xr-x 1 oraerp dbaerp 24447896 Mar 1 16:50 p19558309_R12.AR.B_R12_LINUX.zip

[root@rac1 apps_patches_12102]#

Database patches for RDBMS 12.1.0.2

[root@rac1 db_patches_12102]# ll

total 1784

-rwxr-xr-x 1 oraerp dbaerp 145172 Mar 1 16:50 p19382851_121020_Linux-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 149667 Mar 1 16:50 p19393542_121020_Linux-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 490295 Mar 1 16:50 p19627012_121020_Linux-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 300727 Mar 1 16:50 p19649152_121020_Linux-x86-64.zip

-rwxr-xr-x 1 oraerp dbaerp 598203 Mar 1 16:50 p20204035_121020_Generic.zip

-rwxr-xr-x 1 oraerp dbaerp 94477 Mar 1 16:50 p22731026_121020_Generic.zip

[root@rac1 db_patches_12102]#

Before upgrading let’s check current database version for EBS R12.1.3 it is 11.1.0.7

Installation of RDBMS 12.1.0.2 Software

Note :Before install 11gR2 check your central Inventory details in /etc/oraInst.loc file and 775 permission as shown above

[root@rac1 db_12102_x64]# ll

total 1704800

drwxr-xr-x 2 root root 4096 Feb 26 10:15 database

drwxr-xr-x 2 root root 4096 Feb 26 10:15 examples

-rwxrwxrwx 1 root root 1673519571 Feb 28 15:39 p21419221_121020_Linux-x86-64_1of10.zip

-rwxrwxrwx 1 root root 1014527110 Feb 28 15:51 p21419221_121020_Linux-x86-64_2of10.zip

-rwxrwxrwx 1 root root 499236859 Mar 1 08:24 p21419221_121020_Linux-x86-64_9of10.zip

[root@rac1 db_12102_x64]# chown -R oraerp:dbaerp database/ examples/

[root@rac1 db_12102_x64]#

Run the fixup scripts

[root@rac1 ~]# /tmp/CVU_12.1.0.2.0_oraerp/runfixup.sh

All Fix-up operations were completed successfully.
[root@rac1 ~]#

Execute Root Scripts

[root@rac1 ~]# /u01/db/tech_st/12.1.0/root.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oraerp

ORACLE_HOME= /u01/db/tech_st/12.1.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:

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.

[root@rac1 ~]#

Now Install Examples CD

Before Proceeding Further take Cold Backup, Backup

Copy of Files from Database and Application Server

1. Copy Listener & tns folder from OLD_HOME to NEW_HOME and change values of ORACLE_HOME (11.1.0) to NEW_HOME (12.1.0)

vi editor command (ESC MODE :%s/11.1.0/12.1.0/g )

[oraerp@rac1 network]$ pwd

/u01/db/tech_st/11.1.0/network

[oraerp@rac1 network]$ cp -R admin/ /u01/db/tech_st/12.1.0/network/

[oraerp@rac1 ~]$ vi /u01/db/tech_st/12.1.0/network/admin/PROD_rac1/listener.ora

[oraerp@rac1 ~]$ vi /u01/db/tech_st/12.1.0/network/admin/PROD_rac1/tnsnames.ora

[oraerp@rac1 ~]$ vi /u01/db/tech_st/12.1.0/network/admin/PROD_rac1/sqlnet.ora

2. Copy upgrade scripts from NEW_HOME

[oraerp@rac1 12.1.0]$ cd /u01/db/tech_st/12.1.0/rdbms/admin/

[oraerp@rac1 admin]$ cp utluppkg.sql preupgrd.sql utlrp.sql /shrf/db_scripts/

3. Copy files from Application Server

[root@rac1 db_12102_x64]# su - oraerp

[oraerp@rac1 ~]$ . APPSPROD_rac1.env

[oraerp@rac1 ~]$ cp $APPL_TOP/admin/adgrants.sql /shrf/db_scripts/

[oraerp@rac1 admin]$ cp $AD_TOP/patch/115/sql/adctxprv.sql /shrf/db_scripts/

[oraerp@rac1 12.0.0]$ 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 6 09:07 adctxprv.sql

-rwxr-xr-x 1 oraerp dbaerp 53060 Mar 6 09:06 adgrants.sql

-rwxr-xr-x 1 oraerp dbaerp 2752 Mar 6 09:44 adstats.sql

-rw-r--r-- 1 oraerp dbaerp 14083 Mar 6 08:29 preupgrd.sql

-rw-r--r-- 1 oraerp dbaerp 3221 Mar 6 12:10 utlrp.sql

-rw-r--r-- 1 oraerp dbaerp 495482 Mar 6 08:29 utluppkg.sql

-rwxr-xr-x 1 oraerp dbaerp 4631 Mar 6 09:08 wfaqupfix.sql

[oraerp@rac1 db_scripts]$

Now all the files had copied to folder “/shrf/db_scripts”

New Env. File for 12cR1

[oraerp@rac1 ~]$ cat 12cR1.env

export ORACLE_SID=PROD

export ORACLE_BASE=/u01

export ORACLE_HOME=/u01/db/tech_st/12.1.0

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

export ORA_NLS10=/u01/db/tech_st/12.1.0/nls/data/9idata

export TNS_ADMIN=$ORACLE_HOME/network/admin/PROD_rac1

Creation of 9i datafolder

[oraerp@rac1 ~]$ . 12cR1.env

[oraerp@rac1 ~]$ perl /u01/db/tech_st/12.1.0/nls/data/old/cr9idata.pl

Creating directory /u01/db/tech_st/12.1.0/nls/data/9idata ...

Copying files to /u01/db/tech_st/12.1.0/nls/data/9idata...

Copy finished.

Please reset environment variable ORA_NLS10 to /u01/db/tech_st/12.1.0/nls/data/9idata!

[oraerp@rac1 ~]$ . 12cR1.env

[oraerp@rac1 ~]$

Application Patches Status (enable maintenance mode and apply patches using adpatch)

[root@rac1 ~]# su - oraerp

[oraerp@rac1 ~]$ . APPSPROD_rac1.env

[oraerp@rac1 ~]$ sqlplus apps/apps

SQL> sho user

USER is "APPS"

SQL> select bug_number from ad_bugs where bug_number='12923944';

BUG_NUMBER

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

12923944

SQL> select bug_number from ad_bugs where bug_number='13473483';

BUG_NUMBER

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

13473483

SQL> select bug_number from ad_bugs where bug_number='16289505';

BUG_NUMBER

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

16289505

SQL> select bug_number from ad_bugs where bug_number='18843706';

BUG_NUMBER

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

18843706

SQL> select bug_number from ad_bugs where bug_number='19558309';

BUG_NUMBER

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

19558309

SQL>

Applying Patch for database (12cR1)

[oraerp@rac1 19382851]$ which opatch

/u01/db/tech_st/12.1.0/OPatch/opatch

[oraerp@rac1 19382851]$ opatch version

OPatch Version: 12.1.0.1.3

OPatch succeeded.

[oraerp@rac1 19382851]$

[oraerp@rac1 19382851]$ opatch apply

Oracle Interim Patch Installer version 12.1.0.1.3

Oracle Home : /u01/db/tech_st/12.1.0

Central Inventory : /u01/oraInventory/

from : /u01/db/tech_st/12.1.0/oraInst.loc

OPatch version : 12.1.0.1.3

OUI version : 12.1.0.2.0

Log file location : /u01/db/tech_st/12.1.0/cfgtoollogs/opatch/19382851_Mar_06_2017_13_14_38/apply2017-03-06_13-14-38PM_1.log

Applying interim patch '19382851' to OH '/u01/db/tech_st/12.1.0'

Verifying environment and performing prerequisite checks...

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/db/tech_st/12.1.0')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

Patching component oracle.rdbms, 12.1.0.2.0...

Verifying the update...

Patch 19382851 successfully applied

Log file location: /u01/db/tech_st/12.1.0/cfgtoollogs/opatch/19382851_Mar_06_2017_13_14_38/apply2017-03-06_13-14-38PM_1.log

OPatch succeeded.

[oraerp@rac1 19382851]$

Apply All the Database Patches in same procedure

Run utluppkg.sql from 11g Home

[oraerp@rac1 ~]$ . PROD_rac1.env

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

[oraerp@rac1 db_scripts]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 6 13:17:57 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> @utluppkg.sql

Package created.

Package body created.

SQL> @preupgrd.sql

SQL> @/u01/db/tech_st/11.1.0/cfgtoollogs/PROD/preupgrade/preupgrade_fixups.sql

Editing Pfile in 11g Home (Check the preupgrade.log for errors and warnings and Fix Acc.)

SQL> show parameter process

job_queue_processes integer 2

processes integer 200

SQL>

SQL> show parameter local

local_listener string PROD_LOCAL

SQL> shut immediate

SQL> exit

NOTE: comment local_listener, job_queue_processes and increase process to 300

[oraerp@rac1 dbs]$ vi /u01/db/tech_st/11.1.0/dbs/initPROD.ora

#local_listener = PROD_LOCAL

#job_queue_processes = 2

processes = 300

[oraerp@rac1 dbs]$ sqlplus / as sysdba

SQL> startup

SQL> show parameter process

processes integer 300

job_queue_processes integer 1000

SQL>

SQL> show parameter local

local_listener string

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

Clear Recyclebin (As suggested in preupgrade.log)

SQL> show user

USER is "SYS"

SQL>

SQL> EXECUTE dbms_preup.purge_recyclebin_fixup;

PL/SQL procedure successfully completed.

SQL> EXECUTE dbms_stats.gather_dictionary_stats;

SQL> @/u01/db/tech_st/12.1.0/rdbms/admin/preupgrd.sql

(and check the preupgrade.log it should be with 0 errors)

Upgradation (almost taken 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 ~]# su - oraerp

[oraerp@rac1 ~]$ . 12cR1.env

[oraerp@rac1 ~]$ dbua

[oraerp@rac1 ~]$ tail -f /u01/cfgtoollogs/dbua/PROD/upgrade1/Oracle_Server.log

Check the Upgrade Log for any further Errors

Check the invalid objects and compile (almost 3hrs on 8GB RAM)

[root@rac1 ~]# su - oraerp

[oraerp@rac1 ~]$ . 12cR1.env

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

[oraerp@rac1 db_scripts]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 6 14:21:37 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

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

COUNT(*)

----------

165176

SQL> @/u01/db/tech_st/12.1.0/rdbms/admin/utlrp.sql

------

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

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>

POST UPGRADE STEPS

Run adgrants.sql

[root@rac1 ~]# su – oraerp

[oraerp@rac1 ~]$ . 12cR1.env

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

[oraerp@rac1 db_scripts]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 2 15:18:26 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @adgrants.sql

Connected.

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

--- adgrants.sql started at 2017-03-02 15:18:34 ---

Enter value for 1: APPLSYS

----

Package body created.

End of Creating PL/SQL Package AD_DBMS_METADATA.

PL/SQL procedure successfully completed.

Commit complete.

Run adctxprv.sql script

[oraerp@rac1 db_scripts]$ sqlplus apps/apps @adctxprv.sql manager CTXSYS

SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 6 12:39:03 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Connecting to SYSTEM

Connected.

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oraerp@rac1 db_scripts]$

Execute ctxprv script

[oraerp@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 2 15:24:16 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics 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 12.1.0.2 Home

[root@rac1 ~]# su – oraerp

[oraerp@rac1 ~]$ . 12cR1.env

[oraerp@rac1 ~]$ lsnrctl start PROD

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-MAR-2017 17:32:41

Starting /u01/db/tech_st/12.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production

System parameter file is /u01/db/tech_st/12.1.0/network/admin/PROD_rac1/listener.ora

Log messages written to /u01/db/tech_st/12.1.0/admin/PROD_rac1/diag/tnslsnr/rac1/prod/alert/log.xml

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 12.1.0.2.0 - Production

Start Date 06-MAR-2017 17:32:42

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/12.1.0/network/admin/PROD_rac1/listener.ora

Listener Log File /u01/db/tech_st/12.1.0/admin/PROD_rac1/diag/tnslsnr/rac1/prod/alert/log.xml

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

Run wfaqupfix.sql scripts by Sourcing "Apps env."

[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 Thu Mar 2 15:28:42 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oraerp@rac1 db_scripts]$

Creation of Appsutil Directory

[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_03060825.log

output located at /u01/inst/apps/PROD_rac1/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

[oraerp@rac1 bin]$ cp /u01/inst/apps/PROD_rac1/admin/out/appsutil.zip /u01/db/tech_st/12.1.0

[oraerp@rac1 bin]$ cd /u01/db/tech_st/12.1.0/

[oraerp@rac1 12.1.0]$ unzip -o appsutil.zip

Buliding xml file for database using adbldxml.pl

[root@rac1 ~]# su – oraerp

[oraerp@rac1 ~]$ . 12cR1.env

[oraerp@rac1 ~]$ cd /u01/db/tech_st/12.1.0/appsutil/bin/

[oraerp@rac1 bin]$ perl adbldxml.pl

Starting context file generation for db tier..

Using JVM from /u01/db/tech_st/12.1.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/12.1.0/appsutil/log/adbldxml_03051907.log

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/12.1.0/appsutil/PROD_rac1.xml

[oraerp@rac1 bin]$

Run Auto config on dbTier using adconfig.pl

[root@rac1 ~]# su – oraerp

[oraerp@rac1 ~]$ . 12cR1.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/12.1.0/appsutil/PROD_rac1.xml

Enter the APPS user password: apps

The log file for this session is located at: /u01/db/tech_st/12.1.0/appsutil/log/PROD_rac1/03051908/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /u01/db/tech_st/12.1.0

Classpath : :/u01/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/u01/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/u01/db/tech_st/12.1.0/appsutil/java:/u01/db/tech_st/12.1.0/jlib/netcfg.jar

Using Context file : /u01/db/tech_st/12.1.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 db121

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

[oraerp@rac1 bin]$

Gather Statistic for “SYS” user

[root@rac1 ~]# su – oraerp

[oraerp@rac1 ~]$ . 12cR1.env

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

[oraerp@rac1 db_scripts]$ sqlplus / as sysdba

SQL> alter system enable restricted session;

System altered.

SQL>

SQL> @adstats.sql

Connected.

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

--- adstats.sql started at 2017-03-06 17:41:29 ---

Checking for the DB version and collecting statistics ...

PL/SQL procedure successfully completed.

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

--- adstats.sql ended at 2017-03-06 17:51:14 ---

Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oraerp@rac1 db_scripts]$

[oraerp@rac1 db_scripts]$ sqlplus / as sysdba

SQL> alter system disable restricted session;

System altered.

SQL> exit;

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

Start Application Services

[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 article helps those who trying to upgrade their database for EBS

Thanks for Reading my post.his article provides the in

Thanks for Reading.

Regards,

Mohammed Areefuddin.

Suggested Topics :

Linux	DATABASE	RMAN	RAC	EBS
5.7 Install	DATABASE Install		11201 Install	R1226 Install
Open Filer Instl	Active DataGaurd	Rman DataGuard	RAC DataGuard	EBS DataGuard
		RMAN DB CLONE	RAC DB Clone	R1226 Clone
	ASMCMD ASM Migrt	RMAN ASM Migrt		RMAN Clone
	11204 M-Upgrade			11202 EBS Upgrade
	12102 M-Upgrade			12102 EBS UPGRADE


Linux Basics	DATABASE Basics	RMAN Basics	RAC Basic	EBS Basics

Monday, March 6, 2017

ORACLE EBS DATABASE UPGRADE from 11.1.0.7 to 12.1.0.2 in Linux

No comments:

Post a Comment