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數據庫】高級子查詢