Manual upgrade Oracle Database from 9i to 11g with bundle patch and DBAtool (For SAP)

** Myself

Objective: Manual Upgrade Oracle Database from 9.2.0.4 to 11.2.0.3

Preparation of 9i for Upgrade 11g
Up oracle9i timezone patch for upgrade to oracle 11g
Command Detail
cd /sapbackup/UPECC6/ORABUNDLE/5878965
/oracle/SOD/920*/OPatch/opatch apply
Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)
Oracle Home : /oracle/SOD/920_64
Oracle Home Inventory : /oracle/SOD/920_64/inventory
Central Inventory : /oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OUI location : /oracle/SOD/920_64/oui
OUI shared library : /oracle/SOD/920_64/oui/lib/hpunix/liboraInstaller.sl
Java location : /oracle/SOD/920_64/jdk/jre/bin/java
Log file location : /oracle/SOD/920_64/.patch_storage/<patch ID>/*.log
Creating log file "/oracle/SOD/920_64/.patch_storage/5878965/Apply_5878965_10-11-2013_15-26-32.log"
Invoking fuser to check for active processes.
Invoking fuser on "/oracle/SOD/920_64/bin/oracle"
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: lek
Invalid email address.
Email address/User Name: coco@coco.co.th
Provide your My Oracle Support password to receive security updates via your My Oracle Support account.
Password (optional):
Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
[<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specificatio
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /oracle/SOD/920_64)
Is this system ready for updating?
Please respond Y|N >
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /oracle/SOD/920_64)
Is this system ready for updating?
Please respond Y|N >
y
Applying patch 5878965...
Patching copy files...
Inventory is good and does not have any dangling patches.
Updating inventory...
Verifying patch...
Backing up comps.xml ...
OPatch succeeded.gfux031:orasod 1


Step Upgrade Oracle 11g
Extract software to $ORACLE_STAGE/11203/database

Installing Software Oracle 11.2.0.3
$ORACLE_STAGE/11203/database/SAP/RUNINSTALLER

clip_image002
Next
clip_image004
No

Loading