ASM存储上Oracle10g升级.doc

ASM存储数据升级前准备工作：oracle升级为两步： 软件升级，数据库升级 软件升级： 所有的数据库关闭状态，监听关闭，没有活动进程 数据库升级：更新数据字典 catupgrd.sql 前提条件，保证system表空间free剩余空间要大于10m shared_pool_size要临时调大，java_pool_size临时调大 （sga_target=0,手动指定各个池大小) 关闭Oralce数据库及监听程序umount ASM磁盘组及关闭监听程序确保没有ora_各种进程存在只有先关闭oracle数据库才能umount掉ASM磁盘组一、配置各种内存参数先启动ASM磁盘组rac1-export ORACLE_SID=+ASM rac1-sqlplus / as sysdba SQL startup mount 启动oracl数据库rac1-export ORACLE_SID=asmdb rac1-sqlplus / as sysdba SQL startup SQL show parameter sga NAME TYPE VALUE - - - lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 180M sga_target big integer 180M 增加system 表空间SQL alter tablespace system add datafile +db1 size 300m; 更改内存参数SQL alter system set sga_max_size=450m scope=spfile; SQL alter system set sga_target=450m scope=spfile; SQL alter system set shared_pool_size=150m scope=spfile; SQL alter system set db_cache_size=100m scope=spfile; SQL alter system set java_pool_size=150m scope=spfile; SQL startup force SQL show parameter sga NAME TYPE VALUE - - - lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 452M sga_target big integer 452M SQL shutdown immediate 关闭ASM磁盘rac1-export ORACLE_SID=+ASM rac1-sqlplus / as sysdba SQL shutdown immediate 检查oracle进程是否全部关闭rac1-ps -ef |grep ora_ oracle 4069 3869 0 04:01 pts/1 00:00:00 grep ora_ 关闭ASM的css服务，以root用户执行：rootrac1 # /u01/oracle/10g/bin/localconfig delete 安装升级包，即更新数据库软件，下一步下一步就行了！升级数据库步骤：注册css服务，启动ASM磁盘组，更新数据字典catupgrd.sqlutlrp.sql 编译失效的对象 注册css服务：rootrac1 # /u01/oracle/10g/bin/localconfig add 启动ASM磁盘组：rac1-export ORACLE_SID=+ASM rac1-sqlplus / as sysdba SQL startup mount 启动oracle数据库到upgrade状态：rac1-export ORACLE_SID=asmdb rac1-sqlplus / as sysdba SQL startup upgrade 更新数据字典SQL ?/rdbms/admin/catupgrd.sql更新数据字典时间比较长，要耐心等待。编译失效的对象 utlrp.sqlSQL shutdown immediate SQL startup SQL ?/rdbms/admin/utlrp.sql至些，已经完成了数据库软件的全部升级SQL col comp_name format a40 SQL col version format a30 SQL col version format a10 SQL select comp_name,version,status from sys.dba_registry; COMP_NAME VERSION STATUS - - - Oracle Database Catalog Views 10.2.0.4.0 VALID Oracle Database Packages and Types 10.2.0.4.0 VALID Oracle Workspace Manager 10.2.0.4.3 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 Oracle Expression Filter 10.2.0.4.0 VALID Oracle Data Mining 10.2.0.4.0 VALID Oracle Text 10.2.0.4.0 VALID Oracle XML Database 10.2.0.4.0 VALID Oracle Rule Manager 10.2.0.4.0 VALID COMP_NAME VERSION STATUS - - - Oracle interMedia 10.2.0.4.0 VALID OLAP Analytic Workspace 10.2.0.4.0 VALID Oracle OLAP API 10.2.0.4