Oracle11.2.0.1 PSU升级11.2.0.4

1、首先下载所需要的PSU包p6880880_112000_Linux-x86-64.zippatch包：p19121551_112040_Linux-x86-64-psu4.zip
2、解压p6880880_112000_Linux-x86-64.zip到$ORACLE_HOME目录下，将原有的备份unzip -n p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME3、查看版本号 [oracle@oraup OPatch]$ ./opatch versionOPatch Version: 11.2.0.3.6
OPatch succeeded.查看是否打PSU： [oracle@oraup OPatch]$ ./opatch lspatchesThere are no Interim patches installed in this Oracle Home.
4、 检查是否安装： [oracle@oraup OPatch]$ ./opatch lspatchesThere are no Interim patches installed in this Oracle Home.5、将p19121551_112040_Linux-x86-64-psu4.zip到patch的目录unzip -n p19121551_112040_Linux-x86-64-psu4.zip -d patch6、开始升级PSU，执行 [oracle@oraup OPatch]$ ./opatch napply -oh $ORACLE_HOME -local /ora/Patch/patch/19121551-local

Oracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/11.2.0.4/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/11.2.0.4/db_1/oraInst.locOPatch version : 11.2.0.3.6OUI version : 11.2.0.4.0Log file location : /u01/app/oracle/11.2.0.4/db_1/cfgtoollogs/opatch/opatch3014-12-09_07-49-53AM_1.log
Verifying environment and performing prerequisite checks…OPatch continues with these patches: 17478514 18031668 18522509 19121551
Do you want to proceed? [y|n]YUser Responded with: YAll checks passed.Provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. Easier for you if you use your MyOracle Support Email address/User Name.Visit http://www.oracle.com/support/policies.html for details.Email address/User Name:
You have not provided免费云主机域名 an email address for notification of security issues.Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.(Oracle Home = ‘/u01/app/oracle/11.2.0.4/db_1’)

Is the local system ready for patching? [y|n]Y…
Composite patch 19121551 successfully applied.OPatch Session completed with warnings.Log file location: /u01/app/oracle/11.2.0.4/db_1/cfgtoollogs/opatch/opatch3014-12-09_07-49-53AM_1.log
OPatch completed with warnings完成升级！其中有选择的地方直接Y查看是否成功 [oracle@oraup OPatch]$ ./opatch lspatches19121551;Database Patch Set Update : 11.2.0.4.4 (19121551)

相关推荐: inser提高插入的速度的实例分析

inser提高插入的速度的实例分析，针对这个问题，这篇文章详细介绍了相对应的分析和解答，希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。 我们可以使用直接路径的方式插入数据，绕过sga，但是直接路径的方式不会共享数据，也可以将在插入的时候关闭日志，…