Archive for the ‘R12.2’ Category

R12.2 CUSTOM APPLICATION/TOP   4 comments

STEP1:

Download Patch 3636980 “Support Diagnostics (IZU) patch for AD Splice” from My Oracle Support.

STEP2:

Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory.

1

STEP3:

Rename izuterr.txt to xxerpterr.txt

and         izuprod.txt to xxerpprod.txt

1a

Step4:

Open newprods.txt in a text editor.

Change from below

3

to

4

Step5:

open xxerpprod.txt and change the references from izu to xxerp

Please use below sql for finding whether custom application id 50000 is availble or not

select decode(count ,0, 'Selected number is available', 'Selected number is already in use') Status, &&enter_custom_applID selected_number
from
(
select count(*) as count from
(
select 'x' from fnd_oracle_userid
where oracle_id= &&enter_custom_applID
union
select 'x' from fnd_application
where application_id= &&enter_custom_applID
)
);
7

5

open xxerpterr.txt and change the references from izu to xxerp

6

Step6:

Copy the following text files to the $APPL_TOP/admin directory:
xxerpprod.txt
xxerpterr.txt
newprods.txt

Change the current working directory to $APPL_TOP/admin

cd $APPL_TOP/admin

Step7:Run adadmin

[appldev@dev-devapp1 admin]$ adsplice

Copyright (c) 2002, 2012 Oracle Corporation
 Redwood Shores, California, USA

AD Splicer

Version 12.2.0

NOTE: You may not use this utility for custom development
 unless you have written permission from Oracle Corporation.

Your default directory is '/dev/oracle/DEV/fs1/EBSapps/appl'.
Is this the correct APPL_TOP [Yes] ?

AD Splicer records your AD Splicer session in a text file
you specify. Enter your AD Splicer log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adsplice.log] :

************* Start of AD Splicer session *************
AD Splicer version: 12.2.0
AD Splicer started at: Mon Jul 11 2016 00:42:31

APPL_TOP is set to /dev/oracle/DEV/fs1/EBSapps/appl

Change DB = YES.


Please enter the name of the Oracle E-Business Suite System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [DEV] : DEV *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have or want to install files used for installing or upgrading
the database in this APPL_TOP [YES] ? YES *


Do you currently have or want to install Java and HTML files for HTML-based
functionality in this APPL_TOP [YES] ? YES *


Do you currently have or want to install Oracle E-Business Suite forms files
in this APPL_TOP [YES] ? YES *


Do you currently have or want to install concurrent program files
in this APPL_TOP [YES] ? YES *


Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle E-Business Suite
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [AT_relebsodevapp1] : AT_relebsodevapp1 *

You are about to install or upgrade Oracle E-Business Suite product tables
in your ORACLE database 'DEV'
using ORACLE executables in '/dev/oracle/DEV/fs1/EBSapps/10.1.2'.

Is this the correct database [Yes] ?

AD Splicer needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:


The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

AD Splicer is verifying your username/password.

The status of various features in this run of AD Splicer is:

<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:

Code Language Status
---- --------------------------------------- ---------
US American English Base

Your base language will be AMERICAN.

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...

Saving product information.
*** Edition Enabled User ***


Please enter the directory where your AD Splicer control file is located.

The default directory is [/dev/oracle/DEV/fs1/EBSapps/appl/admin] :

Please enter the name of your AD Splicer control file [newprods.txt] :


Processing file /dev/oracle/DEV/fs1/EBSapps/appl/admin/newprods.txt...
 Loading information for product 'xxerp'...

Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!

Successfully read file /dev/oracle/DEV/fs1/EBSapps/appl/admin/newprods.txt.


Verifying localizations...

Validating inter-product dependency information...

Re-organizing product information lists...


Adding new languages into FND_LANGUAGES...


Creating ORACLE usernames for products...

AD Splicer is creating or updating the ORACLE username XXERP
with password ***** for XXERP CUSTOM Application tables.
 New product XXERP spliced. Use FNDCPASS to change the password.

Granting privileges for tablespaces...

Granting required system privileges and creating APPS*DDL packages...

sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls ***** XXERP *****'

