数据库版本升级步骤

数据库版本升级步骤1、停止应用，关闭监听程序[root@davemnt]#su-oracledave:/home/oraclelsnrctlstop2、关闭EM程序（如果启用的话）dave:/home/oracleemctlstopdbconsole3、export方式备份数据4、关闭数据库dave:/home/oraclesqlplus/assysdba;SQLshutdownimmediate5、备份整个ORACLE_HOME目录。cp–R$ORACLE_HOME$ORACLE_HOME_BAK6、升级ORACLE软件到10.2.0.5版本dave:/home/oracleunzipp8202632_10205_LINUX.zipdave:/home/oraclecdDisk1dave:/home/oracle../runInstaller–ignoreSysPrereqs修改了/etc/sysctl.conf文件下的三个参数net.ipv4.ip_local_port_range=900065500fs.file-max=101365net.core.rmem_default=1048576[root@davemnt]#sysctl–pSQLSTARTUPUPGRADESQLSPOOLpatch.logSQL@?/rdbms/admin/catupgrd.sqlSQLSPOOLOFFSQLSHUTDOWNIMMEDIATESQLSTARTUPSQL@?/rdbms/admin/utlrp.sqlSQLcolcomp_nameformata40SQLcolversionfora20SQLSELECTCOMP_NAME,VERSION,STATUSFROMSYS.DBA_REGISTRY;7、备份OPatch目录使用6880880补丁替换原$ORACLE_HOME/OPatch目录8、升级实例到10.2.0.5.4$ORACLE_HOME/OPatch/opatchversion$ORACLE_HOME/OPatch/opatchprereqCheckConflictAgainstOHWithDetail-phBaseDir./12419392dave:/lsnrctlstopSQLshutdownimmediatedave:/mnt/OracleSoftware/10.2.0.5.4_PSU_p12419392/p12419392_10205_LINUX/12419392opatchapplydave:/u01/app/oracle/product/10.2.0/db_1/rdbms/adminsqlplus/assysdbaSQLstartupSQL@?/rdbms/admin/catbundle.sqlpsuapplySQLshutdownimmediateSQLstartupSQL@?/rdbms/admin/utlrp.sqlSQLQUIT9、验证PSU$ORACLE_HOME/OPatch/opatchlsinv-bugs_fixed|grepPSUselectsubstr(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)commentsfromregistry$history;