Thursday 26 August 2010

Oracle E-Business Suite Release 12.1.3 RUP

I have successfully done upgradation of 12.1.3 RUP on my instance without having any problems. The details of my instance details are
Instance version: 12.1.2
Database version: 11.2.0

I have followed the Note 1080973.1 for upgrading from 12.1.2 to 12.1.3 release update pack.
The steps followed to upgrade for Apply Oracle E-Business Suite Release 12.1.3 are,
First of all disabling fast validation for PL/SQL recompilations using 
_disable_fast_validate=TRUE
using init parameter of database and restarted
Enable maintenance mode
adadmin menu_option=ENABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin_DISABLE_MAINT_MODE.log

Applying required patches from 12.1.3.RUP

Use AutoPatch to apply R12.AD.B.DELTA.3 Patch 9239089
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239089.log patchtop=$PATCH_TOP/9239089 driver=u9239089.drv workers=8

Use AutoPatch to apply Oracle E-Business Suite Release 12.1.3 Patch 9239090 and follow the instructions in the patch readme file.
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239090.log patchtop=$PATCH_TOP/9239090 driver=u9239090.drv workers=8

Use AutoPatch to apply the latest consolidated online help Patch 9239095 and follow the instructions in the patch readme file.
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239095.log patchtop=$PATCH_TOP/9239095 driver=u9239095.drv workers=8
Post-Update Steps
Apply post-install Oracle E-Business Suite Applications Technology patches. (Required)
Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH].)
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9817770.log patchtop=$PATCH_TOP/9817770 driver=u9817770.drv workers=8

Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9966055.log patchtop=$PATCH_TOP/9966055 driver=u9966055.drv workers=8

Update database tier nodes with the Oracle E-Business Suite Release 12.1.3 code level.
After upgraded to Oracle E-Business Suite Release 12.1.3, perform the following post-update steps to update all database tier nodes with the code level, provided by Oracle E-Business Suite Release 12.1.3:
Application tier:
As the APPLMGR user, run the environment file for the current APPL_TOP.
. .$APPL_TOP/APPS$CONTEXT_NAME.env
Run AutoConfig on the APPL_TOP.

Run the admkappsutil.pl utility to create the file appsutil.zip in the $INST_TOP/admin/out directory.
perl $AD_TOP/bin/admkappsutil.pl
Database tier:
As the ORACLE user, run the environment file for the current ORACLE_HOME.
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]
unzip -o appsutil.zip
Run AutoConfig on the [RDBMS ORACLE_HOME]
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

Disable Maintenance mode
adadmin menu_option=DISABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin_DISABLE_MAINT_MODE.log

Remove the fast validation for PL/SQL recompilations from init parameter and restarted the database.
Restarted the application Tiers


Cheers!!!

SocialTwist Tell-a-Friend

Wednesday 25 August 2010

How to find the versions of technology stack components?

To find out the versions of Forms, iAS, Framework, JDK, OJSP, Database, etc. for oracle support review, you have to execute the following command like

On Application Tier

$ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl \
-script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP \
-contextfile=$CONTEXT_FILE \
-appspass=apps \
-outfile=$APPLTMP/Report_App_Inventory.html

On Database Tier

$ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=apps
-outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html

To generate the report in text format, the parameter "-reporttype=text" needs to be passed to the above commands. For example:

outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html -reporttype=text
Once the command executes successfully, it should generate the report file in the location specified for "outfile" parameter in above script


Cheers!!!
SocialTwist Tell-a-Friend

Monday 23 August 2010

Oracle E-Business Suite Release 12.1.3

Oracle just now announced Oracle E-Business Suite Release 12.1.3 have been released
To get more details about this release please see Mr.Steven Chang's blog

Oracle E-Business Suite Release 12.1.3 Now Available


Cheers!!!
SocialTwist Tell-a-Friend

Friday 20 August 2010

R12 Login issue on target after cloning , fresh install or upgrade

