Upgrade Oracle Applications from R12.1.1 to R12.1.2

Hi

     Follow the doc for upgrading application from  R12.1.1 to R12.1.2

Author –

A.Kishore

http://appsdba.info

Upgrade Oracle Applications from R12.1.1 to R12.1.2

Reference Note -

Oracle E-Business Suite Readme, Release 12.1.2 (Doc ID 949406.1)

1> Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade (Doc ID 761570.1)

The minimum required database version should be 11.1.0.7, R12.1.1 comes with 11.1.0.7

Test - Passed

2>

ID 454811.1)

Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12 (Doc

The minimum required version of

[applmgr12@linux1 ~]$ grep "ias_version" $CONTEXT_FILE

<ias_version oa_var="s_ias_version">10.1.3.4.0</ias_version>

OracleAS 10g should be 10.1.3.4, R12.1.1 comes with 10.1.3.4

Test - Passed

3>

Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

The minimum required version of

with 10.1.3.4

OracleAS 10g Forms and Reports should be 10.1.2.3.0, R12.1.1 comes

[applmgr12@linux1 ~]$ grep "forms_version" $CONTEXT_FILE

<forms_version oa_var="s_forms_version">10.1.2.3.0</forms_version>

Test - Passed

Author –

A.Kishore

http://appsdba.info

4> Below patches/steps are required to upgrade from R12.1.1 to R12.1.2

- Use AutoPatch to apply R12.AD.B.DELTA.2 Patch 8502056

-

Use AutoPatch to apply Release 12.1.2 Patch 7303033 – Patch size is 3.2 GB ☺

-

Use AutoPatch to apply the latest consolidated online help Patch 7303032

-

Post-Update Steps

5> Use AutoPatch to apply R12.AD.B.DELTA.2 Patch 8502056

The readme says to run admsi.pl (Patch application assistant)

Author –

A.Kishore

http://appsdba.info

Patch Location - /d01/oracle/R1212/8502056

Author –

A.Kishore

http://appsdba.info

Author –

A.Kishore

http://appsdba.info

-- stop the services

su - applmgr12

cd $ADMIN_SCRIPTS_HOME

sh adstpall.sh apps/apps

-- Enable Maintenance Mode

adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log

menu_option=ENABLE_MAINT_MODE workers=4

export PATCH_TOP=/d01/oracle/R1212

Create $ORACLE_HOME/appsutil/admin on the database server.

su – oracle12

cd $ORACLE_HOME/appsutil

Author –

A.Kishore

http://appsdba.info

mkdir admin

Copy adgrants.sql (UNIX) from this patch directory to

cd $ORACLE_HOME/appsutil/admin

cp $APPL_TOP/admin/adgrants.sql .

sqlplus "/as sysdba" @adgrants.sql APPS

-- Apply patch 8502056 in non interactive mode

-- Takes 30 minutes

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u8502056.log

patchtop=$PATCH_TOP/8502056 driver=u8502056.drv workers=4

5>

Use AutoPatch to apply Release 12.1.2 Patch 7303033 – Took 18 hours ☺

Run admsi.pls as per the readme file

Author –

A.Kishore

http://appsdba.info

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u7303033.log

patchtop=$PATCH_TOP/7303033 driver=u7303033.drv workers=4

Issue 1>

I told Yes and continued with patch

grep 'Error' adrelink.lsv

make: *** [/d02/oracle/PROD/apps/apps_st/appl/msc/12.0.0/bin/MSCCPP] Error 1

Solution -

Relink Error On All MSC Executables On Oracle Enterprise Linux (OEL) 5.x/Red Hat Linux (RHEL) 5.x (Doc ID

758831.1)

The below link from forums.oracle.com has given me the clue.

http://forums.oracle.com/forums/thread.jspa?threadID=1026800&tstart=0

You should follow the instructions in Metalink note 758831.1.

I had a similar problem while patching from 12.1.1 to 12.1.2, all of the MSC... files would not relink. I had to reinstall the binutils library and

all went well.

It might work for you too (I'm running OEL 5 64bit)

Read the whole note but since I already downloaded and installed those packages as part of the initial install I just needed to reinstall this

one

rpm -U binutils-2.17.50.0.6-6.0.1.el5.x86_64.rpm

Author –

A.Kishore

http://appsdba.info

Issue 2>

/d02/oracle/PROD/apps/apps_st/appl/cs/12.0.0/patch/115/sql/csusrs.pls

CREATE OR REPLACE PACKAGE CS_ServiceRequest_UTIL AUTHID CURRENT_USER

Unable to process file in PACKAGE mode.

AD Worker error:

ORA-00060: deadlock detected while waiting for resource

Solution – I executed the csusrs.pls manually and there was no issue

sqlplus apps/apps @/d02/oracle/PROD/apps/apps_st/appl/cs/12.0.0/patch/115/sql/csusrs.pls

I have restarted the failed worker using adctrl

Issue 3> Few pll/fmx have failed to compile

Author –

A.Kishore

http://appsdba.info

I told Yes and continued with the patch and then manually generated the plls/fmx files using adadmin,

the issue got resolved.

3>

Use AutoPatch to apply the latest consolidated online help Patch 7303032

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u7303032.log

patchtop=$PATCH_TOP/7303032 driver=u7303032.drv workers=4

Post-Update Steps

Update database tier nodes with the Release 12.1.2 code level.

After you have upgraded to Release 12.1.2, perform the following post-update steps to update all

database tier nodes with the code level, provided by Release 12.1.2:

Application tier:

As the APPLMGR user, run the environment (UNIX) or the command (WINDOWS) file for the current

APPL_TOP.

UNIX

. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env

Run the admkappsutil.pl utility to create the file appsutil.zip in the <INST_TOP>/admin/out directory.

perl <AD_TOP>/bin/admkappsutil.pl

As the ORACLE user, run the environment (UNIX) or the command (WINDOWS) file for the current

ORACLE_HOME.

UNIX

cd <RDBMS ORACLE_HOME>

. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env

Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>.

Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>.

cd <ORACLE_HOME>

mv appsutil appsutil_old

Author –

A.Kishore

http://appsdba.info

unzip -o appsutil.zip

Run AutoConfig on the <RDBMS ORACLE_HOME>.

perl adbldxml.pl appsuser=apps appspass=apps

Below is the error

JRE_TOP or java executable not found at its desired location /d02/oracle/PROD/db

/tech_st/11.1.0/appsutil/jre, /d02/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java

Solution :

Copy the jre from appsutil_old

cd $ORACLE_HOME/appsutil_old

cp -R jre /d02/oracle/PROD/db/tech_st/11.1.0/appsutil

perl adbldxml.pl appsuser=apps appspass=apps

The context file has been created at:

/d02/oracle/PROD/db/tech_st/11.1.0/appsutil/ PROD_linux1.xml

n

cd /d02/oracle/PROD/db/tech_st/11.1.0/appsutil/bin

sh adconfig.sh

Enter the full path to the Context file: /d02/oracle/PROD/db/tech_st/11.1.0/appsutil/ PROD_linux1.xml

Enter the APPS user password:

Run autoconfig

Database tier and application tier:

Re-run adpreclone.pl on the database tier and the application tier. Since updates included in RUP6 were

applied to the system, adpreclone must be run again to apply the updates to the clone directory

structures that were used during cloning.

perl adpreclone.pl dbTier

perl adpreclone.pl appsTier

Author –

A.Kishore

http://appsdba.info

n

adadmin menu_option=DISABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin

/$TWO_TASK/adalldefaults.txt logfile=adadmin_DISABLE_MAINT_MODE.log

Disable the maintenance mode

n

cd $ADMIN_SCRIPTS_HOME

sh adstrtal.sh apps/apps

Final check - Check whether the update is done or not from backend

Author –

Start the servicesA.Kishore

http://appsdba.info

Check whether application is running from frontend