Oracle 数据库 补丁升级
发布时间：2020-12-12 16:02:31 所属栏目：百科 来源：网络整理
导读：环境描述： Linux 5.7 x86-64bit + Oracle 11.2g ==================================================================================================== 1、数据库版本 ===============================================================================
|
环境描述：
Linux 5.7 x86-64bit + Oracle 11.2g ==================================================================================================== 1、数据库版本 ==================================================================================================== SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production [root@orcl-db-01 ~]# su oracle [oracle@orcl-db-01 root]$ cd $ORACLE_HOME [oracle@orcl-db-01 dbhome_1]$ ls -l|grep OPatch drwxr-xr-x 6 oracle oinstall 4096 Aug 12 21:07 OPatch [oracle@orcl-db-01 dbhome_1]$ ==================================================================================================== 2、查询OPatch版本 ==================================================================================================== 首先，我们需要确定当前的OPatch版本。进入OPatch目录之后，可以通过版本首先确认。 [oracle@orcl-db-01 dbhome_1]$ cd OPatch/ [oracle@orcl-db-01 OPatch]$ ls -l total 92 drwxr-xr-x 2 oracle oinstall 4096 Aug 12 21:07 docs -rw-r--r-- 1 oracle oinstall 21576 May 6 2009 emdpatch.pl drwxr-xr-x 2 oracle oinstall 4096 Aug 12 21:07 jlib drwxr-xr-x 5 oracle oinstall 4096 Aug 12 21:07 ocm -rwxr-xr-x 1 oracle oinstall 8709 May 6 2009 opatch -rw-r--r-- 1 oracle oinstall 49 Aug 12 21:07 opatch.ini -rw-r--r-- 1 oracle oinstall 2576 May 6 2009 opatch.pl drwxr-xr-x 4 oracle oinstall 4096 Aug 12 21:07 opatchprereqs [oracle@orcl-db-01 OPatch]$ ./opatch version Invoking OPatch 11.1.0.6.6 OPatch Version: 11.1.0.6.6 OPatch succeeded. ==================================================================================================== 3、原有OPatch备份 ==================================================================================================== 11.2.0.1自带的OPatch版本为11.1.0.6.6 tar zcvf opatch160831_bk.tar OPatch [oracle@orcl-db-01 dbhome_1]$ tar zcvf opatch160831_bk.tar OPatch OPatch/ OPatch/ocm/ OPatch/ocm/lib/ OPatch/ocm/lib/emocmutl.jar OPatch/ocm/doc/ OPatch/ocm/doc/dummy.txt OPatch/ocm/bin/ OPatch/ocm/bin/dummy OPatch/ocm/generic.zip OPatch/opatch.pl OPatch/opatchprereqs/ OPatch/opatchprereqs/oui/ OPatch/opatchprereqs/oui/knowledgesrc.xml OPatch/opatchprereqs/opatch/ OPatch/opatchprereqs/opatch/rulemap.xml OPatch/opatchprereqs/opatch/opatch_prereq.xml OPatch/opatchprereqs/opatch/runtime_prereq.xml OPatch/opatchprereqs/prerequisite.properties OPatch/docs/ OPatch/docs/FAQ OPatch/docs/Users_Guide.txt OPatch/docs/Prereq_Users_Guide.txt OPatch/emdpatch.pl OPatch/opatch.ini OPatch/opatch OPatch/jlib/ OPatch/jlib/opatch.jar OPatch/jlib/opatchutil.jar OPatch/jlib/opatchprereq.jar OPatch/jlib/opatchactions.jar ==================================================================================================== 4、OPatch升级 ==================================================================================================== 最新版本的OPatch可以从MOS上面下载到，补丁文件名称为：p6880880_112000_LINUX.zip --解压到ORACLE_HOME目录上 [oracle@bsplinux upload]$ unzip p6880880_112000_LINUX.zip -d $ORACLE_HOME [oracle@orcl-db-01 dbhome_1]$ unzip /tmp/orcl/patch/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME Archive: /tmp/orcl/patch/p6880880_112000_Linux-x86-64.zip creating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/ inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/README.html inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/README.txt creating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/ inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/oplan.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/oracle.oplan.classpath.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/automation.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/OsysModel.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/EMrepoDrivers.jar creating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/apache-commons/ inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar creating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/jaxb/ inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/jaxb/activation.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/jaxb/jaxb-api.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/jaxb/jaxb-impl.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/osysmodel-utils.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/jlib/CRSProductDriver.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/oplan/oplan replace /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/docs/FAQ? [y]es,[n]o,[A]ll,[N]one,[r]ename: A inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/docs/FAQ inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/docs/Users_Guide.txt inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/docs/Prereq_Users_Guide.txt inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/opatch.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/opatchsdk.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/oracle.opatch.classpath.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/oracle.opatch.classpath.unix.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/oracle.opatch.classpath.windows.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchprereqs/opatch/opatch_prereq.xml inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchprereqs/opatch/rulemap.xml inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchprereqs/opatch/runtime_prereq.xml inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchprereqs/oui/knowledgesrc.xml inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchprereqs/prerequisite.properties inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch.bat inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch.pl inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch.ini inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchdiag inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchdiag.bat inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/emdpatch.pl inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/README.txt inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/bin/emocmrsp inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/emocmclnt-14.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/emocmclnt.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/emocmcommon.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/http_client.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/jcert.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/jnet.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/jsse.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/log4j-core.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/osdt_core3.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/osdt_jce.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/regexp.jar inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/lib/xmlparserv2.jar extracting: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/ocm.zip inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ocm/ocm_platforms.txt creating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/ creating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/log/ extracting: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/log/dummy inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/auto_patch.pl inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/crsconfig_lib.pm inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/crsdelete.pm inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/crspatch.pm inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/installPatch.excl inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/oracss.pm inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/patch112.pl inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/s_crsconfig_defs inflating: /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/s_crsconfig_lib.pm ==================================================================================================== 5、验证OPatch安装成功。 ==================================================================================================== [oracle@orcl-db-01 dbhome_1]$ cd OPatch/ [oracle@orcl-db-01 OPatch]$ ls README.txt docs jlib opatch opatch.ini opatchdiag opatchprereqs crs emdpatch.pl ocm opatch.bat opatch.pl opatchdiag.bat oplan [oracle@orcl-db-01 OPatch]$ ./opatch version OPatch Version: 11.2.0.3.0 OPatch succeeded. ==================================================================================================== 6、停止数据库、监听等服务 ==================================================================================================== 注意：将数据库和监听程序关闭、一定要关门SQL 连接窗口，否则会报错。 [oracle@orcl-db-01 12419278]$ lsnrctl stop LSNRCTL for Linux: Versin 11.2.0.1.0 - Production on 31-8月 -2016 14:46:57 Copyright (c) 1991,2009,Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) 命令执行成功 [oracle@orcl-db-01 12419278]$ emctl stop dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996,2009 Oracle Corporation. All rights reserved. https://10.122.129.71:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control ... ... Stopped. SQL> shutdown immediate 数据库已经关闭。 已经卸载数据库。 ORACLE 例程已经关闭。 SQL> exit 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning,OLAP,Data Mining and Real Application Testing options 断开 [oracle@orcl-db-01 root]$ ==================================================================================================== 7、安装数据库安全补丁，(一定要关门SQL 连接窗口，否则会报以下错。) =================================================================================================== [oracle@orcl-db-01 12419278]$ $ORACLE_HOME/OPatch/opatch napply Oracle Interim Patch Installer version 11.2.0.3.0 Copyright (c) 2012,Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.0 OUI version : 11.2.0.1.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-08-31_14-53-25PM_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following executables are active : /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-08-31_14-53-25PM_1.log OPatch failed with error code 73 ==================================================================================================== 7、安装数据库安全补丁 ==================================================================================================== [oracle@orcl-db-01 12419278]$ $ORACLE_HOME/OPatch/opatch napply Oracle Interim Patch Installer version 11.2.0.3.0 Copyright (c) 2012,Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.0 OUI version : 11.2.0.1.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-08-31_14-54-37PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 10323077 10323079 10323081 10323082 11794163 11794164 11794167 12419278 12534742 12534743 12534745 12534746 12534747 12534748 12534749 12534750 12534751 12534752 12534753 12534754 12534755 12534756 9454037 9454038 9676419 9676420 9971778 9971779 9971780 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues,install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle 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/product/11.2.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '10323077' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.dv.oc4j,11.2.0.1.0... Verifying the update... Applying interim patch '10323079' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms,11.2.0.1.0... Verifying the update... Applying interim patch '10323081' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sdo.locator,11.2.0.1.0... Verifying the update... Applying interim patch '10323082' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching comonent oracle.sysman.console.db,11.2.0.1.0... Patching component oracle.sysman.oms.core,10.2.0.4.2... Verifying the update... Applying interim patch '11794163' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.dv,11.2.0.1.0... Patching component oracle.rdbms,11.2.0.1.0... Verifying the update... Applying interim patch '11794164' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.xdk.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '11794167' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.ldap.rsf.ic,11.2.0.1.0... Patching component oracle.ldap.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '12419278' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '12534742' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sysman.console.db,10.2.0.4.2... Verifying the update... Applying interim patch '12534743' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sysman.console.db,11.2.0.1.0... Verifying the update... Applying interim patch '12534745' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sysman.plugin.db.main.repository,11.2.0.1.0... Verifying the update... Applying interim patch '12534746' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sysman.console.db,11.2.0.1.0... Verifying the update... Applying interim patch '12534747' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sysman.console.db,11.2.0.1.0... Verifying the update... Applying interim patch '12534748' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sysman.console.db,11.2.0.1.0... Verifying the update... Applying interim patch '12534749' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.sysman.console.db,11.2.0.1.0... Verifying the update... Applying interim patch '12534750' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.ldap.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '12534751' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' ApplySession: Optional component(s) [ oracle.client,11.2.0.1.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '12534752' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.dbscripts,11.2.0.1.0... Verifying the update... Applying interim patch '12534753' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '12534754' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms,11.2.0.1.0... Verifying the update... Applying interim patch '12534755' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms,11.2.0.1.0... Verifying the update... Applying interim patch '12534756' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.xdk.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '9454037' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms,11.2.0.1.0... Verifying the update... Applying interim patch '9454038' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.dbscripts,11.2.0.1.0... Verifying the update... Applying interim patch '9676419' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching comonent oracle.network.rsf,11.2.0.1.0... Verifying the update... Applying interim patch '9676420' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.network.rsf,11.2.0.1.0... Patching component oracle.network.listener,11.2.0.1.0... Verifying the update... Applying interim patch '9971778' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.dbscripts,11.2.0.1.0... Verifying the update... Applying interim patch '9971779' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.javavm.server,11.2.0.1.0... Verifying the update... Applying interim patch '9971780' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.dbscripts,11.2.0.1.0... Verifying the update... Patches 10323077,10323079,10323081,10323082,11794163,11794164,11794167,12419278,12534742,12534743,12534745,12534746,12534747,12534748,12534749,12534750,12534751,12534752,12534753,12534754,12534755,12534756,9454037,9454038,9676419,9676420,9971778,9971779,9971780 successfully applied. Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-08-31_14-54-37PM_1.log OPatch succeeded. [oracle@orcl-db-01 12419278]$ ==================================================================================================== 8、查看补丁安装情况 ==================================================================================================== [oracle@orcl-db-01 OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.0 Copyright (c) 2012,Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.0 OUI version : 11.2.0.1.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2016-08-31_15-02-39PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-08-31_15-02-39PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.1.0 There are 1 products installed in this Oracle Home. Interim patches (29) : Patch 9971780 : applied on Wed Aug 31 14:58:36 CST 2016 Unique Patch ID: 13769865 Created on 14 Sep 2010,23:41:27 hrs PST8PDT Bugs fixed: 9971780 Patch 9971779 : applied on Wed Aug 31 14:58:32 CST 2016 Unique Patch ID: 13769865 Created on 14 Sep 2010,23:33:03 hrs PST8PDT Bugs fixed: 9971779,9454036 Patch 9971778 : applied on Wed Aug 31 14:58:30 CST 2016 Unique Patch ID: 13769865 Created on 14 Sep 2010,23:31:03 hrs PST8PDT Bugs fixed: 9971778 Patch 9676420 : applied on Wed Aug 31 14:58:27 CST 2016 Unique Patch ID: 13769865 Created on 31 May 2010,05:30:16 hrs PST8PDT Bugs fixed: 9676420 Patch 9676419 : applied on Wed Aug 31 14:58:24 CST 2016 Unique Patch ID: 13769865 Created on 31 May 2010,05:29:50 hrs PST8PDT Bugs fixed: 9676419 Patch 9454038 : applied on Wed Aug 31 14:58:21 CST 2016 Unique Patch ID: 13769865 Created on 18 Mar 2010,07:16:56 hrs PST8PDT Bugs fixed: 9454038 Patch 9454037 : applied on Wed Aug 31 14:58:19 CST 2016 Unique Patch ID: 13769865 Created on 25 Mar 2010,04:54:11 hrs PST8PDT Bugs fixed: 9454037 Patch 12534756 : applied on Wed Aug 31 14:58:16 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:16:09 hrs PST8PDT Bugs fixed: 12534756,11794165 Patch 12534755 : applied on Wed Aug 31 14:58:13 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:16:08 hrs PST8PDT Bugs fixed: 12534755,8702535,8991997 Patch 12534754 : applied on Wed Aug 31 14:58:09 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:16:07 hrs PST8PDT Bugs fixed: 12534754 Patch 12534753 : applied on Wed Aug 31 14:58:05 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:16:05 hrs PST8PDT Bugs fixed: 12534753 Patch 12534752 : applied on Wed Aug 31 14:58:02 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:16:02 hrs PST8PDT Bugs fixed: 12534752 Patch 12534751 : applied on Wed Aug 31 14:57:59 CST 2016 Unique Patch ID: 13769865 Created on 8 Jul 2011,02:03:38 hrs PST8PDT Bugs fixed: 12534751 Patch 12534750 : applied on Wed Aug 31 14:57:56 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:57 hrs PST8PDT Bugs fixed: 12534750 Patch 12534749 : applied on Wed Aug 31 14:57:53 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:56 hrs PST8PDT Bugs fixed: 12534749 Patch 12534748 : applied on Wed Aug 31 14:57:41 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:55 hrs PST8PDT Bugs fixed: 12534748 Patch 12534747 : applied on Wed Aug 31 14:57:26 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:53 hrs PST8PDT Bugs fixed: 12534747 Patch 12534746 : applied on Wed Aug 31 14:56:58 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:52 hrs PST8PDT Bugs fixed: 12534746 Patch 12534745 : applied on Wed Aug 31 14:56:46 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:51 hrs PST8PDT Bugs fixed: 12534745 Patch 12534743 : applied on Wed Aug 31 14:56:40 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:49 hrs PST8PDT Bugs fixed: 12534743 Patch 12534742 : applied on Wed Aug 31 14:56:11 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:48 hrs PST8PDT Bugs fixed: 12534742 Patch 12419278 : applied on Wed Aug 31 14:56:01 CST 2016 Unique Patch ID: 13769865 Created on 23 May 2011,02:15:45 hrs PST8PDT Bugs fixed: 9655013,9952260,9369797,11724991,10249532 Patch 11794167 : applied on Wed Aug 31 14:55:56 CST 2016 Unique Patch ID: 13769865 Created on 16 Mar 2011,00:52:03 hrs PST8PDT Bugs fixed: 11794167 Patch 11794164 : applied on Wed Aug 31 14:55:53 CST 2016 Unique Patch ID: 13769865 Created on 16 Mar 2011,00:53:33 hrs PST8PDT Bugs fixed: 11794164 Patch 11794163 : applied on Wed Aug 31 14:55:51 CST 2016 Unique Patch ID: 13769865 Created on 25 Mar 2011,02:58:25 hrs PST8PDT Bugs fixed: 10323080,11794163 Patch 10323082 : applied on Wed Aug 31 14:55:46 CST 2016 Unique Patch ID: 13769865 Created on 22 Dec 2010,07:29:02 hrs PST8PDT Bugs fixed: 10323082 Patch 10323081 : applied on Wed Aug 31 14:55:29 CST 2016 Unique Patch ID: 13769865 Created on 22 Dec 2010,07:09:56 hrs PST8PDT Bugs fixed: 10323081 Patch 10323079 : applied on Wed Aug 31 14:55:27 CST 2016 Unique Patch ID: 13769865 Created on 22 Dec 2010,07:03:31 hrs PST8PDT Bugs fixed: 10323079 Patch 10323077 : applied on Wed Aug 31 14:55:23 CST 2016 Unique Patch ID: 13769865 Created on 22 Dec 2010,04:12:56 hrs PST8PDT Bugs fixed: 10323077 -------------------------------------------------------------------------------- OPatch succeeded. ==================================================================================================== 9、数据库、监听服务启动 ==================================================================================================== [oracle@orcl-db-01 OPatch]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 31-8月 -2016 15:09:31 Copyright (c) 1991,Oracle. All rights reserved. 启动/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: 请稍候... TNSLSNR for Linux: Version 11.2.0.1.0 - Production 系统参数文件为/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora 写入/u01/app/oracle/diag/tnslsnr/orcl-db-01/listener/alert/log.xml的日志信息 监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) 监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) LISTENER 的 STATUS ------------------------ 别名 LISTENER 版本 TNSLSNR for Linux: Version 11.2.0.1.0 - Production 启动日期 31-8月 -2016 15:09:31 正常运行时间 0 天 0 小时 0 分 0 秒 跟踪级别 off 安全性 ON: Local OS Authentication SNMP OFF 监听程序参数文件 /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora 监听程序日志文件 /u01/app/oracle/diag/tnslsnr/orcl-db-01/listener/alert/log.xml 监听端点概要... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) 服务摘要.. 服务 "orcl" 包含 1 个实例。 实例 "orcl",状态 UNKNOWN,包含此服务的 1 个处理程序... 命令执行成功 [oracle@orcl-db-01 OPatch]$ emctl start dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996,2009 Oracle Corporation. All rights reserved. https://10.122.129.71:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 11g Database Control .... started. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/10.122.129.71_orcl/sysman/log [oracle@orcl-db-01 OPatch]$ （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |