Saturday, September 24, 2011

Upgrade - Oracle Database 11.2.0.2 to 11.2.0.3

I saw some tweet...#Oracle 11.2.0.3 patchset(10404530) is available.
Wow!!! time to patch database again. It has only for Linux x86 and x86-64 now. You can download, install and upgrade your database. You can review Oracle Database 11g Release 2 (11.2.0.3) New Features as well.

I just downloaded, installed and upgraded (dbua) my database on virtualbox. (Linux x86)
$ ls p10404530_112030_LINUX_*
p10404530_112030_LINUX_1of7.zip p10404530_112030_LINUX_2of7.zip
Oracle Database software uses 2 files (1 and 2). then install and upgraded database
SQL> select name from v$database;

NAME
---------
ORCL

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

$ cat /etc/oratab
orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N
- Installation (silent mode)
$ ./runInstaller -silent -ignoreSysPrereqs -ignorePrereq -ignoreInternalDriverError -responseFile /u01/SRC/database/response/db_install.rsp ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2 ORACLE_HOME_NAME=OraDbHome2 oracle.install.option=INSTALL_DB_SWONLY oracle.install.db.InstallEdition=EE oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oper DECLINE_SECURITY_UPDATES=true -ignoreInternalDriverError
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 7684 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3095 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-09-23_09-22-33PM. Please wait ...
/u01/app/oraInventory/logs/installActions2011-09-23_09-22-33PM.log

As a root user, execute the following script(s):
1. /u01/app/oracle/product/11.2.0/dbhome_2/root.sh

$ su -
Password:
# /u01/app/oracle/product/11.2.0/dbhome_2/root.sh
Check /u01/app/oracle/product/11.2.0/dbhome_2/install/root_mytest_2011-09-23_21-39-25.log for the output of root script

# cat /u01/app/oracle/product/11.2.0/dbhome_2/install/root_mytest_2011-09-23_21-39-25.log
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_2
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
- Upgraded Oracle Database (silent mode)
$ id
uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba),1002(oper)

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2
$ export PATH=$ORACLE_HOME/bin:$PATH
$ type dbua
dbua is /u01/app/oracle/product/11.2.0/dbhome_2/bin/dbua
$ dbua -silent -sid orcl
Log files for the upgrade operation are located at: /u01/app/oracle/cfgtoollogs/dbua/orcl/upgrade1
Performing Pre Upgrade
1% complete
7% complete
Upgrading Oracle Server
8% complete
9% complete
10% complete
10% complete
11% complete
12% complete
13% complete
13% complete
14% complete
15% complete
16% complete
16% complete
17% complete
18% complete
19% complete
20% complete
20% complete
21% complete
22% complete
23% complete
23% complete
24% complete
25% complete
26% complete
Upgrading JServer JAVA Virtual Machine
27% complete
28% complete
29% complete
30% complete
Upgrading Oracle XDK for Java
31% complete
32% complete
Upgrading OLAP Analytic Workspace
33% complete
Upgrading OLAP Catalog
35% complete
36% complete
36% complete
37% complete
38% complete
Upgrading EM Repository
40% complete
40% complete
41% complete
42% complete
43% complete
43% complete
44% complete
45% complete
46% complete
46% complete
47% complete
48% complete
49% complete
50% complete
50% complete
51% complete
52% complete
53% complete
53% complete
54% complete
55% complete
56% complete
56% complete
57% complete
58% complete
Upgrading Oracle Text
60% complete
60% complete
61% complete
62% complete
63% complete
63% complete
Upgrading Oracle XML Database
65% complete
66% complete
66% complete
67% complete
Upgrading Oracle Java Packages
69% complete
70% complete
Upgrading Oracle interMedia
71% complete
72% complete
73% complete
73% complete
74% complete
Upgrading Spatial
76% complete
76% complete
77% complete
78% complete
79% complete
80% complete
80% complete
81% complete
82% complete
83% complete
83% complete
84% complete
Upgrading Oracle Workspace Manager
Upgrading Expression Filter
Upgrading Rule Manager
Upgrading Oracle Application Express
Upgrading Oracle OLAP API
Performing Post Upgrade
85% complete
86% complete
92% complete
Generating Summary
Database upgrade has been completed successfully, and the database is ready to use.
100% complete
Check the log file "/u01/app/oracle/cfgtoollogs/dbua/logs/silent.log" for upgrade details.
*** check /u01/app/oracle/cfgtoollogs/dbua/logs/silent.log file ***

- Checked
$ cat /etc/oratab
orcl:/u01/app/oracle/product/11.2.0/dbhome_2:N

SQL> select name from v$database;

NAME
---------
ORCL

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
*** Copy some configures from old Oracle Home ***
$ cp /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora /u01/app/oracle/product/11.2.0/dbhome_2/network/admin/
$ lsnrctl start
*** Make sure no application opens files at old Oracle Home ***
# lsof | grep "/oracle/product/11.2.0/dbhome_1"
Great!!! simple and easy for upgraded. Plan to test more ...

Related Post:
Upgrade database 11.2.0.1.0 to 11.2.0.2.0 : dbua -silent
struggle to Upgrade Oracle Database 11.2.0.1 to 11.2.0.2
Just upgrade Oracle Database 10gR2 to 11gR2 by command-line
Just Step to upgrade (RAC) 10.2.0.4 to 11.1.0.6
Creating Database 11gR1 on ASM 11gR2

1 comment:

Anonymous said...

Great posting. Thanks. I was able to follow along and do the same upgrade successfully. Dennis B.