Problem: How do I update CentOS 5.3 to the latest version (CentOS 5.7)?
Solution:
As root user, issue the following commands:
yum makecache yum update yum upgrade kernel yum install yum-utils yum-complete-transaction yum-complete-transaction --cleanup
Problem:
After installing Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86, sourced the 11gR2 environment and attempted to run dbua to upgrade the 11gR1 database. The following error occurred:
[applmgr@centos53server ~]$ dbua # # An unexpected error has been detected by HotSpot Virtual Machine: # # SIGSEGV (0xb) at pc=0x9fdf64d4, pid=3662, tid=3086928080 # # Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode) # Problematic frame: # C [libnnz11.so+0x3c4d4] # # An error report file with more information is saved as hs_err_pid3662.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # Aborted
Solution:
Apply patch p8670579_112010_LINUX.zip.
1. Preparing for the Upgrade
Apply 11i.AD.I
Back up database, Applications, and customizations
Prepare an upgrade plan for customizations
Convert to Multiple Organizations architecture
Review sizes of old and new tablespaces
Review Upgrade Tasks and Apply 11i.AD.I
Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer
Financials and Procurement Tasks
Gather schema statistics for CBO
Back up the database
Run Rapid Install
Migrate or upgrade your database to Oracle 10g Release 2
Port application to Linux servers
2. Upgrading to Release 12
Disable AOL Audit Trail
Migrate database to Oracle10g Release 2
Back up the database
Apply Release 12 AD minipack
Run the American English upgrade patch driver
Run the NLS upgrade patch driver
Apply latest product patches
Synchronize NLS and American English product patches
Back up Oracle Applications
Finish the Upgrade
Configure Applications client software for forms applet (required)
Reapply customizations (conditional)
Integrate custom objects and schemas (conditional)
Finish System Administration Tasks
Complete Workflow Notification Mailer configuration (required)
Complete setup for Oracle XML Gateway (required)
Enable PDF printing (required)
3. Post-upgrade Tasks
Install online help
Update/verify custom responsibilities
Migrate custom development to new technologies
Migrate the CUSTOM library
Copy and re-customize modified scripts or reports
Review user responsibility assignments
Associate organization names with custom Alert definitions
Set operating unit mode for customizations
Assign the Report Manager Data Migration Program to a request group
Run the Data Migration Program
Update Status Monitor URLs
Synchronize Product License and Workflow BES license status
Financials and Procurement Tasks
Additional Tasks
This document shows how to upgrade the 9i database in 11i E-Business Suite to 10g on Linux.
Metalink Reference:
Doc ID: 362203.1 (Subject: Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0))
Section 1: Upgrading an 11i Database to Oracle Database 10g Release 2 (10.2.0)
Ignore steps 1 – 5 in the Metalink document.
Begin at Step 6.
Step 6: Prepare to create the 10.2.0 Oracle home
Download Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
10201_database_linux32.zip (668,734,007 bytes) (cksum – 2737423041)
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html
http://www.oracle.com/technology/documentation/database10gr2.html
http://www.oracle.com/technology/support/metalink/index.html
Step 7: Install the base 10.2.0 software
Install Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
Refer to chapter 3, Oracle Database Installation Guide 10g Release 2 (10.2)
Unzip 10201_database_linux32.zip
Create directory: /u01/oracle/visdb/10.2.0
Ensure OS meets requirements for 10g
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Begin installation (./runInstaller)
Note: You may need to increase the swap file to 4GB before installing 10g.
Step 8: Install Oracle Database 10g Products from the 10g Companion CD
Refer to section 3.5, “Installing Oracle Database 10g Products” in the Oracle Database Companion CD Installation Guide
Unzip 10201_companion_linux32.zip
Ensure OS meets requirements for 10g (should be in place)
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Begin installation (./runInstaller)
Step 9: Perform 10.2.0.4 patch set pre-installation tasks
Oracle® Database Patch Set Notes
10g Release 2 (10.2.0.4) Patch Set 3 for Linux x86
Metalink Doc ID: 316900.1
Download patch 6810189 (p6810189_10204_Linux-x86.zip)
Unzip p6810189_10204_Linux-x86.zip
Ensure OS meets requirements for 10g (should be in place)
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Stop all processes (dbconsole, iSQL*Plus, database listener)
Backup Oracle Inventory, Oracle database, Oracle Home
Begin installation (./runInstaller)
Perform 10.2.0.4 patch set pre-installation tasks
On the database server node, as the owner of the Oracle 10g file system and database instance, unzip and extract the 10.2.0.4 patch set file for your platform. Read the patch set notes (usually README.html). Make sure you thoroughly understand the upgrade and patch set installation process before you begin. Check OracleMetaLink or contact Oracle Support Services to determine any known issues with the patch set and its interoperability with Oracle E-Business Suite.
Perform the tasks in the “Preinstallation Tasks” section of the patch set notes (if they apply to your system).
Step 10: Perform 10.2.0.4 patch set installation tasks
On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in the “Installing the Oracle Database 10g Patch Set Interactively” section of the patch set notes. Make sure that:
The ORACLE_HOME environment variable points to the new 10.2.0 Oracle home.
The PATH environment variable includes $ORACLE_HOME/bin and the directory where the new perl executable is located (usually $ORACLE_HOME/perl/bin).
The LD_LIBRARY_PATH environment variable includes $ORACLE_HOME/lib.
The PERL5LIB environment variable points to the directories where the new perl libraries are located (usually $ORACLE_HOME/perl/lib/<perl version> and $ORACLE_HOME/perl/lib/site_perl/<perl version>)
You use the runInstaller (UNIX/Linux) or the setup.exe executable (Windows) provided in the patch set to run OUI.
Step 11: Create nls/data/9idata directory
Run: perl $ORACLE_HOME/nls/data/old/cr9idata.pl script
Modify set10g.env:
export ORA_NLS10= ORACLE_HOME/nls/data/9idata
Step 12: Apply additional 10.2.0.4 RDBMS patches
Download from Metalink and apply:
6880880 or the latest OPatch version.
6521934
6600051
7496636
7497678
cd $ORACLE_HOME
unzip /u01/patches/p6880880_102000_LINUX.zip
SQL> @ utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 08-30-2007 18:57:10
.
**********************************************************************
Database:
**********************************************************************
–> name: PROD
–> version: 9.2.0.8.0
–> compatible: 9.2.0
–> blocksize: 8192
.
**********************************************************************
Logfiles: [make adjustments in the current environment]
**********************************************************************
–> The existing log files are adequate. No changes are required.
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 7139 MB
–> CTXD tablespace is adequate for the upgrade.
…. minimum required size: 17 MB
–> APPLSYSD tablespace is adequate for the upgrade.
…. minimum required size: 18597 MB
–> CCTD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> ARD tablespace is adequate for the upgrade.
…. minimum required size: 268 MB
–> OKCD tablespace is adequate for the upgrade.
…. minimum required size: 33 MB
–> AMVD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> XNPD tablespace is adequate for the upgrade.
…. minimum required size: 9 MB
–> XDPD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> IEOD tablespace is adequate for the upgrade.
…. minimum required size: 4 MB
–> IBUD tablespace is adequate for the upgrade.
…. minimum required size: 1 MB
–> IEMD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> JTFD tablespace is adequate for the upgrade.
…. minimum required size: 63 MB
–> ASOD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
–> APPS_UNDOTS1 tablespace is adequate for the upgrade.
…. minimum required size: 286 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: –> “streams_pool_size” is not currently defined and needs a value of
at least 50331648
WARNING: –> “session_max_open_files” needs to be increased to at least 20
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
— No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
–> “optimizer_max_permutations”
–> “row_locking”
–> “undo_suppress_errors”
–> “log_archive_start”
–> “max_enabled_roles”
–> “enqueue_resources”
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
–> JServer JAVA Virtual Machine [upgrade] VALID
…The ‘JServer JAVA Virtual Machine’ JAccelerator (NCOMP)
…is required to be installed from the 10g Companion CD.
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [install]
–> Real Application Clusters [upgrade] INVALID
–> Oracle interMedia [upgrade] VALID
…The ‘Oracle interMedia Image Accelerator’ is
…required to be installed from the 10g Companion CD.
–> Spatial [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: –> Passwords exist in some database links.
…. Passwords will be encrypted during the upgrade.
…. Downgrade of database links with passwords is not supported.
WARNING: –> Deprecated CONNECT role granted to some user/roles.
…. CONNECT role after upgrade has only CREATE SESSION privilege.
WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 10g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS
…. CTXSYS
…. ORDSYS
…. MDSYS
WARNING: –> Database contains INVALID objects prior to upgrade.
…. USER APPS has 4 INVALID objects.
…. USER DISCOVERER has 1 INVALID objects.
…. USER PERFSTAT has 1 INVALID objects.
…. USER SPOTLIGHT has 2 INVALID objects.
…. USER SYS has 5 INVALID objects.
…. USER VTAS_I3_ORCL has 40 INVALID objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
–> New “SYSAUX” tablespace
…. minimum required size for database upgrade: 500 MB
.
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> spool off
| Step No. | Patch Number | Type of Patch | Patch Name | Date Applied | Start Time |
End Time |
Time Taken (One Tier) |
Comment | Node Applied |
| Patches Applied June-July, 2007 | |||||||||
| 15/06/2007 10:58 | 03/07/2007 2:24 | 17 days 15:25 hours | Total time taken: 17 days 15 hours | ||||||
| Enable Maintenance Mode | |||||||||
| Shut down Oracle services on application and database nodes | |||||||||
| 1 | 4238286 | ONE-OFF PATCH | TUMS-MP 11.5.10: TUMS UTILITY FOR THE 11.5.10 MAINTENANCE PACK | Fri 15-Jun-07 | 10:58:53 | 11:03:13 | 0 days 0:04 hours | ||
| 2 | 4712852 | MINI PACK | Minipack 11i.AD.I.4 | Fri 15-Jun-07 | 12:25:18 | 12:50:59 | 0 days 0:25 hours | GHL1TESTDATA | |
| 3 | 5107107 | ROLLUP PATCH | TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH N (AUGUST 2006) | Fri 15-Jun-07 | 15:32:19 | 15:49:50 | 0 days 0:17 hours | GHL1TESTDATA | |
| 4 | 4318672 | ONE-OFF PATCH | 11.5.10.2 Technology Stack Validation Patch (Revision 1 July, 2005) | Fri 15-Jun-07 | 17:02:39 | 17:06:37 | 0 days 0:03 hours | ||
| 5 | 4139957 | INTEROP PATCH | Interop Patch For 11.5.10 TechStack Component Only Install | Sat 16-Jun-07 | 17:43:42 | 21:06:43 | 0 days 3:23 hours | ||
| 6 | 4888294 | INTEROP PATCH | APPLICATIONS INTEROPERABILITY PATCH FOR DEVELOPER 6I PATCH 18* | Sun -Jun-07 | 16:42:33 | 16:47:43 | 0 days 0:05 hours | ||
| 7 | 5529008 | SUPPORT PACK | DIAGNOSTICS SUPPORT PACK NOVEMBER 2006 with Oracle Diagnostics 2.4 RUP A | Sat 23-Jun-07 | 8:23:58 | 8:39:17 | 0 days 0:15 hours | ||
| 8 | 3480000 | MAINTENANCE PACK | ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK | Sat 30-Jun-07 | 15:25:16 | 2:24:34 | 2 days 10:59 hours | Started: Sat Jun 30 2007 15:25:16 Completed: Tue Jul 03 2007 02:24:34 |
|
| 9 | 3275245 | ONE-OFF PATCH | 11.5.10 ONLINE HELP CONSOLIDATED PATCH | Thu 05-Jul-07 | 12:19:33 | 1:18:37 | 0 days 12:59 hours | ||
| 10 | 5117525 | INTEROP PATCH | APPLICATIONS INTEROPERABILITY PATCH FOR JINITIATOR 1.3.1.x | Sat 07-Jul-07 | 19:57:17 | 20:06:05 | 0 days 0:08 hours | ||
| 11 | 5759055 | ROLLUP PATCH | TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH P (MAR/APR 2007) | Sun 08-Jul-07 | 19:22:20 | 19:38:08 | 0 days 0:15 hours | ||
| 12 | 4653225 | INTEROP PATCH | 11.5.10 INTEROP PATCH FOR 10GR2 | Sun 08-Jul-07 | 20:18:57 | 20:41:48 | 0 days 0:22 hours | ||
| 13 | 5753621 | ONE-OFF PATCH | ONE-OFF REQUEST ON TOP OF 11.5.9 CU2 FOR BUG 5525015 | Fri 13-Jul-07 | 17:04:06 | 17:11:36 | 0 days 0:07 hours | ||
| 14 | 3636980 | NEW PRODUCT | Support Diagnostics (IZU) patch for AD Splice | Mon 23-Jul-07 | 8:15:44 | 8:19:28 | 0 days 0:03 hours | ||
| 15 | 2838093 | ONE-OFF PATCH | ONE-OFF FIXES FOR XSU 1.2.1 & XML PARSER FOR PL/SQL 1.0.2 FOR APPLICATIONS | Sat 28-Jul-07 | 11:36:10 | 11:38:47 | 0 days 0:02 hours | C driver | |
| 16 | 2838093 | ONE-OFF PATCH | ONE-OFF FIXES FOR XSU 1.2.1 & XML PARSER FOR PL/SQL 1.0.2 FOR APPLICATIONS | Sat 28-Jul-07 | 11:43:01 | 11:45:18 | 0 days 0:02 hours | D driver | |
| 17 | 4464099 | ROLLUP PATCH | FUNDS CHECKER ROLLUP PATCH : STANDALONE FOR BASE11i OR ANY MAINTENANCE PACK | Sat 28-Jul-07 | 12:01:07 | 12:07:34 | 0 days 0:06 hours | ||
| 18 | 3180164 | UPDATE APPLPROD.TXT TO ADD NEW PRODUCTS FOR 11.5.10 MAINTENANCE PACK | Sat 28-Jul-07 | 16:46:28 | 17:03:32 | 0 days 0:17 hours | |||
This documentation shows how to upgrade Oracle Applications RDBMS version 8.1.7 to 9.2.0.
Step 1: Go to Metalink and order or download the three CDs for 9.2.0.1, for the correct platform
Step 2: Shutdown the application tier services and the database and listener services.
Step 3: The current RDBMS top is proddb/8.1.7. Create a new RDBMS top directory:
mkdir /raid01/oratest/oracle/proddb/9.2.0
Step 4: Set the following environment variables:
ORACLE_HOME=/raid01/oratest/oracle/proddb/9.2.0
ORACLE_SID=TEST
Step 5: Ensure that any TNSLSNR variables are unset.
Step 6: If the installation was previously cancelled half-way, deinstall the installed products and/or delete the files in 9.2.0:
cd /raid01/oratest/oracle/proddb/9.2.0
rm –rf *
Step 7: When installing, use the following values:
Destination Name: TEST_920
Destination Path: /raid01/oratest/oracle/proddb/9.2.0
Begin installation.
Recent Comments