Archive for the ‘11i/R12’ Category

Output Post Processor is Down with Actual Process is 0 And Target Process is 1   Leave a comment

If you see OPP is Down with Actual Process is 0 And Target Process is 1 then do the following

1. Shutdown concurrent server via command adcmctl.sh under $COMMON_TOP/admin/scripts/<context_name>

3. To ensure concurrent manager down; check there is no FNDLIBR process running.
ps -ef | grep applmgr | grep FNDLIBR

4. Run adadmin to relink FNDSVC executable.

a. Invoke adadmin from command prompt
b. Choose option 2 (2. Maintain Applications Files menu)
c. Choose option 1 (1. Relink Applications programs )
d. Then type “FND” When prompted; ( Enter list of products to link (‘all’ for all products) [all] : FND )
e. Ensure adrelink is exiting with status 0

5. Start Concurrent Managers using adcmctl.sh

Posted September 4, 2014 by balaoracledba.com in 11i/R12, OracleAppsR12

AutoConfig: Parallel Run Option on R12.1.1   1 comment

The “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Business Suite instance. Certain AutoConfig configurations of one node depend on the configurations of other nodes. When running in parallel mode, AutoConfig uses dbms_locks so that the configuration of one node does not interfere with the configuration of other nodes. During the instantiation (INST) phase, locking is done at the script level. During the execution (EXEC) phase, locking is done at the product_top level.

AutoConfig can be run in parallel mode on the application tier with the following command:

perl $AD_TOP/bin/adconfig.pl contextfile=<CtxFile> [product=<product_top>] –parallel

Where <CtxFile> is the absolute path of the applicaton tier context file, and <product_top> is the short name of the product to be configured.

AutoConfig can be run in parallel mode on the database tier with the following command:

perl $ORACLE_HOME/appsutil/bin/adconfig.pl contextfile=<CtxFile> -parallel

Where <CtxFile> is the absolute path of the database tier context file.

In parallel mode, AutoConfig must be invoked with the “–parallel” option on all nodes of a multi-node environment.

Posted September 4, 2014 by balaoracledba.com in 11i/R12, OracleAppsR12

R12.1.1 to R12.1.3 Upgrade.   Leave a comment

In this post i am going to list out the steps to upgrade R12.1.1 to R12.1.3

NOTE: Please make a note that i have not included pre and post patch steps while applying patches. Please go-through the patch README’s carefully while applying patches…….

Step1: 

Upgrade Database from 11.1.0.7 to 11gr2. I have upgraded from 11.1.0.7 to 11.2.0.2. 

Please follow below URL for Database upgrade for R12.1.1 EBS
https://balaoracledba.com/2013/11/13/upgrade-11-1-0-7-to-11-2-0-2-on-r12-1-1/
Step2:

Put the application under maintainence using adadmin 

Step3. 

Apply below patch
8919491.B                  Oracle Applications Technology 12.1.3 Product Family Release Update Pack

Step4

Apply Below Patch
17884289 R12.AD.B.Delta.4

Step5:

Apply Below Patch

9239090              R12                    ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK


Step6:

Apply Below Patch
9239095.                      R12Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack


Step7:

Apply Below Patch

9817770.BPOST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH

Step8: 

Apply Below patch

9966055.B1OFF:12.1.3:TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED

Step9:  

Run AutoConfig on the APPL_TOP.

Step10:

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

Run AutoConfig on the APPL_TOP.
perl <AD_TOP>/bin/admkappsutil.pl

Step11:

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

Step12:

Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>.

Step13:

unzip the appsutil.zip  as below

unzip -o appsutil.zip

Step14: 

Run AutoConfig on the <RDBMS ORACLE_HOME>.

Step15:

