Upgrade - Oracle Database 10.2.0.4 to 11.2.0.3

Oracle Database software uses 2 files (1 and 2) of the 11.2.0.3 patchset.
SQL> select name from v$database;
NAME
---------
TEST11G
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 – Production
CORE    10.2.0.4.0    Production
TNS for Linux: Version 10.2.0.4.0 – Production
NLSRTL Version 10.2.0.4.0 – Production


$ cat /etc/oratab
test11g:/orasw/app/oracle/product/10.2.0:N


Install 11.2.0.3 software


Backup your database before upgrade
Upgraded Oracle Database (silent mode)
$ id
uid=500(oracle) gid=501(dba) groups=501(dba)

$ export ORACLE_HOME=/orasw/app/oracle/product/11.2.0
$ export PATH=$ORACLE_HOME/bin:$PATH
$ which dbua
/orasw/app/oracle/product/11.2.0/bin/dbua

Stop dbconsole if you have and run dbua:
$ dbua -silent -sid test11g
Log files for the upgrade operation are located at: /orasw/app/oracle/cfgtoollogs/dbua/test11g/upgrade1
Performing Pre Upgrade
1% complete
7% complete
7% complete
Upgrading Oracle Server
7% complete
.
.
.
21% complete
Upgrading JServer JAVA Virtual Machine
22% complete
23% complete
24% complete
25% complete
Upgrading Oracle XDK for Java
26% complete
27% complete
Upgrading OLAP Analytic Workspace
28% complete
Upgrading OLAP Catalog
30% complete
Upgrading EM Repository
31% complete
.
.
.
50% complete
Upgrading Oracle Text
52% complete
.
.
.
53% complete
54% complete
55% complete
55% complete
56% complete
57% complete
57% complete
58% complete
59% complete
60% complete
60% complete
61% complete
62% complete
62% complete
63% complete
64% complete
Upgrading Oracle XML Database
65% complete
66% complete
67% complete
67% complete
68% complete
Upgrading Oracle Java Packages
70% complete
70% complete
Upgrading Oracle interMedia
72% complete
72% complete
73% complete
Upgrading Spatial
75% complete
75% complete
76% complete
77% complete
77% complete
78% complete
Upgrading Oracle Workspace Manager
Upgrading Data Mining
Upgrading Expression Filter
Upgrading Rule Manager
Upgrading Oracle OLAP API
Performing Post Upgrade
79% complete
80% complete
85% complete
Configuring Database with Enterprise Manager
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 "/orasw/app/oracle/cfgtoollogs/dbua/logs/silent0.log" for upgrade details.
*** check / orasw/app/oracle/cfgtoollogs/dbua/logs/silent0.log file ***
Checked 

No Silent Mode:

 
Drop EM DB control repository:

$ which emctl

/orasw/app/oracle/product/10.2.0/bin/emctl

$ emca -deconfig dbcontrol db -repos drop  

STARTED EMCA at Jul 12, 2012 10:03:42 AM

EM Configuration Assistant, Version 10.2.0.1.0 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:

Database SID: test11g

Listener port number: 1521

Password for SYS user:  

Password for SYSMAN user:  

Do you wish to continue? [yes(Y)/no(N)]: y

Jul 12, 2012 10:03:52 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /orasw/app/oracle/product/10.2.0/cfgtoollogs/emca/test11g/emca_2012-07-12_10-03-42-AM.log.

Jul 12, 2012 10:03:53 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) ...

Jul 12, 2012 10:03:56 AM oracle.sysman.emcp.EMReposConfig dropRepository

INFO: Dropping the EM repository (this may take a while) ...

Click Yes to Continue.
 

Post upgrade

• $ cat /etc/oratab
  test11g:/orasw/app/oracle/product/11.2.0:N
• remove the spfile from $ORACLE_HOME/dbs
• remove the and recreate the link to init.ora in $ORACLE_HOME/dbs
• modify the init.ora to add compatible=11.2.0.3.0 (to use oracle 11g features)
• Copy some configures from old Oracle Home

$ cp /orasw/app/oracle/product/10.2.0/network/admin/listener.ora /orasw/app/oracle/product/11.2.0/network/admin/
$ lsnrctl start

• Make sure no application opens files at old Oracle Home

# lsof | grep "/oracle/product/11.2.0"

• Recreate EM DB control repository:

$ . oraenv

ORACLE_SID = [test11g] ?

$ which emctl

/orasw/app/oracle/product/11.2.0/bin/emctl

$ emca -config dbcontrol db -repos create

STARTED EMCA at Jul 12, 2012 10:46:02 AM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:

Database SID: test11g

Listener port number: 1521

Listener ORACLE_HOME [ /orasw/app/oracle/product/11.2.0 ]:

Password for SYS user:  

Password for DBSNMP user:  

Password for SYSMAN user:  

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /orasw/app/oracle/product/11.2.0

Local hostname ................ rac1.localdomain

Listener ORACLE_HOME ................ /orasw/app/oracle/product/11.2.0

Listener port number ................ 1521

Database SID ................ test11g

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: y

Jul 12, 2012 10:46:18 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /orasw/app/oracle/cfgtoollogs/emca/test11g/emca_2012_07_12_10_46_02.log.

Jul 12, 2012 10:46:19 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Done.
 
SQL> select name from v$database;

NAME
---------
TEST11G

SQL> select * from v$version;

BANNER
-------------------------------------------------------------------------------- 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit 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

Possible issues

• For error "The Upgrade Assistant failed in bringing up the database . Oracle Home obtained from file /etc/oratab was used to connect to the database. Either the database is not running from Oracle Home or the correct Initialization Parameter file (pfile) was not found."

Try to remove files on:
$ORACLE_BASE/cfgtoollogs/dbua

And re-try.

• The 11g oraenv may not be working for 10g databases if you have both 10g and 11g databases on the same server. If so you can copy the oraenv from 10g home to /usr/local/bin.