单机环境oracle 11.2.0.2升级到11.2.0.4

1、确认当前数据库实例名

如果是多实例环境，先确认一下当前数据库的实例名

show parameter name;
----或者env|grep SID

2、备份数据库

rman target /
backup database plus archivelog delete input format '/data/backup/full1102_%U.bak';
----也可以备份整个数据目录和archive目录

3、停止数据库

shutdown immediate;
lsnrctl stop

4、确认是否的关闭了

ps -ef|grep ora_|grep -v grep

5、备份相关目录

ORACLE_HOME和oraInventory

tar -cvzf product1102.tar.gz /u01/app/oracle/product
tar -cvzf inventory1102.tar.gz /u01/app/oraInventory

6、解压介质

---从官网下来如下介质，并解压，调整属主
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip

7、安装数据库

./runInstaller -silent -force -responseFile /software/database/response/db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=true
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
oracle.install.db.isRACOneInstall=false
DECLINE_SECURITY_UPDATES=true

8、更改配置文件.bash_profile

----$ORACLE_HOME更改新的路径
/u01/app/oracle/product/11.2.0.4/db_1
----source .bash_profile生效

9、copy监听配置文件

cp /u01/app/oracle/product/11.2/db_1/dbs/* /u01/oracle/product/11.2.0.4/db_1/dbs

cp -r /u01/app/oracle/product/11.2/db_1/network/admin/*   /u01/app/oracle/product/11.2.0.4/db_1/network/admin/

10、升级检查

----以upgrade模式启动数据库
sqlplus /nolog
conn / as sysdba
startup upgrade;
@?/rdbms/admin/utlu112i.sql
----根据结果，调整条件不满足的地方 

11、创建回滚点

startup mount;
alter system set db_recovery_file_dest_size=20g scope=both;
alter system set db_recovery_file_dest='/u02/app/oracle/fast_recovery_area' scope=spfile;
alter database flashback on;
create restore point db_rollback guarantee flashback database;

12、升级

shutdown immediate;
startup upgrade;
----检查
@?/rdbms/admin/utlu112i.sql
----升级
set echo on
spool /home/oracle/upgrade.log
set time on;
@?/rdbms/admin/catupgrd.sql 

13、编译失效对象

shutdown immediate;
sqlplus /as sysdba
startup
@?/rdbms/admin/utlrp

14、检查失效对象

select * from dba_objects where status !='VALID';

15、删除原来的$ORACLE_HOME目录

16、删除还原点

drop resore point  db_rollback