Done running adaddls.pls for XXERP

sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddls.pls ***** XXERP *****'

Done running adaaddls.pls for XXERP

sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddlb.pls ***** XXERP *****'

Done running adaddlb.pls for XXERP

sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddlb.pls ***** XXERP *****'

Done running adaaddlb.pls for XXERP

Registering ORACLE usernames/passwords.

**
**Inserting application information for new products...
**


**** Running Seed Table Prepare for FND_APPLICATION ****

**** Running Seed Table Prepare for FND_APPLICATION_TL ****
INSERT INTO FND_OAM_CONTEXT_CUSTOM (OA_VAR,CTX_TYPE,OA_TYPE,NAME,DEFAULT_VALUE,TITLE,DESCRIPTION) VALUES ('c_xxerp','A','PROD_TOP','c_xxerp','/dev/oracle/DEV/fs1/EBSapps/appl/xxerp/12.0.0','custom prod top xxerp','this is spliced custom prod top') Temporarily resetting CLASSPATH to:
 "/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/dev/oracle/DEV/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/dev/oracle/DEV/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/dev/oracle/DEV/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/dev/oracle/DEV/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/dev/oracle/DEV/fs1/EBSapps/comn/java/classes:/dev/oracle/DEV/fs1/EBSapps/10.1.2/forms/java:/dev/oracle/DEV/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/dev/oracle/DEV/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/dev/oracle/DEV/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

Calling /dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...

Running fnd_application_pkg.add_language ...
**
**Updating product information for new products...
**


Populating INSTALL_GROUP_NUM column to FND_ORACLE_USERID table.

**
**Updating product dependency information...
**


Recording modules in the database...done.

**
**Updating Data Groups...
**


Reading existing data groups from database.

Registering any new data groups.


Registering any new data group units.


Updating Data Group "Standard" to point to
APPS #1 Account (ORACLE ID = 900)


Updating Patch Advisor tables to include new product information ..

sqlplus -s APPS/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/sql/adpaseed.sql *****'

Done.

Saving module actions...done.

Saving product actions...done.

Making product top directory for product "xxerp"...
Directory will be /dev/oracle/DEV/fs1/EBSapps/appl/xxerp/12.0.0

Making directory "log" for product "xxerp"...
 Making directory "out" for product "xxerp"...
 Making directory "mesg" for product "xxerp"...
 Making directory "sql" for product "xxerp"...
 Creating stub file "sql/XXERPNLINS.sql" for product "xxerp"...
 Making directory "admin/sql" for product "xxerp"...
 Creating stub file "admin/sql/XXERPNLADD.sql" for product "xxerp"...
 Making directory "admin/driver" for product "xxerp"...

Recording ADSPLICE action for product: xxerp


Do you wish to regenerate your environment file [Yes] ? Yes

Checking if AutoConfig is enabled....

Running AutoConfig on : All products ...

Check in the backend whether custom schema is created or not.

Also check whether custom folder got created in $APPL_TOP with name xxerp.

Reset the environment using by running EBSapps.env /dev/oracle/DEV/EBSapps.env run

Thanks.

 

 

Advertisements

Posted July 11, 2016 by balaoracledba.com in R12.2

ChangeWebport on EBS R12.2   Leave a comment

Hi,

In this post i will list out the steps to change the webport to 8000.

Step-1:Start only Weblogic admin

using  adadminsrvctl.sh  start on run file system

Login to Enterprise Manager(em) Console using below url

http://<hostname > . <domainname>:7001/em

Step-2:Navigate as shown below:

1

Click on Advanced Configuration as shown above

Step-3:select httpd.conf from the down as show in below figure:

Change OHS Listen PORT(Here i changed to 8000)

2

Step-4:

Run Context File Synchronization $AD_TOP/bin/adSyncContext.pl :

perl $AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE

– Manually update the $CONTEXT_FILE if old port values are still present

-but in my case the values got updated to 8000

Step-5:

Run autoconfig.

Step-6: Stop adminserver using adadminsrvctl stop

Step7: Start all the services using adstral.sh

 

Posted July 5, 2016 by balaoracledba.com in R12.2