Re-run adpreclone.pl on the database tier and the application tier. Since updates included in Oracle E-Business 
Suite Release 12.1.3 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
This finishes the Application upgrade.
Start the Application Tier Services.
NOTE:After finishing the application upgrade. we need to apply product family patches.
(IN THIS UPGRADE I DIDNT APPLIED BELOW PRODUCT SPECIFIC PATCHES)
Patch Product Family Product Family Readme Documents
Oracle Applications Technology Release 12.1.3 (R12.ATG_PF.B.DELTA.3) Patch 8919491 Applications Technology (ATG_PF) Document 1066312.1
Oracle Customer Releationship Management Release 12.1.3 (R12.CC_PF.B.DELTA.3) Patch 9249345 Customer Relationship Management (CC_PF) Document 1081433.1
Oracle Financials Release 12.1.3 (R12.FIN_PF.B.DELTA.3) Patch 9147733 Financials (FIN_PF) Document 1081425.1
Oracle Human Resource Management System Release 12.1.3 (R12.HR_PF.B.DELTA.3) Patch 9114911 Human Resources (HR_PF) Document 1081427.1
Oracle E-Business Suite Diagnostics Release 12.1.3 (R12.IZU.B.DELTA.3) Patch 9239092 E-Business Suite Diagnostics (IZU) Document 1081428.1
Oracle Procurement Release 12.1.3  (R12.PRC_PF.B.DELTA.3) Patch 9249354 Procurement (PRC_PF) Document 1081431.1
Oracle Projects Release12.1.3 (R12.PJ_PF.B.DELTA.3) Patch 9147711 Projects (PJ_PF) Document 1081434.1
Oracle Supply Chain Management Release 12.1.3 (R12.SCM_PF.B.DELTA.3) Patch 9245674 Supply Chain Management (SCM_PF) Document 1081459.1
Oracle Value Chain Planning Release 12.1.3 (R12.SCP_PF.B.DELTA.3) Patch 9245525 Oracle Value Chain Planning (SCP_PF) Document 1081461.1

	

Posted May 7, 2014 by balaoracledba.com in 11i/R12, OracleAppsR12, Upgrade

AutoConfig: Parallel Run Option on R12.1.1   Leave a comment

The “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Business Suite instance. Certain AutoConfig configurations of one node depend on the configurations of other nodes. When running in parallel mode, AutoConfig uses dbms_locks so that the configuration of one node does not interfere with the configuration of other nodes. During the instantiation (INST) phase, locking is done at the script level. During the execution (EXEC) phase, locking is done at the product_top level.

AutoConfig can be run in parallel mode on the application tier with the following command:

perl $AD_TOP/bin/adconfig.pl contextfile=<CtxFile> [product=<product_top>] –parallel

Where <CtxFile> is the absolute path of the applicaton tier context file, and <product_top> is the short name of the product to be configured.

AutoConfig can be run in parallel mode on the database tier with the following command:

perl $ORACLE_HOME/appsutil/bin/adconfig.pl contextfile=<CtxFile> -parallel

Where <CtxFile> is the absolute path of the database tier context file.

In parallel mode, AutoConfig must be invoked with the “–parallel” option on all nodes of a multi-node environment.

Posted November 27, 2013 by balaoracledba.com in 11i/R12, OracleAppsR12

Upgrade R12- 10.1.3.4 Oracle IAS(WebOH) to 10.1.3.5   3 comments

In this post I will list out the steps required to Upgrade R12 10.1.3.4 Oracle Home to 10.1.3.5.

Step 1

Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)

IMPORTANT NOTE: BEFORE STARTING ANYTHING FIRSTLY UPDATE OPATCH. DOWNLOAD p6880880_101000_LINUX.zip AND UPDATE OPATCH.

Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084 from My Oracle Support

Step 2

Download Environment Preparation Patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)

