11i 10G DB Upgrade

1
(No Transcript)
2

• Upgrade 11i to 10G DB
• Note Base on Red Hat Enterprise Linux 4.0
• Presented by Milton Estrada

3
Introduction

• Overview
• Hardware Requirements
• OS Requirements
• Network Requirements
• Upgrade Steps
• System Validation
• Best practices for 11i DB Upgrades
• QA

4
Hardware Requirements

• RAM and Swap Space
• grep MemTotal /proc/meminfo
• grep SwapTotal /proc/meminfo
• /tmp Space
• df k /tmp
• Space for Software Files
• At least 1.5GB of Oracle 10G RDBMS
• CPU Requirements

5
OS Requirements

• OS Version
• cat /etc/issue
• Kernel Version
• uname -r
• OS Packages
• rpm q package_name

6
Network Requirements

• Configuring Name Resolution
• cat /etc/nsswitch.conf grep hosts
• hostname
• domainname
• cat /etc/hosts grep eval hostname
• Installing on Multihomed Computers
• ORACLE_HOSTNAMEsomehost.us.acme.com
• export ORACLE_HOSTNAME

7
Upgrade Steps (ML ID 282038.1 )

• Apply 10g interoperability patch 4332078 for
  11.5.10
• Install 10.1.0.3 RDBMS Software
• Install Oracle Database 10g Products from the 10g
  Companion CD
• Upgrade OUI version to 2.2 by applying patch
  4017155 to 10G OH
• Perform 10.1.0.4 patch set pre-installation tasks
• Set ORACLE_HOME (OH) to 10G Directory
• Make sure that SID is set accordantly
• Stop APPS Services
• Shutdown Oracle Database

8
Upgrade Steps (ML ID 282038.1 )

• Perform 10.1.0.4 patch set installation tasks
• Create nls/data/9idata directory
• Apply Oracle Patching Tool (OPatch) 2617419 to
  10G OH
• Apply MLR for certification of 10.1.0.4 DB with
  11i patch 4359526 to 10G OH
• Unset the TNS_ADMIN environment variable
• Upgrade the database instance by running dbua
  program
• You can ignore RAC and Spatial errors during
  upgrade

9
DBUA
10
DBUA
11
DBUA
12
DBUA
13
DBUA
14
DBUA
15
DBUA
16
DBUA
17
DBUA
18
DBUA
19
Upgrade Steps (ML ID 282038.1 )

• Increase size of TEMP tablespace to at least 4GB
• Gather statistics for SYS schema
• Copy APPL_TOP/admin/adstats.sql to
  OH/rdbms/admin
• Connect to SQLPLUS as sysdba
• Shutdown DB normal
• Startup DB restrict
• Execute adstats.sql
• Shutdown normal
• Startup db again
• Start the new database listener
• Copy 9i TNS_ADMIN admin directory to 10G OH
• Update listener.ora, tnsnames.ora and sqlnet.ora
  files
• Start listener

20
Upgrade Steps (ML ID 282038.1 )

• Run adgrants.sql
• copy APPL_TOP/admin/adgrants.sql to
  OH/rdbms/admin
• run sqlplus "/ as sysdba" _at_adgrants.sql APPLSYS
• Implement and run AutoConfig
• Run as applmgr perl AD_TOP/bin/admkappsutil.pl
• Copy appsutil.zip to OH
• As Oracle User cd OH and unzip -o appsutil.zip
• Copy from 9i OH .env file and .xml file
• Update .env and .xml files to reflect new OH
• Source environment
• Cd to OH/appsutil/bin
• Run adbldxml.sh tierdb appsuserapps
  appspasswdapps
• Run adconfig.sh contextfile.xml appspassapps

21
Upgrade Steps (ML ID 282038.1 )

• Re-create grants and synonyms
• Login as applmgr user
• Use adadmin to re-create grants and synonyms
• Create PFILE out of SPFILE
• Connect to DB as SYSDBA
• Execute create pfile from spfile'spfileSID.ora'
  
• Update initVIS.ora file to reflect new
  environment
• Rename or delete SPFILE
• Bounce DB
• Remove Listener security from sqlnet.ora file
• Compile remaining invalid objects using adadmin
• Move or delete 9i OH
• Start Application Services

22
System Validation

• Test Login into Apps
• Make sure CC Managers started Normal
• Submit a test CC request
• Login into OAM and check OWF Services
• Have Users Test System

23
Best practices for 11i DB Upgrades

• Take a Full Backup Before Upgrade
• Read latest 11i DB Interoperability Notes
• Crete Patch Plan
• Make sure to analyze all pre-reqs
• Download and extract all required patches
• Perform upgrade on Test System
• Make sure to time upgrade
• Resolve all issues before go live
• Have users test and signoff upgrade

24

• QA

25
References

• Oracle Applications Release 11i with Oracle
  Database 10g Release 1 (10.1.0)
• ML Note ID 282038.1
• Oracle Database Installation Guide 10g Release 2
  (10.2) for Linux x86
• Part B15660-01
• Oracle Technology Network (OTN)

26
More Info

• Other good references that I use are
• http//metalink.oracle.com
• http//oraclepartnernetwork.oracle.com
• http//otn.oracle.com
• http//tahiti.oracle.com
• http//technet.oracle.com
• http//www.google.com
• http//www.ioug.org
• http//www.orafaq.org
• http//www.tusc.com
• http//www.odtug.com

27
TUSC Contact Information
Milton Estrada (TUSC Senior Consultant)
estradam_at_tusc.com George Frederick (TUSC Sales
Executive) frederickg_at_tusc.com 630-960-2909 TUSC
377 E. Butterfield Road Suite 100 Lombard, IL
60148 www.tusc.com