STARTCD 12.2.0.51 has been released for R12.2   5 comments

STARTCD 12.2.0.51  has been released For R12.2 Stage

Size 725MB.cd51

Posted February 19, 2016 by balaoracledba.com in R12.2

R12.2.5 single node cloning   1 comment

Hello all,

After long time I am updating my blog with R12.2.5 cloning.

There is a slight difference between R12.2.4 and R12.2.5.

With the introduction of dualfs in R12.2.5 we can even configure patch filesystem with single run of adcfgclone on the target node.

r1225_clone

Here in the above picture, if run filesystem is on fs2 on the source then on the target also we should configure fs2 as run filesystem and automatically fs1 will become patch filesystem

we copy only EBSApps folder from source fs2 filesystem which is RUN filesystem, to target fs2 filesystem

NOTE: DO NOT COPY EBSApps folder from source fs2 run filesystem to target fs1 folder, this resulted in error.

IF FS2 FILESYSTEM IS RUN THEN WE SHOULD COPY SOURCE EBSApps FOLDER FROM FS2 of source TO TARGET FS2. THIS SHOULD BE DONE AFTER RUNNING adpreclone.pl ON SOURCE RUN FILESYSTEM.

[applcrp4@crp4app1 fs2]$ cd /d01/oracle/CRP1/fs1
[applcrp4@crp4app1 fs1]$ ls -l
drwxr-xr-x 5 applcrp4 dba 4096 Nov 6 04:49 EBSapps
[applcrp4@crp4app1 fs1]$

[applcrp4@crp4app1 bin]$ perl adcfgclone.pl appsTier dualfs

Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone...

Log file located at /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContext_1116040449.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [crp4app1] :

Target System Database SID : CRP1

Target System Database Server Node [crp4app1] : crp4db1

Target System Database Domain Name [ora.ad] :

Target System Base Directory : /d01/oracle/CRP1

Target System Base Directory set to /d01/oracle/CRP1

Target System Current File System Base set to /d01/oracle/CRP1/fs2

Target System Other File System Base set to /d01/oracle/CRP1/fs1

Target System Fusion Middleware Home set to /d01/oracle/CRP1/fs2/FMW_Home
Target System Other File System Fusion Middleware Home set to /d01/oracle/CRP1/fs1/FMW_Home

Target System Web Oracle Home set to /d01/oracle/CRP1/fs2/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /d01/oracle/CRP1/fs1/FMW_Home/webtier

Target System Appl TOP set to /d01/oracle/CRP1/fs2/EBSapps/appl
Target System Other File System Appl TOP set to /d01/oracle/CRP1/fs1/EBSapps/appl

Target System COMMON TOP set to /d01/oracle/CRP1/fs2/EBSapps/comn
Target System Other File System COMMON TOP set to /d01/oracle/CRP1/fs1/EBSapps/comn

Target System Instance Home Directory [/d01/oracle/CRP1] :

Target System Current File System Instance Top set to /d01/oracle/CRP1/fs2/inst/apps/d01_crp4app1

Do you want to preserve the Display [app-upg-app1:0.0] (y/n) : n

Target System Display [crp4app1:0.0] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] : enabled

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 0

Checking the port pool 0
done: Port Pool 0 is free
Report file located at /d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /tmp
3. /d01/oracle/d01/11204/appsutil/outbound/CRP1_crp4db1
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
The new APPL_TOP context file has been created :
/d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/appl/admin/CRP1_crp4app1.xml
Check Clone Context logfile /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContext_1116040449.log for details.

Creating Patch file system context file.....

Log file located at /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContextPatch_1116040654.log

Target System Other File System Instance Top set to /d01/oracle/CRP1/fs1/inst/apps/CRP1_crp4app1

Target System Port Pool [0-99] : 1

Checking the port pool 1
done: Port Pool 1 is free
Report file located at /d01/oracle/CRP1/fs1/inst/apps/CRP1_crp4app1/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/d01/oracle/CRP1/fs1/inst/apps/CRP1_crp4app1/appl/admin/CRP1_crp4app1.xml
Check Clone Context logfile /d01/oracle/CRP1/fs2/EBSapps/comn/clone/bin/CloneContextPatch_1116040654.log for details.

