Wednesday, 12 September 2012

Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

Adding responsibility to SYSADMIN user resulted the below error.

Issue : Adding responsibility to SYSADMIN user resulted the below error in R12

Oracle error - 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE
(USERNAME=SYSADMIN)
(ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has
been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

Resolution:

Issue exists in default R12 installation

Refer Oracle Note id : 454988.1

1. Run the concurrent program "Workflow Directory Services User/Role Validation" with parameters : 100000, Yes, Yes, No

2. Bounce all services under oacore or bounce opmnctl


Monday, 27 August 2012

Oracle Applications Upgrade from 12.1.1 to 12.1.3

Oracle Applications Upgrade from 12.1.1 to 12.1.3

Oracle Applications Upgrade from 12.1.1 to 12.1.3 (With Database 11.1.0.7):

The below steps outline the step by step actions to upgrade Oracle apps from 12.1.1 to 12.1.3

1)Bring down all the services and Take cold backup of the instance (Suggested)

2) Apply Database Patches
Please check and apply the below database patches.
For all UNIX/Linux platforms
    * 7111245
    * 7211965
    * 7330434
    * 7486407
    * 7627743
    * 7639602
    * 7684818
    * 8199107
    * 8639653
    * 8940108
    * 9026927
    * 9066130
    * 9554727
    * 9743057


3)For Linux x86-64, patch 7319922 contained within 7684818 was packaged incorrectly.

The new version of patch 7319922 has to be applied. Perform the following instructions:
Go to the 11.1.0.7 $ORACLE_HOME/inventory/oneoffs/7319922 directory.
Run "opatch rollback -id 7319922" to rollback patch 7319922.
Download the new version of patch 7319922 on My Oracle Support.
Go to the patch 7319922 directory.

Run "opatch apply"

4)Modify Initialization Parameters
_disable_fast_validate=TRUE
recyclebin=off

5)Techstack Upgrade:
 A)Verify the 10.1.3.X  Oracle Home version and the required version is 10.1.3.4 or higher <Use Document 454811.1> (for 10.1.3.5 ) or <Document 728531.1> (for 10.1.3.4 ) to upgrade it

 TO check the versions perform the below
 --------------------------------


 cd $INST_TOP/ora/10.1.3
 . ./$CONTEXT_NAME.env


 $ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|Patch of Oracle Application Server 10g'
 Note: Oracle Application Server 10g signifies the Base Install and
 Patch of Oracle Application Server 10g signifies the Patchset on top of it

 Example: 
  $ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|Patch of Oracle Application Server 10g'
 Oracle Application Server 10g                                    10.1.3.0.0
 Patch of Oracle Application Server 10g                           10.1.3.4.0
 


 B)Verify the 10.1.2.X  Oracle Home version and the required version is 10.1.2.3 <Use Document 437878.1 to upgrade it.>

 TO check the versions perform the below
 ----------------------------------------


 Log-out and Re-Login, before performing the following steps.

 $ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|Patch of Oracle Application Server 10g'

 Note: Oracle Application Server 10g signifies the Base Install

 Patch of Oracle Application Server 10g signifies the Patchset on top of it

 Example:

 $ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|Patch of Oracle Application Server 10g'
 Oracle Application Server 10g                                    10.1.2.0.2
 Patch of Oracle Application Server 10g                           10.1.2.3.0
 



6)Applications upgrade


a)Apply R12.AD.B.DELTA.3 <Patch 9239089>

Usage:
------
  1. Create $ORACLE_HOME/appsutil/admin on the database server.

  2. Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin.
  3. Set the environment to point to ORACLE_HOME on the database server.
  4. Use SQL*Plus to run the script:
     $ sqlplus /nolog
     SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPLSYS
  5. Apply u9239089.drv of the patch using adpatch
b)Apply Oracle E-Business Suite Release 12.1.3 <Patch 9239090>
  Apply  u9239090.drv of the patch using adpatch
c)Apply the latest consolidated online help <Patch 9239095>
  Apply u9239095.drv of the patch using adpatch


7)Post-Update Steps:

Apply post-install Oracle E-Business Suite Applications Technology patches. (Required)

 A) Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH].)
 
     Apply  u9817770.drv of the patch using adpatch
    
 B) Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)

     Apply  u9966055.drv of the patch using adpatch

8)Run autoconfig

Application tier:
-------------------

$cd $ADMIN_SCRIPTS_HOME
$adautocfg.sh
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:
-------------------

Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>.
$cd $ORACLE_HOME
$unzip -o appsutil.zip
Run AutoConfig on the Database Node:
$cd $ORACLE_HOME/appsutil/scripts
$adautocfg.sh
9)Modify Initialization Parameters and bounce database
remove entry _disable_fast_validate=TRUE
set recyclebin=ON


10) Start Applications and Perform a health check of the instance.