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

ownload.oracle.com/docs/cd/E11882_01/server.112/e23633/upgrade.htm#i1011372

单实例的升级，相对较简单，如果是RAC的升级，估计还要麻烦一点，11gR2 RAC 升级后面会继续进行测试。

三.升级Oracle 软件

3.1 备份DB
本机是测试环境，就不进行备份，如果是生产环境，切记要先备份，后操作。

如果是In-Place Upgrade，同时备份一下整个ORACLE_HOME目录。如果升级有问题，还可以还原回来。

重点是如下目录：

ORACLE_HOME/dbs

ORACLE_HOME/network/admin

ORACLE_HOME/hostname_dbname

ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_dbname

3.2 升级Oracle database 软件

将升级包解压，11.2.0.3总共7个升级包，只需要前两个

[root@rh6 ~]# su - oracle
[oracle@rh6 ~]$ cd soft
[oracle@rh6 soft]$ ls -l
total 2442052
-rwxr--r-- 1 oracle oinstall 1358454646 Jul 7 2013 p10404530_112030_Linux-x86-64_1of7.zip
-rwxr--r-- 1 oracle oinstall 1142195302 Jul 7 2013 p10404530_112030_Linux-x86-64_2of7.zip

[oracle@rh6 soft]$ unzip p10404530_112030_Linux-x86-64_1of7.zip ;unzip p10404530_112030_Linux-x86-64_2of7.zip

......
creating: database/stage/Components/oracle.rdbms.install.seeddb/
   creating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/
   creating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/1/
   creating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/1/DataFiles/
   creating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/1/DataFiles/Expanded/
   creating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/1/DataFiles/Expanded/filegroup1/
  inflating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/1/DataFiles/Expanded/filegroup1/Seed_Database.ctl  
  inflating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/1/DataFiles/Expanded/filegroup1/Seed_Database.dfb  
  inflating: database/stage/Components/oracle.rdbms.install.seeddb/11.2.0.3.0/1/DataFiles/filegroup2.jar  
   creating: database/stage/Components/oracle.sysman.console.db/
   creating: database/stage/Components/oracle.sysman.console.db/11.2.0.3.0/
   creating: database/stage/Components/oracle.sysman.console.db/11.2.0.3.0/1/
   creating: database/stage/Components/oracle.sysman.console.db/11.2.0.3.0/1/DataFiles/
   
 ......

解压后，生成database文件夹：

[oracle@rh6 soft]$ ls -l
total 2442056
drwxr-xr-x 8 oracle oinstall 4096 Sep 22 2011 database
-rwxr--r-- 1 oracle oinstall 1358454646 Jul 7 2013 p10404530_112030_Linux-x86-64_1of7.zip
-rwxr--r-- 1 oracle oinstall 1142195302 Jul 7 2013 p10404530_112030_Linux-x86-64_2of7.zip

查看database文件夹：

[oracle@rh6 soft]$ cd database/
[oracle@rh6 database]$ ls
doc  install  readme.html  response  rpm  runInstaller  sshsetup  stage  welcome.html

[oracle@rh6 database]$ cd stage/

[oracle@rh6 stage]$ ls
Actions          install1.jar                                     products.xml
ComponentList    install2.jar                                     properties
Components       invDetails.properties                            Queries
config.xml       libs.xml                                         shiphomeinfo.properties
cvu              oracle.server.11_2_0_3_0_1316280737644.bak       shiphomeproperties.xml
Dialogs          oracle.server.11_2_0_3_0_1316280738235.bak       sizes
ext              oracle.server.11_2_0_3_0_dep_default.properties  TopLevel_UserAction.properties
fastcopy         oracle.server.11_2_0_3_0.xml                     UserActions
fastcopy.xml     OuiConfigVariables.xml
globalvariables  productlanguages.properties

[oracle@rh6 stage]$ du -sh Components 
2.3G    Components

升级前对数据库进行备份：

[oracle@rh6 stage]$ mkdir /dsk1/backup
[oracle@rh6 stage]$ rman target /

Recove

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