How to copy / migrate printer definitions to a new instance using FNDLOAD

Imagine below situation:

1. Target had been cloned from source
2. Couple of new printers had been configured on source after the clone.
3. Now you want the same printer configurations on target instance similar to source.

Options:

1. Perform the steps manually on target instance
2. Clone target from source
3. Use FNDLOAD (Generic Loader Utility)

We will discuss FNDLOAD option in this post.

How to download all printer definitions

1. Download the printer definitions from source

FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppinf.lct source_printer_def.ldt FND_PRINTER

2. Connect to target instance
3. Get the source printer definition file (source_printer_def.ldt) from source (ftp, scp or any method that you like)
4. Create a backup of the target system printer information
4.1. Connect to sqlplus as apps user and below commands

create table fnd_printer_bk as (select * from fnd_printer);
select printer_name from fnd_printer_bk;

5. Now upload the printer definitions into the target system

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcppinf.lct source_printer_def.ldt FND_PRINTER

SQL> select printer_name from fnd_printer;

Above sql should list the new printers that are uploaded.

How to download a specific printer definition

FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppinf.lct source_printer_def.ldt FND_PRINTER PRINTER_NAME=[printer name]

This is one of the functionality of FNDLOAD. Refer to this metalink note : 274667.1 for other features of FNDLOAD.

India Localization Patch – Oracle EBS 11.5.10.2

In Oracle EBS we do have adpatch utlilty to apply patches and we do have localizations as per the country specific. To apply patch for India Localized environment we can not use adpatch.

If you are applying India Localization patch you should use India Localization patch tool (indpatch.pl).

Also, if it is multimode installation patch needs to be applied on all the nodes with appropriate mode.

Patch should be applied twice with different mode though DB and Concurrent Processing server sits in same node.

Please find the attached document for the same

Enjoy Reading.

india_localization_patch

Upgrade Oracle Application Server to 10.1.3.4 (10g R3 patchset 4)

This post covers overview of applying Oracle Application Server 10g R3 patchset 4 (10.1.3.4) on existing 10g R3 (10.1.3)

Key Points for 10.1.3.4 Upgrade

1. Patch Number for OAS 10g R3 patchset 4 (10.1.3.4) is 7272722

2. 10g R3 patchset 4 (10.1.3.4.0 – 7272722) is cumulative and includes all fixes from 10.1.3.0, 10.1.3.1, 10.1.3.2 and 10.1.3.3

3. 10g R3 patchset 4 (10.1.3.4.0) is NOT complete software, you need to install in on top of one of existing software i.e. 10.1.3.n (10.1.3.0, 10.1.3.1, 10.1.3.2 or 10.1.3.3)

4. If you are on Solaris, minimum OAS version should be 10.1.3.1 (If you are on 10.1.3.0.0 on Solaris, first upgrade to 10.1.3.1 and then upgrade to 10.1.3.4)

5. 10g Rel 3 patchset 1 (10.1.3.1.0) is starting point for Oracle SOA Suite (BPEL,ESB…) and 10g Rel 3 patchset 2 (10.1.3.2.0) is starting point for WebCenter Suite(ContentDB, WebCenter Services). If you are using Oracle SOA Suite or Oracle Web Center then you need to do additonal steps before upgrade like
– upgrade_10131_10134_oracle.sql (10.1.3.1) or
– upgrade_10133_10134_oracle.sql (10.1.3.3)  (For BPEL from ORABPEL schema)
– upgrade_10133_10134_oracle.sql  (For ESB from ORAESB schema)

6. 10.1.3.4 patch set updates DSA (Application Server Guard) ports so if you have edited dsa.conf , reset it back after 10.1.3.4 patch set. – Oracle is moving away from ASGuard/DSA; try not to use it * More information coming soon …

7. It is NOT possible to upgrade from 10g Rel2 (10.1.2.X) to 10g Rel3 (10.1.3.X) Application Server (Till date)

Top Level Steps

1. If you are using BPEL; Run  upgrade_10131_10134_oracle.sql (10.1.3.1) or upgrade_10133_10134_oracle.sql (10.1.3.3) from ORABPEL schema
2. If you are using ESB; Run  upgrade_10133_10134_oracle.sql from ORAESB schema
3. Install 10.1.3.4 Software in same ORACLE_HOME (as of 10g R3, 10.1.3.X)

For exact steps follow read me of patch 7272722

References

• 727068.1 Oracle Application Server Patch Set Notes Addendum 10g Release 3 (10.1.3) Patch Set 4 (10.1.3.4.0)
• 397022.1 Oracle Application Server 10g Release 3 (10.1.3) Support Status and Alert

How to Upgrade Oracle Application server 10g (10.1.3) in R12 (12i/EBS)

Key Points for Oracle Application Server 10.1.3 Upgrade in R12

1. There are two Oracle Homes under application tier in R12 (Total three , third one is database oracle home)
a) 10.1.2 for forms & reports
b) 10.1.3 for Web (Apache) and J2EE (OC4J for oacore, oafm and forms)

Two Oracle Home (10.1.2 and 10.1.3) are under 
R12_BASE_INSTALL_DIR/apps/tech_st/

2. This document explains steps to upgrade 10.1.3 Oracle Home to latest certified patch set i.e. 10.1.3.4 with R12 (as of 12 Mar 09)

3. It is not possible/certified to upgrade 10.1.2 Oracle Home (in R12) to 10.1.3

4. Oracle Application Server 10.1.3.4 is NOT a complete software, you need to apply it on existing 10.1.3.X and available via patch 7272722

5. You should be on minimum 12.0.3 (version of R12/12i) to upgrade 10.1.3 Oracle Home. To check your apps R12 version use
SQL> select release_name from apps.fnd_product_groups;

6. During upgrade, installer will prompt for OC4JADMIN password. If your source oracle home version is 10.1.3.0 then password for oc4jadmin is secret else (for 10.1.3.1/2/3) password is oafm

If you don’t remember oc4jadmin password you can reset oc4jadmin passwordcheck here

7. To check current Oracle Application Server Patchset version i.e. if 10.1.3.0 or 10.1.3.1 or 10.1.3.2

a) Using runInstaller 
–Invoke runInstaller from 1013_ORACLE_HOME/oui/bin
–Click on Installed Products.
–Select the 10.1.3 Oracle Home and expand the tree. You should see Oracle Application Server Patchset 10.1.3.X patch in the list.

b) Using Opatch 
Run the command ‘opatch lsinventory -detail‘
Look for ‘Oracle Application Server PatchSet‘ in the ‘Product‘ column.

.
Main Upgrade Steps

1. Apply Oracle E-Business Suite Patches (at-least 12.0.3, autoconfig templatepatch to support latest OAS i.e. 10.1.3.4)
2. Apply 10.1.3.4 patchset to 10.1.3 Oracle Home using runInstaller (10.1.3.4 is latest certified patchset as of 12 Mar 09). Ensure Oarcle Home is set to 10.1.3 (Not 10.1.2)
3. Run Autoconfig
4. Apply additional patches to 10.1.3 oracle home (using opatch and not adpatch)
5. Regenerate appsborg.zip and appsborg2.zip files using adadmin
6. Restart application tier services for r12 .

For step by step OAS upgrade steps for R12 check metalink note 454811.1

.
References

• 454811.1  Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12
• 728531.1  Upgrading to the OracleAS 10g 10.1.3.3 Patch Set in Oracle E-Business Suite Release 12
• Upgrade Standalone Oracle Application Server 10g R3 to 10.1.3.4
• Read Me of Patch  7272722

How to Upgrade Oracle Application Server 10g R2 (10.1.2) forms/reports in R12/12i – 5983622

This post covers overview of Forms and Reports Upgrade in Oracle Apps R12 (12.0.X) to 10.1.2.3

