数据库版本升级步骤

数据库版本升级步骤

1、停止应用，关闭监听程序

[root@dave mnt]# su - oracle

dave:/home/oracle> lsnrctl stop

2、关闭EM程序（如果启用的话）dave:/home/oracle> emctl stop dbconsole

3、export方式备份数据

4、关闭数据库

dave:/home/oracle> sqlplus / as sysdba;

SQL> shutdown immediate

5、备份整个ORACLE_HOME目录。cp –R $ORACLE_HOME $ORACLE_HOME_BAK

6、升级ORACLE 软件到10.2.0.5版本

dave:/home/oracle>unzip p8202632_10205_LINUX.zip

dave:/home/oracle>cd Disk1

dave:/home/oracle>../runInstaller –ignoreSysPrereqs

修改了/etc/sysctl.conf文件下的三个参数

net.ipv4.ip_local_port_range = 9000 65500

fs.file-max = 101365

net.core.rmem_default = 1048576

[root@dave mnt]# sysctl –p

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

SQL> @?/rdbms/admin/catupgrd.sql

SQL> SPOOL OFF

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

SQL> @?/rdbms/admin/utlrp.sql

SQL> col comp_name format a40

SQL> col version for a20

SQL> SELECT COMP_NAME, VERSION, STA TUSFROM SYS.DBA_REGISTRY;

7、备份OPatch目录

使用6880880补丁替换原$ORACLE_HOME/OPatch目录

8、升级实例到10.2.0.5.4

$ORACLE_HOME/OPatch/opatch version

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir./12419392

dave:/> lsnrctl stop

SQL> shutdown immediate

dave:/mnt/OracleSoftware/10.2.0.5.4_PSU_p1*******/p1*******_10205_LINUX/12419392>op atch apply

dave:/u01/app/oracle/product/10.2.0/db_1/rdbms/admin>sqlplus / as sysdba

SQL> startup

SQL> @?/rdbms/admin/catbundle.sql psu apply

SQL> shutdown immediate

SQL> startup

SQL> @?/rdbms/admin/utlrp.sql

SQL>QUIT

9、验证PSU

$ORACLE_HOME/OPatch/opatch lsinv -bugs_fixed|grep PSU

select substr(action_time,1,30)action_time,

substr(id,1,10) id,

substr(action,1,10) action,

substr(version,1,8) version,

substr(BUNDLE_SERIES,1,6)bundle,

substr(comments,1,20) comments

from registry$history;