ITPub博客

首页 > 数据库 > Oracle > oracle RAC

oracle RAC

原创 Oracle 作者:mcxiaoracle 时间:2019-12-28 11:57:49 0 删除 编辑

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


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69949806/viewspace-2671047/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: ibtis # 和 ¥ 区别
下一篇: oracle 性能优化
请登录后发表评论 登录
全部评论
数据方向,了解oracle ,IBM DB2 730

注册时间:2019-09-30

  • 博文量
    286
  • 访问量
    226568