Successfully installed R12.1.1 in my linux box without giving any error. But when I have access my login through IE 7, http://hostname.domainname:port getting message "unable to autheticate the session" instead of giving me username and password screen. So I have thought of Firefox, using URL : http://host.domain:port is redirected to http://host.domain:port/OA_HTML/AppsLocalLogin.jsp
nothing happen , no error, ...

The cause of the issue may be Jsp / Class corruption under $COMMON_TOP/_pages,  because of that system was not able to access the classes this may have as root cause jsp / class corruption or wrong $CLASSPATH

After running the following steps, the issue has been resolved and I can able to login successfully.

1. cd $FND_TOP/patch/115/bin
2. perl ojspCompile.pl --compile --flush -p 2
3. Run autoconfig on both db and apps tiers
3. Bring up the services and test login

Cheers!!!

SocialTwist Tell-a-Friend

Thursday 19 August 2010

How to Enable Automatic Compilation of JSP pages in R12

1. Login into E-Business suite and select System Administrator responsibility

2. Select function AutoConfig (under Oracle Applications Manager)
For each web tier server perform the following:
Click on pencil icon under Edit Parameters
Select tab System
Expand section jtff_server

3. Change value for the entry s_jsp_main_mode from justrun to recompile
Confirm the change by clicking Save button


4. Run AutoConfig to propagate the changes to the configuration files
Verify that the $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml  has the following:

Check param-name "main_mode" under init-param variables
Its changed into "recompile"

5. Restart the web tier services

Cheers!!!

SocialTwist Tell-a-Friend

Wednesday 18 August 2010

How to compile JSP manually in R12

Sometimes need to recompile the JSP manually, following steps need to perform

1. Login as applmgr user and source the environment by running the script:

/oracle/apps/apps_st/appl/APPS[SID]_[host].env

2. Run the commands

Linux/Unix

cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 2

Windows

cd %FND_TOP%\patch\115\bin
perl -x ojspCompile.pl –compile –flush

3. Restart the Middle Tier services.

Cheers!!!

SocialTwist Tell-a-Friend

Tuesday 10 August 2010

Apply Release 12.1.3 - R12.ATG_PF.B.delta.3

I have applied Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) in  the following steps

Instance 12.1.2
Database version 11.2.0.1
OS OEL 4.6

Before Applying Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) required to apply R12.AD.B.DELTA.3, Patch 9239089

unzip -o p9239089_R12.AD.B_R12_LINUX.zip
As oracle user Copy adgrants.sql from this patch/admin directory to $ORACLE_HOME/appsutil/admin.
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

Enable the maintenance mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=8

Apply patch 9239089
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9239089.log patchtop=~/upgrade12.1.3/9239089 driver=u9239089.drv

Apply patch 8919491 (Applications Technology Release 12.1.3)
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=8919491.log patchtop=~/upgrade12.1.3/8919491 driver=u8919491.drv

Post-Install Steps

Apply post-install Oracle E-Business Suite Applications Technology patches
Apply the following mandatory patches:

9869602:R12.OWF.B, Patch 9869602
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9869602.log patchtop=~/upgrade12.1.3/9869602 driver=u9869602.drv

9888158:R12.FND.B, Patch 9888158
Need to shut down all Application tier services before performing the task
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9888158.log patchtop=~/upgrade12.1.3/9888158 driver=u9888158.drv

9583541:R12.TXK.B, Patch 9583541
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9583541.log patchtop=~/upgrade12.1.3/9583541 driver=u9583541.drv

9794874:R12.FND.B, Patch 9794874
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9794874.log patchtop=~/upgrade12.1.3/9794874 driver=u9794874.drv

9907182:R12.FND.B, Patch 9907182
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9907182.log patchtop=~/upgrade12.1.3/9907182 driver=u9907182.drv

9951283:R12.FND.B, Patch 9951283
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9951283.log patchtop=~/upgrade12.1.3/9951283 driver=u9951283.drv

