oracle 10.2.0.2升级到10.2.0.4

最新推荐文章于 2021-04-05 23:39:22 发布

csdn20142014

最新推荐文章于 2021-04-05 23:39:22 发布

阅读量121

点赞数

文章标签：数据库

安装步骤来源于官方的p6810189_10204_Linux-x86.zip的README.HTML,
由于里面的步骤集合了RAC,ASM,single intance,
所以把single intance的安装步骤抽取出来

1:升级时区包（这一步通常不需要，只是征对有利用到
TIMESTAMP WITH LOCAL TIME ZONE (TSLTZ) , TIMESTAMP WITH TIME ZONE (TSTZ) 的数据类型和函数 TZ_OFFSET ）
安装之前先查看这个版本号，正常升级后这个版本值是4
SQL> select version from v$timezone_file;

VERSION
----------
2
下载包utltzpv4.zip，可以在google上找一下，在itpub.net里有下载地址
直接@utltzpv4.sql;
2:关闭oracle相关的所有服务

$ emctl stop dbconsole
$ isqlplusctl stop
$ lsnrctl stop

$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password
SQL> SHUTDOWN IMMEDIATE
3:启用vncserver
vncserver
4:用vncviewer登录数据库所在的操作系统，打开一个terminal
xhost +
cd patchset_directory/Disk1
./runInstaller
5:以root用户执行root.sh文件
6：手工升级 10.2 Database ,先查看是升级前是否丢失相关组件

SQL> STARTUP UPGRADE
SQL> SPOOL upgrade_info.log
SQL> @?/rdbms/admin/utlu102i.sql
SQL> SPOOL OFF

7：新开一个terminal
su - oracle
$ lsnrctl start

8:在第6步的窗口里继续执行 (在startup upgrade状态下执行)
SQL> SPOOL /oracle/patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

9:查看/oracle/patch.log日志文件，如果有出错，检查原因，并重新运行第9步
.
Oracle Database 10.2 Upgrade Status Utility 06-05-2009 15:03:25
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:10:44
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:01:56
Oracle XDK VALID 10.2.0.4.0 00:00:40
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:37
Oracle Text VALID 10.2.0.4.0 00:00:24
Oracle XML Database VALID 10.2.0.4.0 00:02:07
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:58
Oracle Data Mining VALID 10.2.0.4.0 00:00:28
OLAP Analytic Workspace VALID 10.2.0.4.0 00:01:02
OLAP Catalog VALID 10.2.0.4.0 00:00:58
Oracle OLAP API VALID 10.2.0.4.0 00:01:02
Oracle interMedia VALID 10.2.0.4.0 00:03:56
Spatial VALID 10.2.0.4.0 00:02:28
Oracle Expression Filter VALID 10.2.0.4.0 00:00:14
Oracle Enterprise Manager VALID 10.2.0.4.0 00:01:47
Oracle Rule Manager INVALID 10.2.0.4.0 00:00:12

不知哪里出了问题导致　Oracle Rule Manager INVALID ，由于这个功能没有用到，先跳过了
10:重启数据库并对包和过程重新编译

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
11:查看相关版本
SQL> column comp_name format a50;
SQL> column version format a10;
SQL> column status format a5;
SQL> select comp_name,version,status from sys.dba_registry;

COMP_NAME VERSION STATU
-------------------------------------------------- ---------- -----
Oracle Enterprise Manager 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
OLAP Catalog 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
Oracle Data Mining 10.2.0.4.0 VALID
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 VALID
Oracle OLAP API 10.2.0.4.0 VALID
12:升级 Enterprise Manager
emca -upgrade db