APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 36,440 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    March 2009
    M T W T F S S
    « Feb   Apr »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
  • Archives

  • Authors

Applying Oracle Applications Technology 11i.ATG_PF.H.delta.5 (RUP5)

Posted by appsinfo on March 1, 2009

Steps to apply 11i.ATG_PF.H.delta.5 (RUP5)

 Pre-install Steps:

 

Step 1 Upgrade the RDBMS to Oracle9i Database or higher (Required)

Upgrade your RDBMS to Oracle9i Database before upgrading to 11i.ATG_PF.H.delta.5 (RUP5). Refer Upgrade document OracleMetaLink Note 362203.1

For Windows installations only: Download and apply patches 3095277 and 3380100. Follow instructions in each readme to upgrade the database first to 9.2.0.4 and then to 9.2.0.4 Patch 5.

 

Step 2 Apply the AD minipack. (Conditionally Required)

Ensure that the you have installed the latest version of AD before proceeding with this patch. At this time the latest version is AD minipack I.4.

·         4712852 – AD: Patch 11i.AD.I.4  or AD.I.6

 

Step 3 Apply additional prerequisites as needed. (Conditionally Required)

Depending on the baseline of your installation, patches in this section must be applied prior to proceeding with further with the RUP 5 installation steps.

Apply the following patches for all installations:

·         5989593 – AD: 11i: Remove “REVOKE ALL FROM PUBLIC” from ADGRANTS.SQL

·         3218526 – BNE: Patch 11i.BNE.D – Refer to About Web Applications Desktop Integrator Mini-pack 11i.BNE.D, OracleMetaLink Note 287080.1, for installation instructions.

·         4206794 – FRM: Patch 11i.FRM.H – Refer to About Oracle Report Manager Minipack 11i.FRM.H, OracleMetaLink Note 378338.1, for installation instructions.

 

Step 4 Run the Technology Stack Validation Utility. (Required)

In your operating system file system, navigate to the directory where you have unzipped these Applications Technology Updates.

  •  Establish the needed environment parameters by sourcing the Applications environment file  as the owner of the application tier file system.
  • Ensure “APPLRGF” variable is set in environment. If not, set it to the same value as “APPLTMP”.
  • From the location where this patch was unzipped, change directory to fnd/patch/115/bin.
  • Run the utility as follows:

%ADPERLPRG% txkprepatchcheck.pl -script=ValidateRollup  -outfile=%APPLTMP%\txkValidateRollup.html   -appspass=<apps database password>

 

Step 5 : Applying this patch 11i.ATG_PF.H.delta.5 (RUP5)

Oracle Applications Technology Updates for 11i.ATG_PF.H.delta.5 (RUP5) contains a unified patch driver to be applied with AutoPatch. Please apply the driver file on all application tier server nodes.

·         u5473858.drv

 

After you apply this patch…

Post-install Steps

Once you have successfully applied Oracle Applications Technology Updates for 11i.ATG_PF.H.delta.5 (RUP5), you must complete these additional steps. If you completed a task during a previous 11i patch application, then you do not need to complete the step again, unless otherwise instructed.

Step 1 Apply Post-Install Patches. (Required)

Apply the following patch (all releases):

·         3865683 – AD: Release 11.5.10 Products Name Patch

·         6145463 – Support Negative Currency Profile Value ‘(XXX)’

 

Step 2 Apply Release-Specific Post-Install Patches. (Conditionally Required)

Apply the relevant patches if your installation is on a listed release level.

4619025 – Invalid Package CS_WF_ACTIVITIES_PKG

5368595 – KM Pages Incorrectly Switch to Guest User Responsibility in iSupport Flow

5910548 – Patch for Bug 5879690 Failed – Core HRMS

 

Step 3 Apply SSO 10g Integration Patch. (Conditionally Required)

This step applies only to those E-Business Suite deployments that are integrated with Oracle Application Server 10g (Single Sign-On and Oracle Internet Directory). If the E-Business Suite deployment is not integrated with Oracle Application Server 10g, you can skip this step.

Do not apply this patch if you want to retain your existing Oracle Login Server 3.0.9 and Oracle Portal 3.0.9 integration. This patch includes libraries that are incompatible with Oracle Login Server 3.0.9.

For this step, apply the following patch:

·         5674941 – 11i.ATG_PF.H RUP5 SSO 10g Integration

This patch delivers an updated Single Sign-On SDK; you will need to de-register and re-register all your SSO partner applications. Please follow Option 3 under “Appendix C: Advanced Configuration – Manual SSO/OID Registration” in the Installation Guide, Metalink Note 233436.1, to de-register the partner applications first and then re-register them again.

If you are integrating the E-Business Suite deployment with Oracle Application Server 10g for the first time, refer to MetaLink Note 233436.1 for detailed instructions.

 