9951284:R12.FND.B, Patch 9951284
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9951284.log patchtop=~/upgrade12.1.3/9951284 driver=u9951284.drv

Required to update database tier nodes to the Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) code level.
After that applied Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3), perform the following required post-install steps to update all database tier nodes to the AutoConfig code level that is provided by this release:

As the APPLMGR user, run the environment
$APPL_TOP/APPS$CONTEXT_NAME.env
$perl AD_TOP/bin/ admkappsutil.pl

Database tier:
As the oracle user, run the environment
Copy or FTP the appsutil.zip file to the
Uncompress appsutil.zip under the
Run AutoConfig on the .
Run AutoConfig on all nodes with an Appl_Top

Database tier and application tier:
Run adpreclone.pl on the database tier and the application tier. Since updates included in Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) were applied to the system, you must run the adpreclone again in order to apply the updates to the clone directory structures used during cloning.
perl adpreclone.pl dbTier
perl adpreclone.pl appsTier

Apply Oracle E-Business Suite Applications Technology Online Help
Apply Patch 9400185
unzip -o p9400185_R12_GENERIC.zip
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9400185.log patchtop=~/upgrade12.1.3/9400185 driver=u9400185.drv

Disable the maintenance mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=DISABLE_MAINT_MODE workers=8

Startup all Application tier services


Cheers!!!

SocialTwist Tell-a-Friend

Sunday 8 August 2010

RC-50013: FATAL: Instantiate driver did not complete successfully on DBTier

After upgradation from DB 10.2.0.4 to 11.2.0 in OEL 4.6 of Release 12.1.2 application, did the autoconfig and preclone process successfully in both db and apps tier.

While cloning to the target instance getting error from DbTier.

$perl adcfgclone.pl dbTier

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
[filename]  [phase]  [return code where appropriate]


[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/AJI/db/tech_st/11.2.0/perl/bin/perl -I /u01/oracle/AJI/db/tech_st/11.2.0/perl/lib/5.8.3 -I /u01/oracle/AJI/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3 -I /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/perl /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/clone
ouicli.pl   INSTE8_APPLY 255


AutoConfig is exiting with status 1


RC-50013: Fatal: Instantiate driver did not complete successfully.
/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/driver/regclone.drv

I have resolved this issue by copying java folder to the appsutil folder. I have already installed the latest Java 6.0. The issue is caused by [DB oracle home]/appsutil not containing the jre directory

$cp -R /usr/java/jdk1.6.0_16/  $ORACLE_HOME/appsutil/jre

Again run the cloning process,
perl adcfgclone.pl dbTier

ApplyDatabase Completed Successfully.


Cheers!!!

SocialTwist Tell-a-Friend

Saturday 7 August 2010

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

Application release 12.1.2
IAS Oracle Home 10.1.3.4

Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) Patch 8626084
Download Environment Preparation Patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) patch 8920270
Take a Backup of the Oracle E-Business Suite Release 12 10.1.3 Oracle Home and Inventory
Set your environment

Log in to the application tier as the OS user who owns the application tier file system. Navigate to the INST_TOP/ora/10.1.3 and source the SID_machine.env  file to set your 10.1.3 ORACLE_HOME.
Apply OracleAS 10.1.3.5 Patch Set

