ORACLE11g从 11.2.0.1升级到11.2.0.4 详细操作教程.docxVIP

图形化升级单机oracle 11.2.0.1 到 11.2.0.4 （WORD文档，下载后可编辑修改） ? 1. 将补丁包上传到数据库服务器，解压、安装 [root@11g ~]#unzip 112040_Linux-x86-64_1of7.zip -d /tmp unzip 112040_Linux-x86-64_2of7.zip -d /tmp 2. 检查当前版本SQL select * from v$version; BANNEROracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0 - ProductionNLSRTL Version 11.2.0.1.0 - Production SQL set linesize 150SQL set pagesize 9999SQL col comp_name format a40SQL SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY; COMP_NAME VERSION STATUS OWB 11.2.0.1.0 VALIDOracle Application Express 3.2.1.00.10 VALIDOracle Enterprise Manager 11.2.0.1.0 VALIDOLAP Catalog 11.2.0.1.0 VALIDSpatial 11.2.0.1.0 VALIDOracle Multimedia 11.2.0.1.0 VALIDOracle XML Database 11.2.0.1.0 VALIDOracle Text 11.2.0.1.0 VALIDOracle Expression Filter 11.2.0.1.0 VALIDOracle Rules Manager 11.2.0.1.0 VALIDOracle Workspace Manager 11.2.0.1.0 VALIDOracle Database Catalog Views 11.2.0.1.0 VALIDOracle Database Packages and Types 11.2.0.1.0 VALIDJServer JAVA Virtual Machine 11.2.0.1.0 VALIDOracle XDK 11.2.0.1.0 VALIDOracle Database Java Packages 11.2.0.1.0 VALIDOLAP Analytic Workspace 11.2.0.1.0 VALIDOracle OLAP API 11.2.0.1.0 VALID 18 rows selected. 3. 检查磁盘空间（system 必须要最少 10m） SQL select a.tablespace_name, round(a.total_size) total_size(mb),round(a.total_size) - round(b.free_size,3) unsed_size(mb),round(b.free_size,3) free_size(mb),round(b.free_size/total_size *100,2) ||% free_ratefrom(select tablespace_name,sum(bytes) /1024/1024 total_sizefrom dba_data_filesgroup by tablespace_name) a,(select tablespace_name,sum(bytes)/1024/1024 free_sizefrom dba_free_spacegroup by tablespace_name) bwhere a.tablespace_name=b.tablespace_name(+); 4.为数据库做冷备份 RMANrun {shutdown immediate;startup mount;allocate channel c1 type disk;allocate channel c2 type disk;backup full tag=db_full_bak database format