FMW Pre-requisite check log file location : /d01/oracle/CRP1/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...

Configuring: Run file system....
LogFile located at /d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/admin/log/clone/run/RCloneApplyAppstier_11160407.log

Configuring: Patch file system....
LogFile located at /d01/oracle/CRP1/fs2/inst/apps/CRP1_crp4app1/admin/log/clone/patch/RCloneApplyAppstier_11160433.log

Do you want to startup the Application Services for CRP1? (y/n) [n] : n

Services not started

Posted November 16, 2015 by balaoracledba.com in Cloning, R12.2

R12.2 Autoconfig failing with ORA-06512: at “APPS.ADX_PRF_PKG”, line 83   2 comments

Hi,

In the proces of upgrading from R12.1.3 to R12.2.4. I encountered an issue with autoconfig on database side

Below is the excert from error log

afdbprf.sh started at Mon May 4 23:09:23 PDT 2015

The environment settings are as follows …

ORACLE_HOME : /dev/oracle/product/11.2.0
ORACLE_SID : dev
PATH : /dev/oracle/product/11.2.0/perl/bin:/dev/oracle/product/11.2.0/perl/bin:/dev/oracle/product/11.2.0/bin:/usr/bin:/usr/sbin:/dev/oracle/product/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracrp1/bin:.
Library Path : /dev/oracle/product/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/dev/oracle/product/11.2.0/lib:/usr/dt/lib:/dev/oracle/product/11.2.0/ctx/lib

Executable : /dev/oracle/product/11.2.0/bin/sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 4 23:09:23 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
begin
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at “APPS.ADX_PRF_PKG”, line 83
ORA-01403: no data found
ORA-06512: at line 7

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
****************************************************

Solution:

1. Run adadmin–>Recreate Grants and Synonyms
2. Compile Apps Schema

This has resolved the issue with autoconfig on the database side.

Thanks

Posted May 5, 2015 by balaoracledba.com in OracleAppsR12, R12.2

2014 Review of My Blog   Leave a comment

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 240,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 10 days for that many people to see it.

Click here to see the complete report.

Posted January 2, 2015 by balaoracledba.com in R12.2

Step By Step Upgrade from R12.2.0 to R12.2.4   24 comments

Details:

OS: Oracle Enterprise Linux-x64bit 

CPU’s-4

Memory:16GB

No. Of Nodes:1(Both DBTier and AppsTier on Single Node)

References:

1.Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1)

2.Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

3.Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

4. Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

Step1: Apply Required Database Patches:

Review Metalink Note 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes, and apply all required patches for your database version.

As I installed my R12.2 with startCD Version 12.2.0.47, I have all the updates (patches) belongs to 12.2.0.47 for my Database 11.2.0.3 and other Application Technology Software. So I need to apply patches belongs to 12.2.0.48 and also 8-26-2014 12-06-19 PM

 

Footnote 6 – This database patch is no longer available. For a more recent version of this fix that also includes additional fixes, refer to Patch 19078951 and its associated footnote.

Footnote 8 – This database patch is required to support the latest AD and TXK release update packs, as described in My Oracle Support Knowledge Document 1617461.1Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2. If Patch 17502060 was installed, you should roll it back before installing Patch 17693770 from My Oracle Support.

Footnote 11 – If Patch 18259911 or Patch 17461865 was installed, you should roll it back before installing Patch 19078951 from My Oracle Support.

Before applying 17693770 patch on 11.2.0.3 DB Home, rollback 17502060, and apply 17693770.

Before applying 18116376 rollback 17047617

For patch 18259911 FOOTNOTE6  says that it is no longer available and we need to refer Patch 1907895. (We will apply this 19078951 after applying all patches)

Before Applying 17875948 rollback 16587934

Before applying 19078951 rollback 14751895, 1825991117461865

DONT FORGET TO PERFORM POST INSTALL STEPS FROM PATCH README’s

Click on this to get abstract for applying DB Patches on 11.2.0.3 Database Patches Applied on 11203

Step2: Let’s Apply Patches for 10.1.2 Oracle_Home(Forms Home)