Key Points for 10.1.2 upgrade in R12/12i (12.0.X)

1.There are two ORACLE_HOMEs on Application Tier
10.1.2.X for Forms & Reports
10.1.3.X for Web Server & J2EE application

2. By default, R12 uses Forms Servlet Architecturefor forms requests (to know more about Forms Servlet click here ); which uses J2EE container (JVM) in 10.1.3 ORACLE_HOME .
This means one HTTP Server (Apache) in 10.1.3 ORACLE_HOME serves all HTTP, Forms and Reports requests. (HTTP Server in 10.1.2 Oracle Home is not used)

You need to deploy new Forms Servlet (formsapp.ear) to 10.1.3 Oracle Home after 10.1.2 Oracle Home upgrade.

3.Deploying new Forms Servlet to 10.1.3 Oracle HOme means deployingformsapp.ear file to 10.1.3 ORACLE_HOME. Use txkrun.pl -script=CfgOC4JAppto deploy new forms servlet in 10.1.3 Home (Metalink Note 397174.1)

4.oc4jadmin password (for 10.1.3 HOME) is stored in xml file $INST_TOP/ ora/ 10.1.3/ j2ee/ forms/ config/ system-jazn-data.xml , If you don’t know oc4jadminpassword or wish to change it use steps mentioned here

5. To check forms/reports current version in R12 use
$ $ORACLE_HOME/bin/frmcmp help=y
Forms 10.1 (Form Compiler) Version 10.1.2.2.0 (Production)

6. You need ias_admin password during forms and reports upgrade (default password is secret). Test that you can login as ias_admin/secret

$ emctl authenticate secret
Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
success

__________

If you get error like 
$ORACLE_HOME/bin/emctl: /d2/ R12/ ab/ apps/ RUP4XB6/ apps/ tech_st/ 10.1.2: does not exist

Fix

Open $ORACLE_HOME/bin/ emctl, emagentdeploy.pl, emdctl and change ORACLE_HOME to correct value

If you get error like
oracle.security.jazn.JAZNInitException: /d2/ R12/ ab/ apps/ RUP4XB6/ apps/ tech_st/ 10.1.2/ sysman/ j2ee/ config/ jazn-data.xml (No such file or directory)

Copy $ORACLE_HOME/sysman/j2ee/config/jazn-data.xml to /d2/R12/ab/apps/RUP4XB6/apps/tech_st/10.1.2/sysman/j2ee/config

__________

.

Forms & Reports Upgrade steps in R12

1. Stop Middle Tier Services

2.Download & install pre-req patch (conditional)

3. Ensure that Inventory is pointing to right location

4.Install 10.1.2.3 (5983622 – This is latest Forms & Report Patchset) usingrunInstaller from Disk1 (inside patch)
4.1 Select “Oracle Application Server and Developer Suite 10g Rel 2 Software Update” on Select a Product to Install screen
4.2 When prompted for ias_admin password on Application Server Instance Password screen enter secret

5. Shutdown OPMN from 10.1.2 Home (Installer starts OPMN after upgrade)

6. Apply additional interoperability patches

7. Rebuild Forms & Regenerate Jar files

8. Deploy new Forms Servlet to 10.1.3 Oracle Home

9. Start Application

For Step 1-7 follow metalink note 437878.1
For Step 8 follow metalink note 397174.1
For Step 4 follow readme of patch 5983622

References

• 437878.1  Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
• 397174.1  Deploying a New Forms .ear File in Oracle Applications Release 12
• 387106.1  Unable to Apply OracleAS 10g Rel 2 Patchset: ias_admin – “Password Entered .. Is Incorrect”
• 761995.1  Error when following Note 437878.1 : “password you have entered is incorrect. Please enter the ias_admin password that is assigned for this instance
• 420649.1  DBUA from 10Gr2 Oracle Home comes with R12 RapidInstall is not working
• Read Me of Patch – 5983622
• Deploying J2EE Application on OC4J