Download patch 8920270 from My Oracle Support . Also download latest opatch 6880880  for 10.1.3 Step 3 Take a cold backup of 10.1.3 Oracle Home and Inventory cp -pr 10.1.3 10.1.3_bkp Step 4 Shut down the application Tier Step 5 Set your environment (Remember dont run the regular application env file). Instead go to $INST_TOP/ora/10.1.3 and u will find and env with name _DomainName.env set the env using this env file. 1 Before Upgrade the version is as below use$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version 2 Step 6: unzip p8626084_101350_LINUX.zip cd Disk1 execute ./runInstaller.sh 3 Here if you are trying to upgrade on Linux64bit Machine you will face an error, i suggest run below command On Linux 64bit: Use the following command to specify 32bit shell emulation, before running the installer as detailed below: $ linux32 bash then again execute the ./runInstaller.sh 4 Choose Oracle Home 10.1.3( Make sure on process is running from this OH.) all the application services should be down. 5 6type password as oafm 8 9 10Ignore if you see any error messages 12 Ignore the error Messages. 13 try opmnctl startall from command prompt to see whether you are able to start it successfully or not. again stop using opmnctl stopall as we need to apply other patches. Step 7: Unzip patch 8920270 (required patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into an alternative temporary directory. 15

Go through the Readme.txt
1) Make a backup of the file $ORACLE_HOME/config/run_opatch_generic.sh
 cd $ORACLE_HOME/config
 cp run_opatch_generic.sh run_opatch_generic.sh.pre8920270
2) Edit the $ORACLE_HOME/config/run_opatch_generic.sh and add the line
"-ocmrf <$ORACLE_HOME>/config/ias.properties" immediately after the -silent
switch. i.e.
#!/bin/sh
#
#opatch apply -silent -oh  -invPtrLoc <OH/oraInst.loc> #
# This file is really for SOLARIS only currently other platforms are
# using separate files.
/OPatch/opatch apply -silent -ocmrf /config/ias.properties -oh  -invPtrLoc /oraInst.loc /opatches/4601861
if [ "$?" != "0" ]; then
echo "OPatch did not complete successfully..."
exit 1
fi
3) If this is a GUI install then retry the configuration assistant "Run One-off Generic OPatches". For a failure in the silent install
a) Set the LD_LIBRARY_PATH
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib
b) Set the PERL5LIB
export PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1:$PERL5LIB
 c) Run the configToolCommands
cd $ORACLE_HOME/cfgtoollogs
./configToolCommands > /tmp/configtoolcommands.out
d) Review /tmp/configtoolcommands.out.

 Step 8 Run AutoConfig Step 9 Apply post upgrade patches 16 Step 10 Post-upgrade Tasks Step a: Regenerate appsborg.zip and appsborg2.zip files Run adadmin, and choose Generate product JAR files (with the no force option) to generate the appsborg.zip and appsborg2.zip files. Step b :Verify the OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5) Installation 17 This finishes the upgrade of 10.1.3 to 10.1.3.5.

Posted November 25, 2013 by balaoracledba.com in 11i/R12, OracleAppsR12

Managers down – Status show “Target node/queue unavailable   5 comments

Concurrent Managers Status shows  ”Target node/queue unavailable”  in Concurrent–>Manager–>Administer Screen form.

target

 

Solution:

Ensure Database is Running and Middle Tier Services are down.

Connect SQLPLUS as APPS user and run the following :

EXEC FND_CONC_CLONE.SETUP_CLEAN;

COMMIT;

EXIT;

  • Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers and webtier to repopulate the required systemtables
  • Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
  • Note.134007.1 – ‘CMCLEAN.SQL – Non Destructive Script to Clean Concurrent  Manager Tables‘
  • Start the middle tier services including your concurrent manager.
  • Retest the issue.

Managers down – Status “System Hold, Fix Manager”   Leave a comment

Concurrent Managers Status shows  “System Hold, Fix Manager”  in Concurrent–>Manager–>Administer Screen form.

sys

 

Solution:

• Ensure Concurrent :GSM Enabled profile is set to ‘Y’

• Run $FND_TOP/patch/115/sql/afdcm037.sql

• Go to $FND_TOP/bin

adrelink.sh force=y “fnd FNDLIBR”

adrelink.sh force=y “fnd FNDSM”

adrelink.sh force=y “fnd FNDFS”

adrelink.sh force=y “fnd FNDCRM”

• Run cmclean.sql

• Start Application Service (adstrtal.sh)