OracleStudy之--Oracle单实例11.2.0.1.0升级到11.2.0.3.0 - 数据库编程

e not changed. No need to overwrite. The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... 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.

将原目录（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

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;

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 Vers

OracleStudy之--Oracle单实例11.2.0.1.0升级到11.2.0.3.0(五)