Step 4 Run Technology Stack script. (Conditionally Required)

If your environment is SSL-enabled, run the following script (for Technology Stack patch 4029076, included in 11i.ATG_PF.H.delta.5 (RUP5):

On Unix:

txkrun.pl -script=InstSSLFix

On Windows:

perl %FND_TOP%\bin\txkrun.pl -script=InstSSLFix

 

Step 5 : Upgrade Oracle XML Parser for Java v9.0.4 with Oracle Applications 11i. (Required)

Follow the instructions in OracleMetaLink note 271148.1 to configure and apply interoperability patches for Oracle XML Parser for Java v9.0.4.

Step 6 Run AutoConfig. (Required)

Run AutoConfig on the application and database tiers. For instructions on how to run AutoConfig, refer to OracleMetaLink note 165195.1.

Customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfig templates provided via this patch before running AutoConfig.

Step 7 Create APPS_TS_TOOLS Tablespace. (Conditionally Required)

Customers who have migrated to the new Oracle Applications Tablespace Model must create the APPS_TS_TOOLS tablespace, either manually through SQL*Plus or by invoking the Tablespace Migration Utility menu, before running the AD Splicer to introduce a new product schema. For more information, see: Understanding the Tablespace Migration Utility Main Menu, Oracle Applications System Administrator’s Guide – Configuration.

The default initial size for the APPS_TS_TOOLS tablespace is 500 MB, with auto segment management enabled. If you create the APPS_TS_TOOLS tablespace through SQL*Plus, outside of the OATM utility, you can use the following statement:

CREATE TABLESPACE APPS_TS_TOOLS DATAFILE
datafile_name.dbf‘ SIZE 500M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

You can override these storage recommendations with storage parameters to suit the expected size required for objects that will be in the Tools tablespace at your site.

Step 8 Disable Default Users. (Recommended)

 

Application User

Product/Purpose

 

 

ANONYMOUS

FND/AOL

AUTOINSTALL

AD (Application DBA)

CONCURRENT MANAGER

FND/AOL

FEEDER SYSTEM

AD (Application DBA)

INITIAL SETUP

AD (Application DBA)

STANDALONE BATCH PROCESS

FND/AOL

MOBILEADM

Mobile Applications Admin

ASGADM

Field Service/Sales Application Admin

WIZARD

AD (Application DBA)

ASGUEST

Sales Application guest user

IEXADMIN

Internet Expenses

IBE_GUEST

iSupport Guest user – 1

IBE_ADMIN

iSupport Admin user

IBEGUEST

iSupport Guest user – 1

OP_SYSADMIN

OP (Process Manufacturing) Admin User

OP_CUST_CARE_ADMIN

Customer Care Admin for Oracle Provisioning

IRC_EMP_GUEST

iRec Employee Guest Login

IRC_EXT_GUEST

iRecruitment External Guest Login

 

Step 9 Copy Fonts for Oracle XML Publisher. (Required)

Copy the following font files from $FND_TOP/resource to the /lib/fonts directory (under OA_JRE_TOP and JRE_TOP) on all Web and concurrent nodes. If $FND_TOP/resource does not contain the font files, apply patch 3639533: Albany (Display) Font 4.02 Release.

The font files are:

ALBANYWT.ttf – “single-byte” characters only

ALBANWTJ.ttf – Unicode font with Japanese Han Ideographs

ALBANWTK.ttf – Unicode font with Korean Han Ideographs

ALBANWTS.ttf – Unicode font with Simplified Chinese Han Ideographs

ALBANWTT.ttf – Unicode font with Traditional Chinese Han Ideographs

Please refer to the OracleMetaLink document 240862.1, Install Oracle Unicode Fonts for Dynamic Image Generation in Oracle Applications, for more details.

Step 10 Update Configuration for Dedicated Notification Mailers. (Conditionally Required)

If you have defined any custom notification mailer service components that are dedicated to process only messages from a particular item type, then you must update the correlation ID value for those notification mailers to continue processing messages. You can set the correlation ID in the Define page of the advanced configuration wizard in Oracle Workflow Manager. For each notification mailer, set the correlation ID to the internal item type name followed by a colon and a percent sign in the following format:

<item_type_name>:%

For example:

WFDEMO:% 

Advertisements

One Response to “Applying Oracle Applications Technology 11i.ATG_PF.H.delta.5 (RUP5)”

  1. sql wildcard,sql wildcards,sql rollback,rollback sql,sql copy table,sql sum,sql mirroring,sum sql,sql cluster,sql server performance,truncate in sql,backup sql,backup sql database,backup sql server,sql performance,date functions in sql,sql over,trunc…

    […]Applying Oracle Applications Technology 11i.ATG_PF.H.delta.5 (RUP5) « Oracle DBA’s Group[…]…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: