Oracle Enterprise Manager在RAC中的配置

二、Bug 8350262补丁安装

1）下载补丁解压后，认真浏览README.txt文本文件，按照指导完成该补丁的安装。

2）下载地址

https://support.oracle.com/CSP/ui/flash.html#tab=PatchHomePage(page=PatchHomePage&id=gj46o799()),(page=PatchSearchResultsHome&id=gj46pr1y(search=%3CSearch%3E%0A%20%20%3CFilter%20name=%22patch_number%22%20op=%22IS%22%20value=%228350262%22%20type=%22patch_number%22/%3E%0A%20%20%3CFilter%20name=%22platform%22%20op=%22IS%22%20value=%22%22%20type=%22platform%22/%3E%0A%3C/Search%3E&incFamilyProds=false&flag=search))

 

3）以下是README.txt全部内容：

=========================================================================

Interim Patch for Base Bug: 8350262

=========================================================================

Date: Sep 10, 2010

-------------------------------------------------------------------------

 Platform Patch for      : Generic

 Product Patched         : 10.2.0.4.0

 Product Version         : Enterprise Manager Database Control

 

Bugs Fixed by this patch:

-------------------------

8350262:CREATE DBCONSOLE CERT WITH 10YEAR VALIDITY

Patch Preinstall Steps:

-----------------------

1. For non-recommended patches, you must have the exact symptoms

   described in the service request (SR).

 

2. Verify the OUI Inventory.

OPatch needs access to a valid OUI inventory to apply patches.

Validate the OUI inventory with the following command:

  % opatch lsinventory

If the command errors out, contact Oracle Support and work to validate

and verify the inventory setup before proceeding.

 

3. Please use the latest Version of OPatch.

Oracle recommends that all customers be on the latest version of OPatch.

Please review the following metalink note and follow the instructions

to update to the latest version if needed:

 

https://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=224346.1

 

4. Confirm executables appear in your system PATH.

 

The patching process will use the unzip and the opatch executables.  After

sourcing the ORACLE_HOME environment, confirm both of these exist before

continuing:

 

  - "which opatch"

  - "which unzip"

 

If either of these executables do not show in the PATH, correct the problem

before proceeding.

 

5. Create a location for storing the unzipped patch.  This location

will be referred to later in the document as <PATCH_TOP>.

 

6. Unzip the patch zip file into the <PATCH_TOP>.

unzip -d <PATCH_TOP> p8350262_102040_Generic.zip

 

7. Shut down services running from the ORACLE_HOME.

Before applying this patch, do a clean shut down of all services

running from the ORACLE_HOME.

 

Patch Installation Steps:

-------------------------

1. Shutdown EM DB Console using the following command.

  % $ORACLE_HOME/bin/emctl stop dbconsole

2. Set your current directory to the directory where the patch is located:

  % cd <PATCH_TOP>/8350262

  Ensure that the directory containing the opatch script appears in your $PATH; then enter the following command:

   % opatch apply

3. Start EM DB Console using the following command.

    % $ORACLE_HOME/bin/emctl start dbconsole

 

NOTE:

------

There may be cases when Starting dbconsole may fail post 31-Dec-2010.

In this case, Please set ORACLE_HOME to your Database Home & ORACLE_SID and run the following from the patch folder.

 % ./killDBConsole

 

Patch Deinstallation Instructions:

----------------------------------

1. Shutdown EM DB Console using the following command.

       % $ORACLE_HOME/bin/emctl stop dbconsole

 

2. Set your current directory to the directory where the patch is located:

    % cd <PATCH_TOP>/8350262

 

3. Ensure that the directory containing the opatch script appears in your $PATH; then run the following command:-

   %  opatch rollback -id 8350262

  

4. Start EM DB Console using the following command.

 

以下是补丁安装步骤：

1）解压并CD到补丁目录下/orasoft/8350262

2）以Oracle用户登录到其中一个节点执行opathch(注意opatch路径不在环境变量中，需要指定或者用绝对路径)

[oracle@racdb1 8350262]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch apply

Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installer version 10.2.0.4.2

Copyright (c) 2007, Oracle Corporation.  All rights reserved.

Oracle 主目录       : /u01/app/oracle/product/10.2.0/db_1

主产品清单: /u01/app/oracle/oraInventory

从           : /etc/oraInst.loc

OPatch 版本    : 10.2.0.4.2

OUI 版本       : 10.2.0.4.0

OUI 位置      : /u01/app/oracle/product/10.2.0/db_1/oui

日志文件位置 : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-02-11_20-34-42下午.log

ApplySession 将中间补丁程序 '8350262' 应用到 OH '/u01/app/oracle/product/10.2.0/db_1' 

Running prerequisite checks...

OPatch 从产品清单中检测到节点列表和本地节点。OPatch 将对本地系统打补丁, 然后将补丁程序传播到远程节点。

为 Oracle 主目录备份文件和产品清单 (不是用于自动回退)

正在备份受补丁程序 '8350262' 影响的文件以用于恢复。此操作将需要一些时间...

正在备份受补丁程序 '8350262' 影响的文件以用于回退。此操作将需要一些时间...

 

正在为组件 oracle.sysman.agent.core, 10.2.0.4.0a 打补丁...

用 "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar"

用 "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar"

用 "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar"

用 "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar"

用 "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar"

用 "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar"

用 "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/RootCert.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar"

用 "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/SecConstants.class" 更新 jar 文件 "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar"

ApplySession 将中间补丁程序 '8350262' 添加到产品清单 

Verifying the update...

Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventory with proper meta-data.

Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

在滚动模式下打补丁。

Updating nodes 'racdb2'

   Apply-related files are:

     FP = "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_files.txt"

     DP = "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_dirs.txt"

     MP = "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/make_cmds.txt"

     RC = "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/remote_cmds.txt"

 

Instantiating the file "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_files.txt" with actual path.

Propagating files to remote nodes...

Instantiating the file "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_dirs.txt" with actual path.

Propagating directories to remote nodes... 

OPatch succeeded.

[oracle@racdb1 8350262]$

 

三、创建Cluster Repos

1)       列出CRS名称

[oracle@racdb1 bin]$ /u01/app/crs/bin/cemutlo -n

crs

 

2）列出数据库的db_unique_name

SQL> show parameter db_unique_name;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_unique_name                       string      racdb

SQL>

 

3）运行emca配置cluster repos

[oracle@racdb1 ~]$ emca -config dbcontrol db -repos create -cluster

EMCA 开始于 2012-2-11 21:35:06

EM Configuration Assistant, 10.2.0.1.0 正式版

版权所有 (c) 2003, 2005, Oracle。保留所有权利。

 

输入以下信息:

数据库的唯一名称: racdb

监听程序端口号: 1521

集群名: crs

SYS 用户的口令: 

DBSNMP 用户的口令: 

SYSMAN 用户的口令:  t

通知的电子邮件地址 (可选):

通知的发件 (SMTP) 服务器 (可选):

ASM ORACLE_HOME [ /u01/app/oracle/product/10.2.0/db_1 ]:

ASM 端口 [ 1521 ]:

ASM 用户角色 [ SYSDBA ]:

ASM 用户名 [ SYS ]:

ASM 用户口令: 

-----------------------------------------------------------------

已指定以下设置

 

数据库 ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1

数据库实例主机名 ................ racdb1

监听程序端口号 ................ 1521

集群名 ................ crs

数据库的唯一名称 ................ racdb

通知的电子邮件地址 ...............

通知的发件 (SMTP) 服务器 ...............

ASM ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1

ASM 端口 ................ 1521

ASM 用户角色 ................ SYSDBA

ASM 用户名 ................ SYS

 

-----------------------------------------------------------------

是否继续? [是(Y)/否(N)]: y

2012-2-11 21:35:52 oracle.sysman.emcp.EMConfig perform

信息: 正在将此操作记录到 /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/racdb/emca_2012-02-11_09-35-06-下午.log。

2012-2-11 21:35:54 oracle.sysman.emcp.EMReposConfig createRepository

信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...

2012-2-11 21:38:12 oracle.sysman.emcp.EMReposConfig invoke

信息: 已成功创建资料档案库

2012-2-11 21:38:14 oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles

信息: 正在将 /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_racdb2_racdb2 传播到远程节点...

2012-2-11 21:38:15 oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles

信息: 正在将 /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_racdb1_racdb1 传播到远程节点...

2012-2-11 21:38:17 oracle.sysman.emcp.EMAgentConfig deployStateDirs

信息: 正在将 /u01/app/oracle/product/10.2.0/db_1/racdb2_racdb2 传播到远程节点...

2012-2-11 21:38:19 oracle.sysman.emcp.EMAgentConfig deployStateDirs

信息: 正在将 /u01/app/oracle/product/10.2.0/db_1/racdb1_racdb1 传播到远程节点...

2012-2-11 21:38:20 oracle.sysman.emcp.util.DBControlUtil secureDBConsole

信息: 正在保护 Database Control (此操作可能需要一段时间)...

2012-2-11 21:40:20 oracle.sysman.emcp.util.DBControlUtil startOMS

信息: 正在启动 Database Control (此操作可能需要一段时间)...

2012-2-11 21:42:07 oracle.sysman.emcp.EMDBPostConfig performConfiguration

信息: 已成功启动 Database Control

2012-2-11 21:42:07 oracle.sysman.emcp.EMDBPostConfig performConfiguration

信息: >>>>>>>>>>> Database Control URL 为 https://racdb1:1158/em <<<<<<<<<<<

2012-2-11 21:42:07 oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage

信息:

****************  当前配置 ****************

 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST

----------        ----------        ---------------------

racdb2            racdb2            racdb1

racdb1            racdb1            racdb1

 

已成功完成 Enterprise Manager 的配置

EMCA 结束于 2012-2-11 21:42:07

[oracle@racdb1 ~]$

 

4）检查Oracle EnterPrise Manager运行状态

[oracle@racdb1 ~]$ emctl status dbconsole

TZ set to PRC

Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 

Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.

https://racdb1:1158/em/console/aboutApplication

Oracle Enterprise Manager 10g is running.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/racdb1_racdb1/sysman/log

[oracle@racdb1 ~]$