Unzip patch 8626084 (OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into a temporary directory
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 (To apply this patch, you must be running OPatch version 1.0.0.0.58 or higher)

Check the version of Opatch
[appsR12@visr12 upgrade10.1.3.5]$ $ORACLE_HOME/OPatch/opatch version
Oracle Interim Patch Installer version 1.0.0.0.57

[appsR12@visr12 upgrade10.1.3.5]$ cd $ORACLE_HOME
[appsR12@visr12 10.1.3]$ which opatch
$INST_BASE/apps/tech_st/10.1.3/OPatch/opatch
Before applying this new Opatch, make a copy of the old one
[appsR12@visr12 10.1.3]$ mv OPatch/ OPatch.070810
[appsR12@visr12 10.1.3]$ unzip ~/upgrade10.1.3.5/p6880880_101000_LINUX.zip
[appsR12@visr12 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 1.0.0.0.63

Apply patch 8920270
Need to modify the 10.1.3.5 Patchset home to install this fix.
[appsR12@visr12 upgrade10.1.3.5]$ mv Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/other.jar Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/other.jar.pre8920270
[appsR12@visr12 upgrade10.1.3.5]$ cp other.jar Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/other.jar

Run the install of the 10.1.3.5 patchset 8626084
Unzip -o p8626084_101350_LINUX

Change directory to 8626084/Disk1
If you have a Global Inventory, invoke the runInstaller program by running the command:
$ ./runInstaller
If you have a Local Inventory, invoke the runInstaller program by running the command:

$ ./runInstaller -invPtrLoc [1013_ORACLE_HOME]/oraInst.loc

This will ask for Administrator (oc4jadmin) password - oafm

Shut down any services started by OracleAS 10.1.3.5 Patch Set

[appsR12@visr12 bin]$ cd $ORACLE_HOME/opmn/bin/
[appsR12@visr12 bin]$ ./opmnctl stopall

Run AutoConfig in Application Tier
[appsR12@visr12 ~]$ . $INST_BASE/apps/apps_st/appl/APPSAJI_visr12.env
[appsR12@visr12 ~]$ cd $ADMIN_SCRIPTS_HOME
[appsR12@visr12 scripts]$ perl adautocfg.sh

Apply Any Additional OracleAS 10g Patches
Apply 8999551
unzip p8999551_101350_GENERIC.zip
[appsR12@visr12 ~]$ . $INST_BASE/inst/apps/AJI_visr12/ora/10.1.3/AJI_visr12.env
[appsR12@visr12 ~]$opatch version
Oracle Interim Patch Installer version 1.0.0.0.63
Set your current directory to the directory where the patch is located:
cd 8999551
opatch apply
Updating inventory...

Verifying patch...
Backing up comps.xml ...
OPatch succeeded.
[appsR12@visr12 8999551]$
Post-Installation Tasks

Regenerate appsborg.zip and appsborg2.zip files

Login as Apps User, source the environment file
Run adadmin, and
choose Generate product JAR files (with the no force option) to generate the appsborg.zip and appsborg2.zip files

Look for 'Oracle Application Server PatchSet' in the 'Product' column. 'Version' should show 10.1.3.5.0. or else
[appsR12@visr12 ~]$ cd $INST_BASE/apps/tech_st/10.1.3/config
[appsR12@visr12 config]$ cat ias.properties|grep Version
Version=10.1.3.5.0
Version=10.1.3.5.0

Restart application tier services
$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/password

Please refer Metalink Note: ID 454811.1 for more info


Cheers!!!
SocialTwist Tell-a-Friend

Friday 6 August 2010

Oracle Reports Cache directory growing rapidly

In R12, when concurrent requests of the execution method of Oracle Reports are submitted, temporary files are present under the path of $INST_TOP/logs/ora/10.1.2/reports/cache. This folder is growing rapidly and consume the disk space on the server and is not being purged at all.

There are multiple solutions to solve this issue

1. Shutdown the Concurrent Processing server.
2. Manually delete all the temporary files under the $INST_TOP/logs/ora/10.1.2/reports/cache path
3. Startup up the Concurrent Processing server.

Other Solution is that

As a current workaround to patch 9032800:

Change the Oracle Reports configuration file $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf and bouncing the services.

CHANGE:
property name="cacheSize" value="50" to
property name="cacheSize" value="0"

This change will be lost when Autoconfig is run. Apply patch 8602992 for permanent solution


Cheers!!!

SocialTwist Tell-a-Friend

Thursday 5 August 2010

Upgrading Release 12.1 Database from 10.2.0.4.0 to 11.2.0.1.0

Very recently I have upgraded one of my R12 database instance from 10.2.0.4.0 to 11.2.0.1.0

Current DB instance home /u01/ajidb/10.2.0
Application version 12.1.1
OS version : OEL 4.6

I have followed these steps to do that

The 11.2.0 Oracle home must be installed on the database server node in a different directory than the current Oracle home.

New Oracle Home /u01/oracle/AJI/db/tech_st/11.2.0

Once installed  base 11.2.0 software, need to set the following in .bash_profile of oracle user

ORACLE_SID=AJI;
export ORACLE_SID

ORACLE_BASE=/u01/oracle/AJI;
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/db/tech_st/11.2.0;
export ORACLE_HOME

LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/odbc/lib;
export LIBPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib;
export LD_LIBRARY_PATH

PATH=$ORACLE_HOME/bin:$PATH
PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0;
export PERL5LIB
PERL5LIB=$PERL5LIB:$ORACLE_HOME/perl/lib/site_perl/5.10.0;
export PERL5LIB



Install Oracle Database 11g Products from the 11g Examples CD


On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in section 3, "Download Oracle Database Examples" in the Oracle Database Examples CD Installation Guide


Create nls/data/9idata directoryOn the database server node, as the owner of the Oracle RDBMS file system and database instance, run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory.

Run the Oracle Net Configuration Assistant before running DBUA


When running dbua, set the _disable_fast_validate parameter using the following command: dbua -initParam "_disable_fast_validate=TRUE"


Modify initialization parameters 396009.1, Database Initialization Parameter Settings for Oracle Applications Release 12
Ensure the parameter "_disable_fast_validate=TRUE" is in the initialization file

Apply additional 11.2.0.1 RDBMS patches
Apply the following patches:



  1. 8328200
  2. 9218789
  3. 9318214
  4. 9657344
  5. 9719541
  6. 9756939

4.     Shut down Applications server processes and database listenerIf the SYS.ENABLED$INDEXES table exists, use SQL*Plus to connect to the database as SYSDBA and running the following command to drop it:SQL> drop table sys.enabled$indexes


Perform post-install instructions


After the Database Upgrade:


If the Oracle Net listener for the database instance in the new Oracle home has not been started, you must start it now. Since AutoConfig has not yet been implemented, start the listener manually.


Set the TNS_ADMIN environment variable to the directory where you created your listener.ora and tnsnames.ora file

Run adgrants.sql
Copy $APPL_TOP/admin/adgrants.sql from the administration server node to the database server node. 

$ sqlplus "/ as sysdba" @adgrants.sql [APPS schema name]


Grant create
procedure privilege on CTXSYS
Copy $AD_TOP/patch/115/sql/adctxprv.sql from the administration server node to the database server node.  
$ sqlplus apps/[APPS password] @adctxprv.sql [SYSTEM password] CTXSYS


Set CTXSYS parameter
Use SQL*Plus to connect to the database as SYSDBA and run the following command:
$ sqlplus "/ as sysdba"
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');

Validate Workflow ruleset
On the administration server node, use SQL*Plus to connect to the database as APPS and run the $FND_TOP/patch/115/sql/wfaqupfix.sql script using the following command:
$ sqlplus [APPS user]/[APPS password] @wfaqupfix.sql [APPLSYS user] [APPS user]

Implement and run AutoConfig
Implement and run AutoConfig in the new Oracle home on the database server node.

[appsR12@visr12 sql]$ cd $AD_TOP/bin
[appsR12@visr12 bin]$ perl admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/oracle/AJI/inst/apps/AJI_visr12/admin/log/MakeAppsUtil_08031011.log
output located at /u01/oracle/AJI/inst/apps/AJI_visr12/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
[appsR12@visr12 bin]$

Login as Oracle user

[oracle@visr12 11.2.0]$ cp /u01/oracle/AJI/inst/apps/AJI_visr12/admin/out/appsutil.zip $ORACLE_HOME
[oracle@visr12 11.2.0]$ unzip -o appsutil.zip
[oracle@visr12 bin]$ cd $ORACLE_HOME/appsutil/bin
[oracle@visr12 bin]$ perl adbldxml.pl jtop=/usr/java/jdk1.6.0_16

TNS_ADMIN=/u01/oracle/AJI/db/tech_st/11.2.0/network/admin;export TNS_ADMIN

[oracle@visr12 bin]$perl adbldxml.pl jtop=/usr/java/jdk1.6.0_16
Starting context file generation for db tier..
Using JVM from /usr/java/jdk1.6.0_16/bin/java to execute java programs..
APPS Password: apps
The log file for this adbldxml session is located at:
/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/log/adbldxml_08031017.log
The log file for this adbldxml session is located at:
/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/log/adbldxml_08031017.log

Enter the value for Display Variable: :1.0

The context file has been created at:
/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/AJI_visr12.xml

[oracle@visr12 bin]$ perl adconfig.sh contextfile=/u01/oracle/AJI/db/tech_st/11.2.                   0/appsutil/AJI_visr12.xml appspass=apps

After creating the XML context file, ensure the variable s_jretop points to a proper JRE directory

      Gather statistics for SYS schema
Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node. 
$ sqlplus "/ as sysdba"
SQL> alter system enable restricted session;
SQL> @adstats.sql 
$ sqlplus "/ as sysdba"
SQL> alter system disable restricted session;
SQL> exit;

        Re-create grants and synonyms
On the administration server node, as the owner of the Applications file system, run AD Administration and select the "Recreate grants and synonyms for APPS schema" task from the Maintain Applications Database Objects menu.

Restart Applications server processes
Restart all the Application tier server processes that you shut down previously. Remember that the Oracle Net listener for the database instance, as well as the database instance itself, need to be started in the 11.2 Oracle home. Users may return to the system

Synchronize Workflow views
Log on to Oracle E-Business Suite with the "System Administrator" responsibility.
Click Requests > Run > Single Request and the OK button. Enter the following parameters

Request Name = Workflow Directory Services User/Role Validation
p_BatchSize = 10000
p_Check_Dangling = Yes
Add missing user/role assignments = Yes
Update WHO columns in WF tables = No
Click "OK" and "Submit".

Cheers!!!
SocialTwist Tell-a-Friend

Wednesday 4 August 2010

Rule Set "Applsys.Wf_deferred_r" Has Errors

After upgraded database from 10.2.0.4 to 11.2.0, Rule Set WF_DEFERRED_R  became invalid

To implement the solution, please execute the following steps:

1. Run that PL/SQL

sqlplus applsys/
declare
lagent sys.aq$_agent;
subscriber_exist exception;
pragma EXCEPTION_INIT(subscriber_exist, -24034);
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name=>'APPLSYS.WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
exception
when subscriber_exist then
-- just add the rule if subscriber exists
dbms_aqadm.alter_subscriber(queue_name=>'APPLSYS.WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
end;
/

Cheers!!!

SocialTwist Tell-a-Friend

Tuesday 3 August 2010

Upgraded database 11.2.0 for R12 having AutoConfig Error

While implement and run AutoConfig form my newly upgraded database 11.2.0, getting the following errors

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
          


  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/install/AJI_visr12
      afdbprf.sh              INSTE8_PRF         1


  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/install/AJI_visr12
      adcrobj.sh              INSTE8_APPLY       1




AutoConfig is exiting with status 2

After checking privileges on $ORACLE_HOME/oracore/zoneinfo, timezone.dat and timezlrg.dat are not present ...

Cause
The multiple timezlrg.* and timezone.* are present so a choice of timezone versions are available.

Solution
To resolve the problem, create links to one of the timezone_nn.dat files. Unless you have a requirement for a specific version, choose the latest ...

$ cd $ORACLE_HOME/oracore/zoneinfo
$ ln -s timezone_11.dat timezone.dat
$ ln -s timezlrg_11.dat timezlrg.dat

After the above steps, again initiated the script, and completed successfully.

[oracle@visr12 bin]$ perl adconfig.sh contextfile=$ORACLE_HOME/appsutil/AJI_visr12.xml appspass=PASS

Using Context file          : /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/AJI_visr12.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 32 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.


Cheers!!!

SocialTwist Tell-a-Friend

Monday 2 August 2010

Upgradation from 11.5.10.2 Oracle Apps to R12.1.1

Using the following steps I have successfully upgraded my instance to R12.1.1

In this test, I didn't upgraded the individual products upgrade, the main focus was to upgrade from 11i to R12.1.1. The below upgrade steps are for testing purposes only, please do refer metalink note for more information

Status of my instance are:-
Already my instance is  on 11i.AD.I.7
Database version: 10.2.0.4.0
Apps Version: 11.5.10.2
Developer 6i latest patchset 19
Applied Latest CPU July 2010 both Apps and DB tiers
Java version "1.6.0_07"

This instance is Multi-Org, coz multi-org is mandatory in R12.1.1

1. Applied TUMS utility  - 7705743

2. Applied Run AD preparation scripts - 7197489

3. 12.1.1 Rapid Install completed successfully with "Upgrade File"
 Here for R12, created one new apps user, appsR12

4. Applied required patches for 10.2.0.4

-4247037
-6084656
-6600051
-6870937
-6991626
-7014646

5. Gather statistics for SYS schema completed

Copied R12 $APPL_TOP/admin/adstats.sql from the administration server node to the database server node

$ sqlplus "/ as sysdba"
SQL> shutdown normal;
SQL> startup restrict;
SQL> @adstats.sql
SQL> shutdown normal;
SQL> startup;
SQL> exit;

6. Updated init.ora with new parameters (Metalink Note:396009.1)

7. Maintenance Mode is enabled
 Source the R12 Application Tier

8. Applied AD 12.1.1 upgrade driver - 7461070

9. Run the American English upgrade patch driver - u6678700.drv
 cd $AU_TOP/patch/115/driver
 adpatch options=nocopyportion,nogenerateportion
 (depends on your hardware, this process will take hours/days. So be patient)

10. Configure and start server processes – RunInstaller
  Start the runinstaller from staging area again

11. run autoconfig from Apps Tier as well as Db Tier

12. Restart the R12 Apps Tier

Lots of issues in between upgrade patch driver process, always keep on monitoring the log file and clear the issues and restart the workers using adctrl utility. This issues will vary depends on installation to installation.
Before starting the upgrade driver process, you have to make sure enough space on APPS_TS_TX_DATA tablespace.

Cheers!!!

SocialTwist Tell-a-Friend

Sunday 1 August 2010

Concurrent Manger status : System Hold, Fix Manager before resetting

After upgradation from 11.5.10.2 to 12.1.1, some of the concurrent managers are not coming up and  showing the following error:

The actual value of the manager is 0.

ERROR
"System Hold, Fix Manager before resetting counters".  

Finally as per the note:985835.1, I have done the following

1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is running.

2. Stop the database.

3. Start the database.

4. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y "fnd FNDLIBR"
$ adrelink.sh force=y link_debug=y "fnd FNDFS"
$ adrelink.sh force=y link_debug=y "fnd FNDCRM"
$ adrelink.sh force=y link_debug=y "fnd FNDSM"

5. Run the CMCLEAN.SQL script from the referenced note below (don't forget to commit).

6. Execute the following SQL:

select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where
CONCURRENT_QUEUE_NAME like 'FNDSM%';

7. Start the middle tier services including your concurrent manager.

Now all of my concurrent  managers are back to normal.


Cheers!!!

SocialTwist Tell-a-Friend