Tuesday, 16 November 2010
Monday, 18 January 2010
Oracle E-Business Suite Upgrade from 12.0.x to 12.1.2
Step Upgrade Step Description Status Time Notes
1 Upgrade the Oracle database to 11.1.0.7 N/A Staying at 10.2.0.4
2 Upgrade OracleAS 10g Release 3 (10.1.3) to Patchset 5 (10.1.3.5) Shutdown the apps before applying the upgrade
3 Upgrade OracleAS 10g Release 2 (10.1.2) for Forms and Reports to Patchset 3 (10.1.2.3) Shutdown the apps before applying the upgrade
4 Upgrade Oracle E-Business Suite Release 12 JDK to Java 6.0 latest update Done Already completed
5 Setup Oracle Configuration Manager (OCM) N/A
6 Apply Patch 8886260:R12.FND.A N/A Not required
7 Apply the AD Minipack (7461070)
8 Apply Patch 8764069:R12.FND.B
Apply necessary db patches 6084656
9 Apply Release 12.1.1 (7303030)
10 Update Documenation (7303031)
11 Setup AutoConfig on the database tier
12 Apply NLS maintenance packs N/A No additional languages required
13 Apply patch 8609614
14 "Register new products if needed:
- Channel Rebates and Point Of Sale Management
- Supplier Ship and Debit
- Price Protection
- Site Hub
- Landed Cost Management" N/A Additional products will not be used
15 Perform Product-specific steps: (Conditional)
16 Oracle Complex Maintenance Repair and Overhaul N/A Not required
17 Oracle Enterprise Performance Foundation Need additional info
18 Oracle iRecruitment N/A
19 Oracle E-Business Suite Integrated SOA Gateway N/A Not required
20 Oracle Shipping Execution with Oracle Transportation Management N/A Not required
21 Oracle Value Chain Planning N/A Not required
22 Oracle Manufacturing Operations Center N/A Not required
23 Oracle Demand Signal Repository N/A Not required
24 Oracle E-Business Suite Diagnostics
25 Oracle Profitability Manager
26 Oracle Product Information Management N/A Not required
27 Oracle Purchasing with Oracle Transportation Management N/A Not required
28 Oracle Warehouse Management with Oracle Transportation Management N/A Not required
29 Oracle Internal Controls Manager N/A Not required
30 Oracle Financials for India
31 Oracle Service N/A (10.2.0.3 db)
32 Oracle Price Protection N/A Not required
33 Oracle Discoverer End User Layer N/A Already set
34 Oracle Purchasing N/A (10.2.0.3 db)
35 "Additional HRMS patches:
8854577
8807374
8666759
7757345
7835677
8326134
"
36 Apply patch 8502056 (Pre-req for 12.1.2)
37 Apply 12.1.2 Roll Up (Patch 7303033)
38 Update documentation: Patch 7303032
39 "Apply the following patches: (Already downloaded)
9217668
7589330
8746079"
1 Upgrade the Oracle database to 11.1.0.7 N/A Staying at 10.2.0.4
2 Upgrade OracleAS 10g Release 3 (10.1.3) to Patchset 5 (10.1.3.5) Shutdown the apps before applying the upgrade
3 Upgrade OracleAS 10g Release 2 (10.1.2) for Forms and Reports to Patchset 3 (10.1.2.3) Shutdown the apps before applying the upgrade
4 Upgrade Oracle E-Business Suite Release 12 JDK to Java 6.0 latest update Done Already completed
5 Setup Oracle Configuration Manager (OCM) N/A
6 Apply Patch 8886260:R12.FND.A N/A Not required
7 Apply the AD Minipack (7461070)
8 Apply Patch 8764069:R12.FND.B
Apply necessary db patches 6084656
9 Apply Release 12.1.1 (7303030)
10 Update Documenation (7303031)
11 Setup AutoConfig on the database tier
12 Apply NLS maintenance packs N/A No additional languages required
13 Apply patch 8609614
14 "Register new products if needed:
- Channel Rebates and Point Of Sale Management
- Supplier Ship and Debit
- Price Protection
- Site Hub
- Landed Cost Management" N/A Additional products will not be used
15 Perform Product-specific steps: (Conditional)
16 Oracle Complex Maintenance Repair and Overhaul N/A Not required
17 Oracle Enterprise Performance Foundation Need additional info
18 Oracle iRecruitment N/A
19 Oracle E-Business Suite Integrated SOA Gateway N/A Not required
20 Oracle Shipping Execution with Oracle Transportation Management N/A Not required
21 Oracle Value Chain Planning N/A Not required
22 Oracle Manufacturing Operations Center N/A Not required
23 Oracle Demand Signal Repository N/A Not required
24 Oracle E-Business Suite Diagnostics
25 Oracle Profitability Manager
26 Oracle Product Information Management N/A Not required
27 Oracle Purchasing with Oracle Transportation Management N/A Not required
28 Oracle Warehouse Management with Oracle Transportation Management N/A Not required
29 Oracle Internal Controls Manager N/A Not required
30 Oracle Financials for India
31 Oracle Service N/A (10.2.0.3 db)
32 Oracle Price Protection N/A Not required
33 Oracle Discoverer End User Layer N/A Already set
34 Oracle Purchasing N/A (10.2.0.3 db)
35 "Additional HRMS patches:
8854577
8807374
8666759
7757345
7835677
8326134
"
36 Apply patch 8502056 (Pre-req for 12.1.2)
37 Apply 12.1.2 Roll Up (Patch 7303033)
38 Update documentation: Patch 7303032
39 "Apply the following patches: (Already downloaded)
9217668
7589330
8746079"
Upgrade OracleAS 10g Release 2 (10.1.2.2.0) for Forms and Reports to Patchset 3 (10.1.2.3.0)
Upgrade OracleAS 10g Release 2 (10.1.2.2.0) for Forms and Reports to Patchset 3 (10.1.2.3.0)
Metalink Note ID Refered : ID 437878.1
1) Download latest certified OracleAS patchset and Oracle E-Business Suite Interoperability Patch
Download the latest certified OracleAS 10g patchset. In addition, you will need the E-Business Suite/Forms Interoperability patch corresponding to the OracleAS 10g patchset you are installing. The number for the interoperability patch is given in the right-hand column.
Oracle Application Server 10g Oracle Application Server 10g Patchset Oracle Forms Oracle Reports Oracle E-Business Suite Interoperability Patch
OracleAS Patchset 10.1.2.3.0 5983622 10.1.2.3.0 10.1.2.3.0 7120543
2) Download Additional Patches
Platform Nature of Patch Patch
Linux Forms - Java Patch 9044638
Linux Forms - Platform-Specific 7121788
Linux Forms - C Patch 6857221
Linux 4407272
Linux 4526825
Linux 7329300
Linux 8557019
Linux Reports - Platform-Specific 5705981
Linux 7230832
Linux Reports - C Patch 7016961
Linux 5917053
Linux 6371228
Linux Reports - Java Patch 7140392
Linux Reports - Generic Patch 8300196
3) Stop All Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps
4) Back Up OracleAS 10.1.2 ORACLE_HOME and Inventory folder
Oracle recommends that you make a backup of your existing environment before you install Oracle Application Server 10g Release 2 patchset 3 (10.1.2.3.0).This will enable you to restore your original environment if you encounter a problem with application of the patch, or need to remove the patch for some reason.
You are also advised to take a complete backup of the Inventory folder (either global or local) that contains the OracleAS 10.1.2 ORACLE_HOME inventory details.
5) Install the Application Server Latest Certified Patchset (10.1.2.3.0)
The steps in this section will install the OracleAS 10g 10.1.2.3.0 patchset on all application tier nodes hosting Forms and Reports services.
Note: All references to "ORACLE_HOME" refer to the OracleAS 10.1.2 Oracle Home that contains the Forms and Reports 10g installation. Ensure that you are using same oraInventory that was created during Oracle E-Business Suite Release 12 installation.
Unzip the Patchset
Unzip patch 5983622 into a temporary directory.
Apply OracleAS 10g Release 2 Patchset 3 (10.1.2.3.0)
The following steps will apply the patchset.
Execute runInstaller
Execute runInstaller (UNIX) and choose "Oracle Application Server and Developer Suite 10g R2 Software Update 10.1.2.3.0" as the install option.
On Linux and UNIX:
If you have a Global Inventory, invoke the Installer by changing to the appropriate directory and running the command:
$ ./runInstaller
If you have a Local Inventory, invoke the Installer by changing to the appropriate directory running the command:
$ ./runInstaller -invPtrLoc <1012_ORACLE_HOME>/oraInst.loc
Supply the ias_admin default password
Supply the ias_admin default password 'secret' when prompted.
Note: You may see failures while executing OC4J configuration assistant as part of post install configuration steps. Please select Next to skip the configuration assistant. This action will skip the remaining configuration assistants, which is expected for Oracle E-Business Suite customers.
Shut Down Services Started by OUI during 10.1.2.3 Patchset Installation
During OracleAS 10g patchset 10.1.2.3 installation, Oracle Universal Installer may have started some processes from the OracleAS 10.1.2 Oracle Home. Before proceeding further, ensure you shut down any processes started by the Installer.
Export ORACLE_HOME=<10.1.2 Oracle Home>
$ORACLE_HOME/opmn/bin/opmnctl stopall
$ORACLE_HOME/bin/emctl stop iasconsole
Do not source the environment using any of the Applications environment files.
6) Install the Additional Patches
Use opatch to install each of the additional patches you downloaded earlier, in the same order as in the table, and following the instructions in the accompanying README. Use opatch version 1.0.0.0.57 or higher. You can download the latest version of opatch via patch 6880880.
7) Download and apply 10.1.0.5 RSF fixes
Note: You must select 10.1.0.5 from the Release dropdown list before downloading.
Download patch 3559326 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5394728 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5261796 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
8) Apply the Oracle E-Business Suite Release 12 Interoperability Patch
Before applying the patch, you must enable Maintenance Mode:
1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 1 (Enable Maintenance Mode)
Step 3.7.2: Apply the Oracle E-Business Suite/Forms Interoperability Patch
Apply the patch driver from the Interoperability patch using AutoPatch.
Step 3.7.3: Disable Maintenance Mode from adadmin
After applying the patch, disable Maintenance Mode:
1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 2 (Disable Maintenance Mode)
9) Redeploy the new Forms EAR file
Redeploy the formsapp.ear file by following the instructions given in OracleMetaLink Note 397174.1, "Deploying a New Forms EAR File in Oracle Applications Release 12".
10) Post-Installation Steps
Rebuild Forms and Reports executables
cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk install
cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install
Regenerate JAR files
Verify the JAR files have been rebuilt
Verify that the fndforms.jar & fndewt.jar JAR files have been rebuilt by checking the timestamp for both files in $OA_JAVA/oracle/apps/fnd/jar directory.
Regenerate the JAR Files (if required)
If the timestamp is not current but the installation steps completed successfully, run the AD Administration Utility to regenerate the JAR files:
1. Run the AD Administration Utility (adadmin)
2. Select Generate Applications Files
3. Generate Product JAR Files
Note: Do not opt to force the regeneration of all JAR files.
Verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking their timestamps again.
11) Start All Services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
Verify the Upgrade
Log on to E-Business Suite as any user, launch any form, select "About Applications" from the Help menu, and confirm that the Forms version (under Forms Server) shows as 10.1.2.3.0.
Run Forms compiler
Run the following command to display various component versions, and confirm that the Forms version shows as 10.1.2.3.0. This command requires the DISPLAY environment variable to be set correctly.
$ORACLE_HOME/bin/frmcmp help=y
Metalink Note ID Refered : ID 437878.1
1) Download latest certified OracleAS patchset and Oracle E-Business Suite Interoperability Patch
Download the latest certified OracleAS 10g patchset. In addition, you will need the E-Business Suite/Forms Interoperability patch corresponding to the OracleAS 10g patchset you are installing. The number for the interoperability patch is given in the right-hand column.
Oracle Application Server 10g Oracle Application Server 10g Patchset Oracle Forms Oracle Reports Oracle E-Business Suite Interoperability Patch
OracleAS Patchset 10.1.2.3.0 5983622 10.1.2.3.0 10.1.2.3.0 7120543
2) Download Additional Patches
Platform Nature of Patch Patch
Linux Forms - Java Patch 9044638
Linux Forms - Platform-Specific 7121788
Linux Forms - C Patch 6857221
Linux 4407272
Linux 4526825
Linux 7329300
Linux 8557019
Linux Reports - Platform-Specific 5705981
Linux 7230832
Linux Reports - C Patch 7016961
Linux 5917053
Linux 6371228
Linux Reports - Java Patch 7140392
Linux Reports - Generic Patch 8300196
3) Stop All Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps
4) Back Up OracleAS 10.1.2 ORACLE_HOME and Inventory folder
Oracle recommends that you make a backup of your existing environment before you install Oracle Application Server 10g Release 2 patchset 3 (10.1.2.3.0).This will enable you to restore your original environment if you encounter a problem with application of the patch, or need to remove the patch for some reason.
You are also advised to take a complete backup of the Inventory folder (either global or local) that contains the OracleAS 10.1.2 ORACLE_HOME inventory details.
5) Install the Application Server Latest Certified Patchset (10.1.2.3.0)
The steps in this section will install the OracleAS 10g 10.1.2.3.0 patchset on all application tier nodes hosting Forms and Reports services.
Note: All references to "ORACLE_HOME" refer to the OracleAS 10.1.2 Oracle Home that contains the Forms and Reports 10g installation. Ensure that you are using same oraInventory that was created during Oracle E-Business Suite Release 12 installation.
Unzip the Patchset
Unzip patch 5983622 into a temporary directory.
Apply OracleAS 10g Release 2 Patchset 3 (10.1.2.3.0)
The following steps will apply the patchset.
Execute runInstaller
Execute runInstaller (UNIX) and choose "Oracle Application Server and Developer Suite 10g R2 Software Update 10.1.2.3.0" as the install option.
On Linux and UNIX:
If you have a Global Inventory, invoke the Installer by changing to the appropriate directory and running the command:
$ ./runInstaller
If you have a Local Inventory, invoke the Installer by changing to the appropriate directory running the command:
$ ./runInstaller -invPtrLoc <1012_ORACLE_HOME>/oraInst.loc
Supply the ias_admin default password
Supply the ias_admin default password 'secret' when prompted.
Note: You may see failures while executing OC4J configuration assistant as part of post install configuration steps. Please select Next to skip the configuration assistant. This action will skip the remaining configuration assistants, which is expected for Oracle E-Business Suite customers.
Shut Down Services Started by OUI during 10.1.2.3 Patchset Installation
During OracleAS 10g patchset 10.1.2.3 installation, Oracle Universal Installer may have started some processes from the OracleAS 10.1.2 Oracle Home. Before proceeding further, ensure you shut down any processes started by the Installer.
Export ORACLE_HOME=<10.1.2 Oracle Home>
$ORACLE_HOME/opmn/bin/opmnctl stopall
$ORACLE_HOME/bin/emctl stop iasconsole
Do not source the environment using any of the Applications environment files.
6) Install the Additional Patches
Use opatch to install each of the additional patches you downloaded earlier, in the same order as in the table, and following the instructions in the accompanying README. Use opatch version 1.0.0.0.57 or higher. You can download the latest version of opatch via patch 6880880.
7) Download and apply 10.1.0.5 RSF fixes
Note: You must select 10.1.0.5 from the Release dropdown list before downloading.
Download patch 3559326 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5394728 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5261796 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
8) Apply the Oracle E-Business Suite Release 12 Interoperability Patch
Before applying the patch, you must enable Maintenance Mode:
1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 1 (Enable Maintenance Mode)
Step 3.7.2: Apply the Oracle E-Business Suite/Forms Interoperability Patch
Apply the patch driver from the Interoperability patch using AutoPatch.
Step 3.7.3: Disable Maintenance Mode from adadmin
After applying the patch, disable Maintenance Mode:
1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 2 (Disable Maintenance Mode)
9) Redeploy the new Forms EAR file
Redeploy the formsapp.ear file by following the instructions given in OracleMetaLink Note 397174.1, "Deploying a New Forms EAR File in Oracle Applications Release 12".
10) Post-Installation Steps
Rebuild Forms and Reports executables
cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk install
cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install
Regenerate JAR files
Verify the JAR files have been rebuilt
Verify that the fndforms.jar & fndewt.jar JAR files have been rebuilt by checking the timestamp for both files in $OA_JAVA/oracle/apps/fnd/jar directory.
Regenerate the JAR Files (if required)
If the timestamp is not current but the installation steps completed successfully, run the AD Administration Utility to regenerate the JAR files:
1. Run the AD Administration Utility (adadmin)
2. Select Generate Applications Files
3. Generate Product JAR Files
Note: Do not opt to force the regeneration of all JAR files.
Verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking their timestamps again.
11) Start All Services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
Verify the Upgrade
Log on to E-Business Suite as any user, launch any form, select "About Applications" from the Help menu, and confirm that the Forms version (under Forms Server) shows as 10.1.2.3.0.
Run Forms compiler
Run the following command to display various component versions, and confirm that the Forms version shows as 10.1.2.3.0. This command requires the DISPLAY environment variable to be set correctly.
$ORACLE_HOME/bin/frmcmp help=y
Upgrade OracleAS 10g Release 3 (10.1.3.3.0) to Patchset 5 (10.1.3.5)
Upgrade OracleAS 10g Release 3 (10.1.3.3.0) to Patchset 5 (10.1.3.5)
Metalink Note ID Refered : ID 454811.1
1) Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)
Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084 from Metalink
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 Metalink
3) Stop All Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps
4) Take a Backup of the Oracle E-Business Suite Release 12 10.1.3 Oracle Home and Inventory
System administrators are strongly advised to take complete backup of the 10.1.3 Oracle Home and the Global Inventory before
executing these procedures.
In the event of failure, you can restore the Oracle Home and the Inventory before attempting to re-apply the patchset.
Global Inventory on all LINUX platforms are specified in file 'oraInst.loc' which should be present in /etc
If file 'oraInst.loc' does not exist at the above default location, it gets created under each ORACLE_HOME.
Check the value of "inventory_loc" in file oraInst.loc for the global inventory location.
5) Apply OracleAS 10g Release 3 (10.1.3.0) Patch Set 5 (10.1.3.5.0)
6) Set Your Environment to 10.1.3 ORACLE_HOME
Log in to the application tier as the OS user who owns the application tier file system.
Navigate to the /ora/10.1.3 and source the .env file to set your 10.1.3 ORACLE_HOME.
7) Apply OracleAS 10.1.3.5 Patch Set
1. Unzip patch 8626084 (OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into a temporary directory ( )
2. Unzip patch 8920270 (required patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into alternative temp directory.
Follow the patch readme (perform steps 1, 2 and 3 only), then:
3. Change directory to /Disk1
4. Execute runInstaller
On UNIX and Linux:
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
Note: During the Installation, OUI may display the following warning messages.
1) Ensure that all OC4J instances are up and running prior to applying this patch.
2) At this time, Oracle Application Tier will be shut down. There will be a brief pause in the installer when the application tier processes are stopped.
Click the 'OK' button to proceed with the installation.
"Provide the Release 12 10.1.3 Oracle Home Name and Path as a value in 'Name' and 'Path' field of 'Destination region'. If you set the Release 12 10.1.3 Oracle Home properly, you will see Oracle Home name in the drop down list of 'Name' field.
Enter the user password for the OracleAS 10g 10.1.3 instance that is being patched. If you are upgrading from OracleAS 10g 10.1.3.0, the default password is 'secret'. Otherwise the default password is 'oafm', if it was not changed after Release 12 installation. Proceed to the end of the installation."
8) Shut Down Any Services Started by OUI during 10.1.3.5 Patch Set Installation
During 10.1.3.5 patchset installation, Oracle Universal Installer may have started some process from the OracleAS Oracle Home.
Before proceeding further, shut down any processes started by the installer.
9) Run AutoConfig
Run Autoconfig on Application Tier Node Only
10) Post-Installation Tasks (Regenerate appsborg.zip and appsborg2.zip files)
Run adadmin & choose Generate product JAR files (with NO force option) to generate the appsborg.zip and appsborg2.zip files.
11) Verify the OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5) Installation
To check the status of the patchset install, perform the following steps:
1. Invoke runInstaller from <1013_ORACLE_HOME>/oui/bin (on UNIX and Linux) or setup.exe (on Windows).
2. Click on Installed Products.
3. Select 10.1.3 Oracle Home and expand the tree. You should see Oracle Application Server Patchset 10.1.3.5 patch in the list.
Alternatively:
1. Run the command 'opatch lsinventory -detail'
2. Look for 'Oracle Application Server PatchSet' in the 'Product' column. 'Version' should show 10.1.3.5.0.
12) Start Application tier services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
Metalink Note ID Refered : ID 454811.1
1) Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)
Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084 from Metalink
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 Metalink
3) Stop All Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps
4) Take a Backup of the Oracle E-Business Suite Release 12 10.1.3 Oracle Home and Inventory
System administrators are strongly advised to take complete backup of the 10.1.3 Oracle Home and the Global Inventory before
executing these procedures.
In the event of failure, you can restore the Oracle Home and the Inventory before attempting to re-apply the patchset.
Global Inventory on all LINUX platforms are specified in file 'oraInst.loc' which should be present in /etc
If file 'oraInst.loc' does not exist at the above default location, it gets created under each ORACLE_HOME.
Check the value of "inventory_loc" in file oraInst.loc for the global inventory location.
5) Apply OracleAS 10g Release 3 (10.1.3.0) Patch Set 5 (10.1.3.5.0)
6) Set Your Environment to 10.1.3 ORACLE_HOME
Log in to the application tier as the OS user who owns the application tier file system.
Navigate to the /ora/10.1.3 and source the .env file to set your 10.1.3 ORACLE_HOME.
7) Apply OracleAS 10.1.3.5 Patch Set
1. Unzip patch 8626084 (OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into a temporary directory ( )
2. Unzip patch 8920270 (required patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into alternative temp directory.
Follow the patch readme (perform steps 1, 2 and 3 only), then:
3. Change directory to /Disk1
4. Execute runInstaller
On UNIX and Linux:
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
Note: During the Installation, OUI may display the following warning messages.
1) Ensure that all OC4J instances are up and running prior to applying this patch.
2) At this time, Oracle Application Tier will be shut down. There will be a brief pause in the installer when the application tier processes are stopped.
Click the 'OK' button to proceed with the installation.
"Provide the Release 12 10.1.3 Oracle Home Name and Path as a value in 'Name' and 'Path' field of 'Destination region'. If you set the Release 12 10.1.3 Oracle Home properly, you will see Oracle Home name in the drop down list of 'Name' field.
Enter the
8) Shut Down Any Services Started by OUI during 10.1.3.5 Patch Set Installation
During 10.1.3.5 patchset installation, Oracle Universal Installer may have started some process from the OracleAS Oracle Home.
Before proceeding further, shut down any processes started by the installer.
9) Run AutoConfig
Run Autoconfig on Application Tier Node Only
10) Post-Installation Tasks (Regenerate appsborg.zip and appsborg2.zip files)
Run adadmin & choose Generate product JAR files (with NO force option) to generate the appsborg.zip and appsborg2.zip files.
11) Verify the OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5) Installation
To check the status of the patchset install, perform the following steps:
1. Invoke runInstaller from <1013_ORACLE_HOME>/oui/bin (on UNIX and Linux) or setup.exe (on Windows).
2. Click on Installed Products.
3. Select 10.1.3 Oracle Home and expand the tree. You should see Oracle Application Server Patchset 10.1.3.5 patch in the list.
Alternatively:
1. Run the command 'opatch lsinventory -detail'
2. Look for 'Oracle Application Server PatchSet' in the 'Product' column. 'Version' should show 10.1.3.5.0.
12) Start Application tier services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
Tuesday, 21 April 2009
Upgrade EBS database 9.2.0.6 to 10.2.0.4
1 Latest Autoconfig patch 6372396
2 10g Operability patch 4653225
3 Developer 6i - Patchset 17
4 Installation of 10g software
5 Installation of 10g companion products
6 Installation of patchset 10.2.0.4 ( 6810189)
7 Run 10g preupgrade check file in 9i database ( utlu102i.sql ) and (utltzuv2.sql)
8 Fix the things as suggested by script ulu102i.sql
9 gather dictionary stats
10 Analyze dictionary objects for possible corruption
11 Create a list of invalid objects after running utlrp
12 Create a list of users having connect role
13 use $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory in 10g home
14 Copy and modify the init.ora file from 9i Oracle home to new 10g Oracle Home
15 Create SYSAUX Tablespace
16 Set environment for the new Database 10g
17 Cold backup of 9i database
18 Start 9i database from 10g Oracle Home in upgrade mode
19 run catupgrd.sql
20 run utlu102s.sql
21 run utlrp.sql
22 Apply the Patch 5005469, to fix the KOREAN_MORPH_LEXER
23 run adgrants.sql
24 run AD_TOP/patch/115/sql/adctxprv.sql as sqlplus apps/pwd @adctxprv.sql manager CTXSYS
25 Implement the changes to CONTEXT_FILE with respect to new Oracle Home
26 run adstats.sql in restrict mode
27 Re-create custom database links.
28 Re-create grants and synonyms.
29 Apply Oracle Receivables patch 5753621.
30 Start the Application Tier.
31 Gather Schema stats with 10% estimate
2 10g Operability patch 4653225
3 Developer 6i - Patchset 17
4 Installation of 10g software
5 Installation of 10g companion products
6 Installation of patchset 10.2.0.4 ( 6810189)
7 Run 10g preupgrade check file in 9i database ( utlu102i.sql ) and (utltzuv2.sql)
8 Fix the things as suggested by script ulu102i.sql
9 gather dictionary stats
10 Analyze dictionary objects for possible corruption
11 Create a list of invalid objects after running utlrp
12 Create a list of users having connect role
13 use $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory in 10g home
14 Copy and modify the init.ora file from 9i Oracle home to new 10g Oracle Home
15 Create SYSAUX Tablespace
16 Set environment for the new Database 10g
17 Cold backup of 9i database
18 Start 9i database from 10g Oracle Home in upgrade mode
19 run catupgrd.sql
20 run utlu102s.sql
21 run utlrp.sql
22 Apply the Patch 5005469, to fix the KOREAN_MORPH_LEXER
23 run adgrants.sql
24 run AD_TOP/patch/115/sql/adctxprv.sql as sqlplus apps/pwd @adctxprv.sql manager CTXSYS
25 Implement the changes to CONTEXT_FILE with respect to new Oracle Home
26 run adstats.sql in restrict mode
27 Re-create custom database links.
28 Re-create grants and synonyms.
29 Apply Oracle Receivables patch 5753621.
30 Start the Application Tier.
31 Gather Schema stats with 10% estimate
Upgrade Rel 10.2.0.3 – 12.0.4 Oracle Applications database to version 10.2.0.4
Upgrade Rel 10.2.0.3 – 12.0.4 Oracle Applications database to version 10.2.0.4
1.) Install Oracle database patch 10.2.0.4 (Time: 1 hour)
a. Create 10.2 stage directory, cd to Disk1 directory and execute ./runInstaller.
2.) Apply database patches to 10.2.0.4 home (Time: 1 hour)
a. 4247037
b. 6870937
c. 7014646
d. 8362683
e. 7411865
f. 7038750 --- only available for 64 bit OS
g. 5386204
h. 7197637
i. 7496435 – all the patches in this bundle patch are covered by 8362683
( Please check the below patches are not covered in 8362683 if not pl apply)
Note: - patch #7278117 which is a part of 8362683 was giving a following error while applying. It has a conflict with the patch 7014646. As patch #7014646 is mentioned in the interop doc 454750.1, I chose to install 7014646 over 7278117.
Error:-
The following warnings have occurred during OPatch execution:
1) OUI-67301:
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
7014646 7278117
4) Prepare DB for Upgrade (Time: 20 minutes)
a. Shutdown all application services
b. Verify that 10.2.0.3 database is defined in /var/opt/oracle/oratab file.
Upgrade database {Time: 2 Hrs)
c. Run dbua from 10.2.0 Oracle Home/bin directory.
i. Choose database to be upgraded
ii. Choose not to backup database.
Used catupgrd.sql to upgrade the database because DBUA screen was dead slow and not responding. After that I executed utlrp.sql for compiling the components.
Post Upgrade {Time: 2Hr}
d. Add 10gR3 release specific parameters to the init.ora file and remove obsolete parameters follow the doc 216205.1 -- None required
e. Run changeperm.sh from $ORACLE_HOME/install.
f. Select comp_name,version,status from dba_registry;
In the out put ,status of all components should be Valid. If there is any invalid check the note 565600.1
g. Run autoconfig on db.
h. Copy $APPL_TOP/admin/adstats.sql to $ORACLE_HOME/appsutil/admin directory.
i. Shutdown database and startup in restricted mode and run adstats.sql as sysdba. Then shutdown database again and startup in normal mode.(make sure we have atleast 1.5GB)
j. Start the new database listener.
k. select owner, table_name, stattype_locked from dba_tab_statistics
where stattype_locked is not null
If there are any schemas (which has tables with locked statistics)
other than SYS, SYSTEM execute
the following command:
exec dbms_stats.unlock_schema_stats('');
or exec dbms_stats.unlock_schema_stats ('&name');
l. Run Gather statistics on fixed tables using the below sql
exec dbms_stats.gather_fixed_objects_stats;
m. Run adadmin and run program “recreate grants and synonyms”.
n. Startup application services and test login.
o. Run Gather Schema Stats (timings are exclusive of this step )
References: Metalink Doc. 454750.1 and For issues 555579.1
1.) Install Oracle database patch 10.2.0.4 (Time: 1 hour)
a. Create 10.2 stage directory, cd to Disk1 directory and execute ./runInstaller.
2.) Apply database patches to 10.2.0.4 home (Time: 1 hour)
a. 4247037
b. 6870937
c. 7014646
d. 8362683
e. 7411865
f. 7038750 --- only available for 64 bit OS
g. 5386204
h. 7197637
i. 7496435 – all the patches in this bundle patch are covered by 8362683
( Please check the below patches are not covered in 8362683 if not pl apply)
Note: - patch #7278117 which is a part of 8362683 was giving a following error while applying. It has a conflict with the patch 7014646. As patch #7014646 is mentioned in the interop doc 454750.1, I chose to install 7014646 over 7278117.
Error:-
The following warnings have occurred during OPatch execution:
1) OUI-67301:
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
7014646 7278117
4) Prepare DB for Upgrade (Time: 20 minutes)
a. Shutdown all application services
b. Verify that 10.2.0.3 database is defined in /var/opt/oracle/oratab file.
Upgrade database {Time: 2 Hrs)
c. Run dbua from 10.2.0 Oracle Home/bin directory.
i. Choose database to be upgraded
ii. Choose not to backup database.
Used catupgrd.sql to upgrade the database because DBUA screen was dead slow and not responding. After that I executed utlrp.sql for compiling the components.
Post Upgrade {Time: 2Hr}
d. Add 10gR3 release specific parameters to the init.ora file and remove obsolete parameters follow the doc 216205.1 -- None required
e. Run changeperm.sh from $ORACLE_HOME/install.
f. Select comp_name,version,status from dba_registry;
In the out put ,status of all components should be Valid. If there is any invalid check the note 565600.1
g. Run autoconfig on db.
h. Copy $APPL_TOP/admin/adstats.sql to $ORACLE_HOME/appsutil/admin directory.
i. Shutdown database and startup in restricted mode and run adstats.sql as sysdba. Then shutdown database again and startup in normal mode.(make sure we have atleast 1.5GB)
j. Start the new database listener.
k. select owner, table_name, stattype_locked from dba_tab_statistics
where stattype_locked is not null
If there are any schemas (which has tables with locked statistics)
other than SYS, SYSTEM execute
the following command:
exec dbms_stats.unlock_schema_stats('
or exec dbms_stats.unlock_schema_stats ('&name');
l. Run Gather statistics on fixed tables using the below sql
exec dbms_stats.gather_fixed_objects_stats;
m. Run adadmin and run program “recreate grants and synonyms”.
n. Startup application services and test login.
o. Run Gather Schema Stats (timings are exclusive of this step )
References: Metalink Doc. 454750.1 and For issues 555579.1
Tuesday, 9 September 2008
De-Support of RAW devices in Release 12G.
METALINK Note:578455.1
Oracle Server - Enterprise Edition - Version: 12.0 to 12.0
Information in this document applies to any platform.
Oracle Database Server 12g (Not yet released)
De-Support of Raw
This document is to announce the de-support of raw devices in a future Oracle 12 g release. This means customers can no longer keep their datafiles, OCR or Voting disks on raw devices in Oracle 12g.
Oracle Server - Enterprise Edition - Version: 12.0 to 12.0
Information in this document applies to any platform.
Oracle Database Server 12g (Not yet released)
De-Support of Raw
This document is to announce the de-support of raw devices in a future Oracle 12 g release. This means customers can no longer keep their datafiles, OCR or Voting disks on raw devices in Oracle 12g.
Subscribe to:
Posts (Atom)