oracle RAC

Oracle环境： 版本：Oracle 11gR2 RAC （Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production） Rac节点信息： 主机名 SID SERVICE_NAME rac1 racdb1 racdb rac2 racdb2 racdb Host文件： 安装过程： 1、创建asmsnmp用户： su - grid   sqlplus / as sysasm   create user asmsnmp identified by 123456;   grant sysdba to asmsnmp; 2、ASM实例注册于listener_scan1： alter system set remote_listener='racscan:1521' scope=both sid='*';   alter system register; 3、查看cluster name： /u01/app/11.2.0/grid/bin/cemutlo -n 4、重归EM： su - oracle   emca -config dbcontrol db -repos recreate -cluster 配置过程如下：  [oracle@rac1 ~]$  emca -config dbcontrol db -repos recreate -cluster STARTED EMCA at Sep 29, 2018 5:40:04 PM EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle.  All rights reserved. Enter the following information: Database unique name: racdb Service name: racdb Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:  Password for SYS user:   Password for DBSNMP user:   Password for SYSMAN user:   Cluster name: rac-cluster Email address for notifications (optional):  Outgoing Mail (SMTP) server for notifications (optional):  ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]:  ASM port [ 1521 ]:  ASM username [ ASMSNMP ]:  ASM user password:   ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1 Database instance hostname ................ rac1 Listener ORACLE_HOME ................ /u01/app/11.2.0/grid Listener port number ................ 1521 Cluster name ................ rac-cluster Database unique name ................ racdb Email address for notifications ...............  Outgoing Mail (SMTP) server for notifications ...............  ASM ORACLE_HOME ................ /u01/app/11.2.0/grid ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ ASMSNMP ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Sep 29, 2018 5:41:06 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2018_09_29_17_40_04.log. Sep 29, 2018 5:41:09 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... Sep 29, 2018 5:45:29 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Sep 29, 2018 5:45:30 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Sep 29, 2018 5:53:53 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Sep 29, 2018 5:53:59 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Sep 29, 2018 5:55:00 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Sep 29, 2018 5:55:01 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb to remote nodes ... Sep 29, 2018 5:55:03 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac2_racdb to remote nodes ... Sep 29, 2018 5:55:09 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb to remote nodes ... Sep 29, 2018 5:55:11 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/rac2_racdb to remote nodes ... Sep 29, 2018 5:55:13 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary INFO:  Location /u01/app/oracle/product/11.2.0/dbhome_1/EMStagePatches_racdb is not shared. Software library could not be configured. Provisioning archives will not be deployed. Please configure it manually.  Sep 29, 2018 5:55:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Sep 29, 2018 5:55:32 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Sep 29, 2018 5:58:24 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Sep 29, 2018 5:58:25 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://rac1:1158/em <<<<<<<<<<< Sep 29, 2018 5:58:32 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage INFO:  ****************  Current Configuration  ****************  INSTANCE            NODE           DBCONTROL_UPLOAD_HOST ----------        ----------        --------------------- racdb             rac1              rac1 racdb             rac2              rac1 Sep 29, 2018 5:58:32 PM oracle.sysman.emcp.EMDBPostConfig invoke WARNING:  ************************  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: /u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.  *********************************************************** Enterprise Manager configuration completed successfully FINISHED EMCA at Sep 29, 2018 5:58:33 PM 5、启动EM：  分别在两个节点的oracle用户下运行： [oracle@rac1 ~]$ 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://rac1: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/rac1_racdb/sysman/log    [oracle@rac2 ~]$ 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://rac1: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/rac2_racdb/sysman/log  6、在IE浏览器中打开地址：https://racscan:1158/em ，登录即可   点赞 2 收藏 分享 白昼ron  博客专家 发布了167 篇原创文章 · 获赞 145 · 访问量 104万+ 他的留言板 关注 展开阅读 ———————————————— 版权声明：本文为CSDN博主「白昼ron」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。 原文链接：https://blog.csdn.net/xiezuoyong/article/details/82905151