11g DBcontrol（OEM）for 2 Nodes Rac on Linux

2019-11-08 20:56:13

字体：大中小

来源：转载

供稿：网友

1.准备工作

前提1：检查是否已有EM组件

set pagesize 999col comp_name for a50set linesize 180select comp_id,comp_name,version,status,startup from dba_registry;COMP_ID COMP_NAME VERSION STATUS------------------- --------------------------------------- ------------------------------EM Oracle EnterPRise Manager 11.2.0.4.0 VALIDOWB OWB 11.2.0.4.0 VALIDAPEX Oracle application Express 3.2.1.00.12 VALIDAMD OLAP Catalog 11.2.0.4.0 VALIDSDO Spatial 11.2.0.4.0 VALIDORDIM Oracle Multimedia 11.2.0.4.0 VALIDXDB Oracle xml Database 11.2.0.4.0 VALIDCONTEXT Oracle Text 11.2.0.4.0 VALIDEXF Oracle Expression Filter 11.2.0.4.0 VALIDRUL Oracle Rules Manager 11.2.0.4.0 VALIDOWM Oracle Workspace Manager 11.2.0.4.0 VALIDCATALOG Oracle Database Catalog Views 11.2.0.4.0 VALIDCATPROC Oracle Database Packages and Types 11.2.0.4.0 VALIDjavaVM JServer JAVA Virtual Machine 11.2.0.4.0 VALIDXML Oracle XDK 11.2.0.4.0 VALIDCATJAVA Oracle Database Java Packages 11.2.0.4.0 VALIDAPS OLAP Analytic Workspace 11.2.0.4.0 VALIDXOQ Oracle OLAP API 11.2.0.4.0 VALIDRAC Oracle Real Application Clusters 11.2.0.4.0 VALID

前提2：ASM实例的remote listener 需要使用scan listener

IMPORTANT:1. Starting with 11.2, SCAN listener configuration is mandatory when configuring Database Control in an Oracle RAC environment Please check the Document 1188736.1 - How to Setup SCAN Listener and Client for TAF and Load Balancing2. Starting with 11.2 EMCA, the reconfig command uses the parameter -EM_NODE_LIST instead of -EM_SID_LIST Example: $ emca -reconfig dbcontrol -cluster -EM_NODE <node1> -EM_NODE_LIST <node1,node2,nodeN>Reference：How to manage DB Control 11.x for RAC Database with emca (文档 ID 578011.1)设置asm实例的remote listener：grid@rac01 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 16 04:16:52 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> show parameter listenerNAME TYPE VALUE------------------------------------ ----------- ------------------------------listener_networks stringlocal_listener string (DESCRipTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.12.11)(PORT=1521))))remote_listener stringSQL> alter system set remote_listener='rac-scan:1521';System altered.SQL> alter system register;System altered.SQL> show parameter remoteNAME TYPE VALUE------------------------------------ ----------- ------------------------------remote_listener string rac-scan:1521remote_login_passWordfile string EXCLUSIVEremote_os_authent boolean FALSEremote_os_roles boolean FALSE如果通过管理命令无法查看服务命令，则需要重建,过程如下：

1)获取cluster名

#su - grid$ cd $ORACLE_HOME/bin$ ./cemutlo -n$rac-cluster

2)或者设置好如下账号的密码

DBSNMP/SYS/SYSMAN, ASMSNMP注：ASMSNMP如不记得密码,直接以grid用户下登录SQLPLUS / AS SYSASM方式更改即可。

3)开始重建

$emca -config dbcontrol db -repos recreate -cluster //因为原来有过em组件但无法使用，顾选择重建STARTED EMCA at Nov 16, 2016 4:35:14 AMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following information:Database unique name: racdbService name: racdbListener port number: 1521Listener ORACLE_HOME [ /oracle/app/11.2/grid ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Cluster name: rac-clusterEmail address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [ /oracle/app/11.2/grid ]: ASM port [ 1521 ]: ASM username [ ASMSNMP ]: ASM user password: -----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /oracle/app/oracle/product/11.2.0Database instance hostname ................ Listener ORACLE_HOME ................ /oracle/app/11.2/gridListener port number ................ 1521Cluster name ................ rac-clusterDatabase unique name ................ racdbEmail address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /oracle/app/11.2/gridASM port ................ 1521ASM user role ................ SYSDBAASM username ................ ASMSNMP----------------------------------------------------------------------WARNING : While repository is dropped the database will be put in quiesce mode.----------------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yesNov 16, 2016 4:35:48 AM oracle.sysman.emcp.EMConfig performINFO: This Operation is being logged at /oracle/app/oracle/cfgtoollogs/emca/racdb/emca_2016_11_16_04_35_14.log.Nov 16, 2016 4:35:51 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Dropping the EM repository (this may take a while) ...Nov 16, 2016 4:40:20 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully droppedNov 16, 2016 4:40:21 AM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) ...Nov 16, 2016 4:50:08 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdNov 16, 2016 4:50:22 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepositoryINFO: Uploading configuration data to EM repository (this may take a while) ...Nov 16, 2016 4:52:03 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Uploaded configuration data successfullyNov 16, 2016 4:52:03 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFilesINFO: Propagating /oracle/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole_rac01_racdb to remote nodes ...Nov 16, 2016 4:52:05 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFilesINFO: Propagating /oracle/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole_rac02_racdb to remote nodes ...Nov 16, 2016 4:52:09 AM oracle.sysman.emcp.EMAgentConfig deployStateDirsINFO: Propagating /oracle/app/oracle/product/11.2.0/rac01_racdb to remote nodes ...Nov 16, 2016 4:52:11 AM oracle.sysman.emcp.EMAgentConfig deployStateDirsINFO: Propagating /oracle/app/oracle/product/11.2.0/rac02_racdb to remote nodes ...Nov 16, 2016 4:52:13 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) ...Nov 16, 2016 4:52:37 AM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Nov 16, 2016 4:54:18 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyNov 16, 2016 4:54:18 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://rac01:1158/em <<<<<<<<<<<Nov 16, 2016 4:54:28 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessageINFO: **************** Current Configuration **************** INSTANCE NODE DBCONTROL_UPLOAD_HOST---------- ---------- ---------------------racdb rac01 rac01racdb rac02 rac01Nov 16, 2016 4:54:28 AM oracle.sysman.emcp.EMDBPostConfig invokeWARNING: ************************ WARNING ************************Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /oracle/app/oracle/product/11.2.0/rac01_racdb/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. ***********************************************************Enterprise Manager configuration completed successfullyFINISHED EMCA at Nov 16, 2016 4:54:29 AM

提醒：使用hostname代替IP地址访问rac的em，https://rac01:1158/em

Reference ：How to manage DB Control 11.x for RAC Database with emca (文档 ID 578011.1)

如果安装过程中遇到如下问题：

WARNING: ORA-28003: password verification for the specified password failedORA-20006: Password too simple

参考：EMCA: RepManager Fails With Password Verification Error ORA-28003 (文档 ID 779098.1)

上一篇：CentOS6.5下>>hadoop2.6.2版本的>>Mysql数据库的安装与配置

下一篇：【Oracle数据库】高级子查询