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