将原目录（11.2.0.1.0） 下的文件拷贝到新的目录（11.2.0.3.0）下：

[oracle@rh6 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs
[oracle@rh6 dbs]$ ls
hc_DBUA0.dat  hc_prod.dat  init.ora  lkPROD  orapwprod  snapcf_prod.f  spfileprod.ora
[oracle@rh6 dbs]$ cp * /u01/app/oracle/product/11.2.0.3/db_1/dbs/

[oracle@rh6 dbs]$ cd ../network/admin/
[oracle@rh6 admin]$ pwd
/u01/app/oracle/product/11.2.0/db_1/network/admin
[oracle@rh6 admin]$ ls
listener.ora  samples  shrept.lst  tnsnames.ora
[oracle@rh6 admin]$ cp -R * /u01/app/oracle/product/11.2.0.3/db_1/network/admin/

修改/etc/cattab文件：

[oracle@rh6 admin]$ cat /etc/oratab 
#

 

# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
prod:/u01/app/oracle/product/11.2.0/db_1:N

修改为：

[oracle@rh6 admin]$ cat /etc/oratab
#

 

# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
prod:/u01/app/oracle/product/11.2.0.3/db_1:N

---至此，Oracle软件升级完成！

四、升级数据字典（Instance）

Instance启动到upgrade状态：

[oracle@rh6 admin]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 24 14:06:04 2015

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

Connected to an idle instance.

SQL> startup upgrade;
ORACLE instance started.

Total System Global Area 417546240 bytes
Fixed Size 2228944 bytes
Variable Size 297798960 bytes
Database Buffers 113246208 bytes
Redo Buffers 4272128 bytes
Database mounted.
Database opened.
SQL> select * from v$version;