21012

Step 3:Web Tier and Utilities (OHS) 11.1.1.6 Patches and Bug Numbers

—Only One Patch needs to be applied.

Click on the this link to get Abstract for applying patches on Webtier Utilities1116Patch_Abstract

Step4:Patches  for Oracle Fusion Middleware 11.1.1.6.0

FUnsion

 

Click on the this link to get Abstract for applying patches on Fusion Middleware OH FusionOH1116

Step4: Oracle Weblogic Server 10.3.6.0 Patch

Download and Unzip both the patches in the /d01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir

weblogic

weblogicdirectory

Open VNC and run bsu.sh 

 

bsu1

bsu2

 

In the Below Sceenshot click on Green Arrows pointing upwards doing so will apply patches on weblogic. Do it one after the other

bsu5

bsu3

bsu4

Step5: Apply below patch

If you haven’t already applied Consolidated Seed Table Upgrade Patch 17204589:12.2.0, then you must first apply Patch 17204589:12.2.0 on the run file system.

Note: If you have upgraded to Release 12.2.0 using Consolidated Upgrade Patch 18007406:12.2.0 (CUP5) or Consolidated Upgrade Patch 17197281:12.2.0 (CUP4), then you can skip this step.
Stop all Application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
Start up only the Weblogic AdminServer service on the run file system.
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Apply the consolidated seed table upgrade Patch 17204589:12.2.0 on the run file system using adop hotpatch mode.
Copy the patch in /d01/oracle/PROD/fs_ne/EBSapps/patch

$ adop phase=apply patches=17204589 hotpatch=yes

firstpatch

 

Step 6:Apply the Latest AD and TXK Delta Release Update Packs

Download and unzip the following patches:

1.Run adgrants.sql first and apply the patch

adgrats

cp adgrants.sql from patch/admin directory to db tier and execute as below, this may take some time depends upon hardware.

adpatch1

adpatch2

 

Before upgrade Version of EBS:

before

Step 7:Apply Patch 19259764:R12.FND.C (conditional).

Note: This step is not applicable for new installation and upgrade customers who are applying the Oracle E-Business Suite Release 12.2.4 Release Update Pack.

$ adop phase=apply patches=19259764 hotpatch=yes

Step 8: Run fs_clone as below

  1. Source the run edition environment file.

    $ . <EBS_ROOT>/EBSapps.env run

  2. Synchronize the file systems (conditional)

    $ adop phase=fs_clone

Step 9:Path A from the metalink note 1617458.1- Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.4 Release Update Pack

Source the run edition applications environment.

$ . <INSTALL_BASE>/EBSapps.env run

Stop Weblogic AdminServer and Node Manager services.

Applying the patch in downtime mode requires all application tier services to be down. Therefore, Weblogic AdminServer and Node Manager that were started previously when applying the latest Release Update Packs for AD and TXK for Release 12.2 need to be shut down.

Stop Weblogic AdminServer service on the run file system.

$sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

Stop Node Manager service on the run file system.

$sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

Apply Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 on the run edition application environment, using downtime mode.

$adop phase=apply apply_mode=downtime patches=17919161

Start all Application tier services on the run file system.

$sh $ADMIN_SCRIPTS_HOME/adstrtal.sh

Perform adop cleanup action.

$adop phase=cleanup

Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the other file system, to ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.

$ adop phase=fs_clone

Post-Update Steps

Note: If you are upgrading from Release 11i, 12.0.x or 12.1.x to Release 12.2.4, then you must continue with 12.2.0 post upgrade steps mentioned in the Upgrade guides before performing the below steps.
Apply Oracle E-Business Suite Release 12.2.4 Online Help

Apply Oracle E-Business Suite Release 12.2.4 Online Help Patch 17919162 merged with Patch 19290141 using adop hotpatch mode on the run file system.

$ adop phase=apply patches=17919162,19290141 hotpatch=yes merge=yes

This Finishes the R12.2.4 Upgrade from R12.2.0.

r124

New Feature

 

Let me know if anyone faces any issues in upgrading

 

Posted August 26, 2014 by balaoracledba.com in R12.2