查看DB版本[Oracle@RedHat6 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 6 21:12:32 2013Copyright （c） 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> startup ORACLE instance started.Total System Global Area 208769024 bytes Fixed Size 2211928 bytes Variable Size 125833128 bytes Database Buffers 75497472 bytes Redo Buffers 5226496 bytes Database mounted. Database opened. SQL> select * from v$version;BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production1.解压补丁包并合并11.2.0.3的补丁包总共有七个，七个文件的不同作用参考如下链接http://blog.csdn.net/tianlesoftware/article/details/6818770升级数据库软件只需要解压第一个和第二个文件即可，如下p10404530_112030_Linux-x86-64_1of7.zipp10404530_112030_Linux-x86-64_2of7.zip[oracle@redhat6 11204_patch_1]$ unzip /opt/oracle11gR2/p10404530_112030_Linux-x86-64_1of7.zip [oracle@redhat6 11204_patch]$ unzip /opt/oracle11gR2/p10404530_112030_Linux-x86-64_2of7.zip将第二个解压后的文件拷贝到第一个解压后的相应目录底下[oracle@redhat6 Components]$/u01/11204_patch/database/stage/Components[oracle@redhat6 Components]$ cp -R * /u01/11204_patch_1/database/stage/Components/2.升级的主要步骤 a.备份数据库（以便升级失败，可以进行恢复） b.运行patchset，升级oracle软件 c.准备新的ORACLE_HOME d.运行dbua或者脚本升级实例 e.检查升级后的版本信息和无效对象 2.1 关闭与oracle相关的服务 lsnrctl stop shutdown immediate emctl stop dbconsole 2.2备份DB主要备份以下目录 ORACLE_HOME/dbs ORACLE_HOME/network/admin ORACLE_HOME/hostname_dbname ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_dbname 2.3升级Oracle software[oracle@redhat6 ~]$ cd /u01/11204_patch_1/database/ [oracle@redhat6 database]$ ls doc install readme.html response rpm runInstaller sshsetup stage welcome.html[oracle@redhat6 database]./runInstaller
安装结束的时候，用root用户执行一下两个脚本orainstRoot.sh和root.sh2.4将11.2.0.1下ORACLE_HOME下的文件拷贝新的ORACLE_HOME下，操作如下[oracle@redhat6 dbs]$ pwd /u01/app/oracle/product/11.2.0/db_1/dbs [oracle@redhat6 dbs]$ cp * /u01/app/oracle/product/11.2.0.3/db_1/dbs/ [oracle@redhat6 admin]$ pwd /u01/app/oracle/product/11.2.0/db_1/network/admin [oracle@redhat6 admin]$ cp -R * /u01/app/oracle/product/11.2.0.3/db_1/network/admin/2.5修改oracle配置文件[oracle@redhat6 ~]$ cat .bash_profile |grep ORACLE_HOME ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib [oracle@redhat6 ~]$ 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. # # hjj:/u01/app/oracle/product/11.2.0.3/db_1:Y 2.6在新ORACLE_HOME下启动sqlplus并以AS SYSDBA权限登陆SQL>SPOOL upgrade_info.logSQL>@/u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/utlu112i.sqlSQL>SPOOL OFF 2.7关闭数据库数据库重启一下SQL>shutdown immediateSQL>starup upgrade --必须upgrade[oracle@redhat6 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Sun Dec 8 03:16:38 2013Copyright （c） 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> 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 - ProductionSQL> select status from v$instance;STATUS ------------ OPEN MIGRATE--编译无效对象SQL> @/u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/utlrp.sql--执行升级脚本SQL> @/u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catupgrd.sql执行完后会自动 shutdown immediate，而且执行时间比较长[oracle@redhat6 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Sun Dec 8 04:13:52 2013Copyright （c） 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.SQL> startup ORACLE instance started.Total System Global Area 208769024 bytes Fixed Size 2226936 bytes Variable Size 142607624 bytes Database Buffers 58720256 bytes Redo Buffers 5214208 bytes Database mounted. Database opened. SQL> select status from v$instance;STATUS ------------ OPEN更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址
易网时代-编程资源站