11grac配置EM

 

3.1执行安装命令

在其中一个节点上的oracle账号下执行,我这里是在节点1上执行的

 

复制代码
[oracle@rac01 ~]$ emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Oct 19, 2021 2:43:24 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database unique name: slnngk
Service name: slnngk
Listener port number: 1521
Listener ORACLE_HOME [ /u01/grid/grid_home/11.2.0.4 ]: 
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/grid/grid_home/11.2.0.4 ]: 
ASM port [ 1521 ]: 
ASM username [ ASMSNMP ]: 
ASM user password:  
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/oracle/app/product/11.2.0.4/db_1

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/grid/grid_home/11.2.0.4
Listener port number ................ 1521
Cluster name ................ rac-cluster
Database unique name ................ slnngk
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 
ASM ORACLE_HOME ................ /u01/grid/grid_home/11.2.0.4
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 19, 2021 2:46:08 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/app/cfgtoollogs/emca/slnngk/emca_2021_10_19_02_43_24.log.
Oct 19, 2021 2:46:10 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Oct 19, 2021 2:50:29 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Oct 19, 2021 2:50:36 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Oct 19, 2021 2:51:13 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Oct 19, 2021 2:51:13 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/oracle/app/product/11.2.0.4/db_1/oc4j/j2ee/OC4J_DBConsole_rac01_slnngk to remote nodes ...
Oct 19, 2021 2:51:14 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/oracle/app/product/11.2.0.4/db_1/oc4j/j2ee/OC4J_DBConsole_rac02_slnngk to remote nodes ...
Oct 19, 2021 2:51:17 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/oracle/app/product/11.2.0.4/db_1/rac01_slnngk to remote nodes ...
Oct 19, 2021 2:51:19 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/oracle/app/product/11.2.0.4/db_1/rac02_slnngk to remote nodes ...
Oct 19, 2021 2:51:21 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Oct 19, 2021 2:51:35 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Oct 19, 2021 2:52:20 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 19, 2021 2:52:20 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rac01:1158/em <<<<<<<<<<<
Oct 19, 2021 2:52:29 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO: 
****************  Current Configuration  ****************
 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

slnngk            rac01            rac01
slnngk            rac02            rac01


Oct 19, 2021 2:52:29 AM 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/oracle/app/product/11.2.0.4/db_1/rac01_slnngk/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 successfully
FINISHED EMCA at Oct 19, 2021 2:52:29 AM
复制代码

  

这里的Cluster name: rac-cluster

可以通过如下命令获取:

[grid@rac01 admin]$ cemutlo -n

rac-cluster

 

 

3.登陆

根据安装提示进行登陆

https://rac01:1158/em

客户端我们换成具体的ip进行访问

 

节点1上的三个ip都可以访问，但是通过节点2是无法访问的，因为我们em部署在节点1

https://节点1公共ip:1158/em

https://节点1vip:1158/em

https://scan-ip:1158/em

下面这里我们是通过scan-ip进行访问的,因为当前的scanip飘在节点1

 

重启

 

[oracle@rac01 ~]$emctl stop dbconsole
[oracle@rac01 ~]$emctl start dbconsole

 

 

  

 

 

3.2遇到的问题

 问题1:

WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

解决办法:

在节点1上的grid账号登陆asm实例修改remote_listener参数

[grid@rac01 admin]$ sqlplus /nolog

 SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 17 04:02:36 2020

 Copyright (c) 1982, 2013, Oracle.  All rights reserved.

 SQL> connect / as sysasm

Connected.

 alter system set remote_listener='rac-scan:1521' scope=both sid='*';

 

SQL> set linesize 1000;

SQL> show parameter remote;

 

NAME                                 TYPE                   VALUE

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

remote_listener                      string                 rac-scan:1521

remote_login_passwordfile            string                 EXCLUSIVE

remote_os_authent                    boolean                FALSE

remote_os_roles                      boolean                FALSE

 

问题2:

将已经锁住的账号进行解锁

Password for SYSMAN user: 

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

WARNING : While repository is dropped the database will be put in quiesce mode.

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

Do you wish to continue? [yes(Y)/no(N)]: y

Dec 17, 2020 4:13:47 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/oracle/app/cfgtoollogs/emca/slnngk/emca_2020_12_17_04_13_24.log.

Dec 17, 2020 4:13:49 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely

WARNING: Error during db connection : ORA-28000: the account is locked

 

Dec 17, 2020 4:13:55 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely

WARNING: ORA-28000: the account is locked

 解决办法:

Alter User sysman Account Unlock

  

问题3:

 不知道为什么我安装好rac是没有配置em的，安装的时候提示已经安装,需要进行删除处理

Dec 17, 2020 3:53:03 AM oracle.sysman.emcp.DatabaseChecks performReposChecks

SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.

 解决办法:

$ emca -deconfig dbcontrol db -repos drop -cluster

 cluster name获取

[grid@rac01 admin]$ cemutlo -n

rac-cluster

 

-- The End --

posted @   slnngk  阅读(307)  评论(0)  编辑  收藏  举报
编辑推荐：
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识（上）
· 浏览器原生「磁吸」效果！Anchor Positioning 锚点定位神器解析
阅读排行：
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布：重大改进与新特性概览！
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 单线程的Redis速度为什么快？
历史上的今天：
2019-12-17 es7.4安装
点击右上角即可分享
微信分享提示
AI FOR CODE 大赛