RAC配置EM

最新推荐文章于 2021-04-07 08:50:59 发布
最新推荐文章于 2021-04-07 08:50:59 发布
阅读量843 收藏
点赞数
分类专栏： 笔记 Oracle 文章标签： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/shayuwei/article/details/103388500
版权
笔记 同时被 2 个专栏收录
164 篇文章 5 订阅
订阅专栏
Oracle
129 篇文章 7 订阅
订阅专栏

文章目录


数据库版本：11.2.0.4
操作系统：RedHat 6.10

RAC配置EM步骤

1 查看/etc/hosts文件

在这里插入图片描述

2 ASM实例注册于listener_scan
SQL> alter system set remote_listener='test-pro.xxx.xx.xx:1521' scope=both sid='*';
SQL> alter system register;
3 查看cluster name
[grid@testpdb1 ~]$ cemutlo -n
testpdb-cluster
4 重建EM
su - oracle
emca -config dbcontrol db -repos recreate -cluster

几次配置过程中的问题

问题1

[oracle@testpdb1 ~]$ emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Nov 5, 2019 6:31:27 PM
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: racpdb
Service name: test-pro.XXX.XX.XX
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0.4/grid ]:
Password for SYS user:  
Nov 5, 2019 6:32:22 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

Nov 5, 2019 6:32:27 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

Nov 5, 2019 6:36:33 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-01017: 用户名/口令无效; 登录被拒绝

Password validation failed. Some of the possible reasons may be:
1) Invalid username/password.
2) Database is not up.
3) Scan listener not up.
4) Database service is not registered with scan listener.
5) Password file may be missing or configured incorrectly.
问题解决
  1. Invalid username/password.
    用户名或密码错误。可能是密码错误，也可能是口令文件失效，可以重置口令文件。
  2. Database is not up.
    数据库没起来。
  3. Scan listener not up.
    scan监听没起来。查看scan监听状态：
# 查看scan 监听在哪个节点上
su - grid
srvctl status scan            
# 在对应节点，查看scan监听状态
lsnrctl status LISTENER_SCAN1
  1. Database service is not registered with scan listener.
    因为EM默认配置的时候会去找scan监听，所以需要手动添加：
SQL> alter system set remote_listener='test-pro.XXX.XX.XX:1521' scope=both sid='*';
                         # 注意这里是/etc/hosts文件记录的scan ip的host
System altered.

SQL>alter system register;

System altered.
  1. Password file may be missing or configured incorrectly.
    密码错误，可能是SYS/DBSNMP/SYSMAN/密码错误
  • 以DBSNMP为例：
    查看用户
SQL> select username,account_status from dba_users;

USERNAME               ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW                OPEN
SYS                      OPEN
SYSTEM                   OPEN
DBSNMP                   OPEN
SYSMAN                   OPEN
...
OUTLN                   EXPIRED & LOCKED
FLOWS_FILES             EXPIRED & LOCKED
MDSYS                   EXPIRED & LOCKED
...

修改dbsnmp密码

SQL> alter user dbsnmp identified by oracle;

User altered.
  • 以asmsnmp为例：
    这个密码是在安装GI时设置的，可以在oracle用户下测试asmsnmp连接是否成功
$ sqlplus asmsnmp/[PASSWD]@192.168.XXX.XXX:1521/+ASM as sysdba

如果连不上，可以用grid用户登录sqlplus / as sysasm 然后修改asmsnmp的密码
引申：DBSNMP用户和SYSMAN用户

  • 再次配置：
[oracle@testpdb1 ~]$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Nov 6, 2019 8:58:19 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: racpdb
Service name: racpdb
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0.4/grid ]:
Password for SYS user:  
Password for DBSNMP user:  
Password for SYSMAN user:  
Password for SYSMAN user: 
# 通过[grid@testpdb1 ~]$ cemutlo -n查看
Cluster name: testpdb-cluster        
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/11.2.0.4/grid ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:  
Nov 6, 2019 8:59:08 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
# 可以忽略
-----------------------------------------------------------------

You have specified the following settings

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

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

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 6, 2019 8:59:19 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racpdb/emca_2019_11_06_08_58_18.log.
Nov 6, 2019 8:59:21 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 6, 2019 9:01:28 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Nov 6, 2019 9:01:28 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 6, 2019 9:26:44 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 6, 2019 9:26:48 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 6, 2019 9:27:47 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 6, 2019 9:27:47 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0.4/db_1/oc4j/j2ee/OC4J_DBConsole_testpdb1_racpdb to remote nodes ...
Nov 6, 2019 9:27:48 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0.4/db_1/oc4j/j2ee/OC4J_DBConsole_testpdb2_racpdb to remote nodes ...
Nov 6, 2019 9:27:51 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0.4/db_1/testpdb1_racpdb to remote nodes ...
Nov 6, 2019 9:27:53 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0.4/db_1/testpdb2_racpdb to remote nodes ...
Nov 6, 2019 9:27:55 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 6, 2019 9:28:28 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 6, 2019 9:28:51 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://testpdb1.nsfc.gov.cn:1158/em <<<<<<<<<<<
Nov 6, 2019 9:28:54 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
****************  Current Configuration  ****************
INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

racpdb            testpdb1            testpdb1.xxx.xx.xx
racpdb            testpdb2            testpdb1.xxx.xx.xx


Nov 6, 2019 9:28:54 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/app/oracle/product/11.2.0.4/db_1/testpdb1_racpdb/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Nov 6, 2019 9:28:54 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: Error starting Database Control on nodes testpdb2. Execute the following command(s) on nodes: testpdb2.
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0.4/db_1/bin/emctl start dbconsole


Error starting Database Control on nodes testpdb2. Execute the following command(s) on nodes: testpdb2.
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0.4/db_1/bin/emctl start dbconsole
  • 查看dbconsole状态
[oracle@testpdb1 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://testpdb1.xxx.xx.cnxx1158/em/console/aboutApplication
- An instance of Oracle Enterprise Manager 11g Database Control is already running.

[oracle@testpdb1 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://testpdb1.xxx.xx.xx:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0.4/db_1/testpdb1_racpdb/sysman/log

问题2

[oracle@testrac1 ~]$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Nov 7, 2019 10:13:09 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: 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:  
Password for SYSMAN user: Cluster name: testrac-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:  
Nov 7, 2019 10:13:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

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

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid
Listener port number ................ 1521
Cluster name ................ testrac-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

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]:
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 7, 2019 10:14:04 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_10_13_09.log.
Nov 7, 2019 10:14:06 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 7, 2019 10:17:38 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Nov 7, 2019 10:17:38 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 7, 2019 10:26:25 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 7, 2019 10:26:29 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 7, 2019 10:28:20 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 7, 2019 10:28:21 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_testrac1_racdb to remote nodes ...
Nov 7, 2019 10:28:22 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_testrac2_racdb to remote nodes ...
Nov 7, 2019 10:28:26 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/testrac1_racdb to remote nodes ...
Nov 7, 2019 10:28:29 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/testrac2_racdb to remote nodes ...
Nov 7, 2019 10:28:31 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 7, 2019 10:28:34 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl config emkey -repos -host testrac1 -sid racdb
Nov 7, 2019 10:28:34 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed for node testrac1.
Nov 7, 2019 10:28:37 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl config emkey -repos -host testrac2 -sid racdb
Nov 7, 2019 10:28:37 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed for node testrac2.
Nov 7, 2019 10:28:37 AM oracle.sysman.emcp.EMDBPostConfig setRACWarnMsg
INFO: Error securing Database Control. Database Control has not been brought-up on nodes testrac1 testrac2 . Execute the following command(s) on nodes: testrac1 testrac2 .
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
3) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
4) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole
To secure Em Key, run /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >
Nov 7, 2019 10:28:37 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://testrac1.nsfc.gov.cn:1158/em <<<<<<<<<<<
Nov 7, 2019 10:28:37 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
****************  Current Configuration  ****************
INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

racdb             testrac1             testrac1
racdb             testrac2             testrac1




Error securing Database Control. Database Control has not been brought-up on nodes testrac1 testrac2 . Execute the following command(s) on nodes: testrac1 testrac2 .
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
3) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
4) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole
To secure Em Key, run /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >

[oracle@testrac1 ~]$ emctl start dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_An error occurred while attempting to change log file permissions. Logging may not be active for this process._racdb not found.
[oracle@testrac1 ~]$ emctl status dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_An error occurred while attempting to change log file permissions. Logging may not be active for this process._racdb not found.

但是根据报错信息和提示命令操作，并没有解决。

问题解决
  • 查看大量资料后，一种说法是：
    其实，到这一步，我们的DB Control的配置可以说是成功了。这里面看到的错误是说保护DB Control出错，什么意思呢？其实就是http和https的区别。
    如果咱们想通过公网、不安全的网络来使用DB Control，势必有一些敏感数据在网上传递，比如用户名、密码，那就应该采取一些保护措施，比如https。
    如果你是在可信的内网，或者是个测试环境使用DB Control，那使用http也无所谓。
    而Secure DB Control失败，就是说不能使用https，但不妨碍http的使用。
  • 另一种说法是：
    将配置EM控制台时输出的INFO信息中主机名vpn改成外网可以访问的服务器IP地址
    如果服务器是云主机，那么IP为ifconfig中的eth1中的IP;如果服务器是在IDC机房里的，那么需要在防火墙上做端口映射，将该服务器的1158端口映射为外网IP才能访问到。

但是都无法访问，也无法执行上述命令

因此重新配置dbconsole。

重新配置EM的步骤
1.清除原有em
emca -deconfig dbcontrol db -repos drop
emca -deconfig all db -repos drop
若上述两个指令删除失败，则只能暴力删除！
其实正常情况下，成功完成这个命令后，下面的语句都应该返回 object 已经被删除的错误。所以，指令失败就是说明有残留。还是需要手动清理。

SQL> drop user SYSMAN cascade;
SQL> drop user MGMT_VIEW cascade;
SQL> drop role MGMT_USER;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
  • 清除原有em（节点1）
[oracle@testrac1 ~]$ emca -deconfig dbcontrol db -cluster -repos drop

STARTED EMCA at Nov 7, 2019 2:04:49 PM
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: racdb
Service name: racdb.nsfc.gov.cn
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Password for SYS user:  
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 7, 2019 2:05:09 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_14_04_48.log.
Nov 7, 2019 2:05:10 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 7, 2019 2:05:18 PM
  • 清除原有em（节点2）
[oracle@testrac2 ~]$ emca -repos drop

2.重建资料库和em
重建资料库
指令：emca -repos create
重建em
指令：emca -config dbcontrol db -cluster

  • 节点1重建
[oracle@testrac1 ~]$ emca -repos recreate

STARTED EMCA at Nov 7, 2019 3:35:00 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: racdb1
Listener port number: 1521
Password for SYS user:  
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
Nov 7, 2019 3:35:14 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_15_34_59.log.
Nov 7, 2019 3:35:15 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 7, 2019 3:35:50 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/11.2.0/dbhome_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=testrac1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=racdb))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/cfgtoollogs/emca/racdb/emca_repos_drop_2019_11_07_15_35_15.log
Nov 7, 2019 3:35:50 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
Nov 7, 2019 3:35:50 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_repos_drop_<date>.log for more details.
Nov 7, 2019 3:35:50 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error dropping the repository
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_15_34_59.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_15_34_59.log for more details.

使用recreate命令报错，用create命令再次尝试：

[oracle@testrac1 ~]$ emca -repos create

STARTED EMCA at Nov 7, 2019 3:36:49 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: racdb1
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  

Do you wish to continue? [yes(Y)/no(N)]: y
Nov 7, 2019 3:37:01 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_15_36_48.log.
Nov 7, 2019 3:37:01 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 7, 2019 3:43:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 7, 2019 3:43:48 PM
  • 节点2重建em
    drop之后recreate repos会报错，“WARNING: ORA-01918: 用户 'SYSMAN' 不存在”，所以用create
[oracle@testrac2 ~]$ emca -repos create

STARTED EMCA at Nov 7, 2019 2:37:52 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: racdb2
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  

Do you wish to continue? [yes(Y)/no(N)]: y
Nov 7, 2019 2:38:11 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_02_37_52.log.
Nov 7, 2019 2:38:11 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.
[oracle@testrac2 ~]$ emctl status dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_testrac2_racdb not found.
[oracle@testrac2 ~]$ emca -config dbcontrol db -cluster

STARTED EMCA at Nov 7, 2019 2:44:29 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: 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: testrac-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:  
Nov 7, 2019 2:45:12 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

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

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid
Listener port number ................ 1521
Cluster name ................ testrac-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
Nov 7, 2019 2:45:20 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2019_11_07_02_44_28.log.
Nov 7, 2019 2:45:26 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 7, 2019 2:46:43 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 7, 2019 2:46:43 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_testrac1_racdb to remote nodes ...
Nov 7, 2019 2:46:45 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_testrac2_racdb to remote nodes ...
Nov 7, 2019 2:46:49 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/testrac1_racdb to remote nodes ...
Nov 7, 2019 2:46:52 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/testrac2_racdb to remote nodes ...
Nov 7, 2019 2:46:54 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 7, 2019 2:47:19 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 7, 2019 2:47:44 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://testrac2:1158/em <<<<<<<<<<<
Nov 7, 2019 2:47:48 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
****************  Current Configuration  ****************
INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

racdb             testrac1             testrac2
racdb             testrac2             testrac2


Nov 7, 2019 2:47:48 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/app/oracle/product/11.2.0/dbhome_1/testrac2_racdb/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Nov 7, 2019 2:47:48 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: Error starting Database Control on nodes testrac1. Execute the following command(s) on nodes: testrac1.
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole


Error starting Database Control on nodes testrac1. Execute the following command(s) on nodes: testrac1.
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole

问题3

异机恢复后重装报错：

[oracle@new-rac1 dbs]$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Dec 4, 2019 8:56:43 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Dec 4, 2019 8:56:43 AM oracle.sysman.emcp.util.ClusterUtil getHostName
SEVERE: Error getting hostname for the cluster node new-rac1. This node may not be configured correctly
Enter the following information:
Database unique name: racpdb
Service name: racpdb
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:     
Password for SYS user:  
Password for SYS user: Dec 4, 2019 8:56:58 AM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList
WARNING: The following cluster nodes are unavailable: [new-rac1, new-rac2].
Dec 4, 2019 8:56:58 AM oracle.sysman.emcp.ParamsManager getInaccessibleSidList
WARNING: The requested operation will not be performed for the following instances: [racpdb1, racpdb2].
No cluster nodes found when configuring the RAC database for EM

打算卸载重装，但是依旧报错：

  • 节点1：
[oracle@new-rac1 dbs]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Dec 4, 2019 9:07:11 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: racpdb1
Listener port number: 1521
Password for SYS user:  
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 4, 2019 9:07:31 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racpdb/emca_2019_12_04_09_07_10.log.
Dec 4, 2019 9:07:31 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Dec 4, 2019 9:07:31 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 4, 2019 9:10:12 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 4, 2019 9:10:12 AM
[oracle@new-rac1 dbs]$ emca -repos create

STARTED EMCA at Dec 4, 2019 9:20:47 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: racpdb1
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  

Do you wish to continue? [yes(Y)/no(N)]: y
Dec 4, 2019 9:21:10 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racpdb/emca_2019_12_04_09_20_46.log.
Dec 4, 2019 9:21:10 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 4, 2019 9:29:41 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 4, 2019 9:29:41 AM
  • 节点2：
[oracle@new-rac2 dbs]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Dec 4, 2019 9:19:34 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: racpdb2
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  
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 4, 2019 9:19:48 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racpdb/emca_2019_12_04_09_19_33.log.
Dec 4, 2019 9:19:48 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: 用户名/口令无效; 登录被拒绝

Dec 4, 2019 9:19:48 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Dec 4, 2019 9:19:48 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Dec 4, 2019 9:19:48 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 4, 2019 9:19:49 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 4, 2019 9:19:49 AM
  • 在节点2重装依旧报错：
[oracle@new-rac2 dbs]$ emca -config dbcontrol db -cluster

STARTED EMCA at Dec 4, 2019 9:32:30 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Dec 4, 2019 9:32:30 AM oracle.sysman.emcp.util.ClusterUtil getHostName
SEVERE: Error getting hostname for the cluster node new-rac2. This node may not be configured correctly
Enter the following information:
Database unique name: racpdb
Service name: racpdb
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Password for SYS user:  
Dec 4, 2019 9:32:46 AM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList
WARNING: The following cluster nodes are unavailable: [new-rac1, new-rac2].
Dec 4, 2019 9:32:46 AM oracle.sysman.emcp.ParamsManager getInaccessibleSidList
WARNING: The requested operation will not be performed for the following instances: [racpdb1, racpdb2].
No cluster nodes found when configuring the RAC database for EM
问题解决

先排查故障

  • 查看scan状态：
[oracle@new-rac2 dbs]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node new-rac2
[oracle@new-rac2 dbs]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node new-rac2
[oracle@new-rac2 dbs]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
[oracle@new-rac2 dbs]$ srvctl config scan
SCAN name: test-pro.nsfc.gov.cn, Network: 1/192.168.XX.0/255.255.255.0/em1
SCAN VIP name: scan1, IP: /test-pro/192.168.XX.XX
  • 查看crs状态：
[grid@new-rac2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       new-rac1                                     
               ONLINE  ONLINE       new-rac2                                     
ora.FRA.dg
               ONLINE  ONLINE       new-rac1                                     
               ONLINE  ONLINE       new-rac2                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       new-rac1                                     
               ONLINE  ONLINE       new-rac2                                     
ora.OCR.dg
               ONLINE  ONLINE       new-rac1                                     
               ONLINE  ONLINE       new-rac2                                     
ora.RACDB_DATA.dg
               ONLINE  OFFLINE      new-rac1                                     
               OFFLINE OFFLINE      new-rac2                                     
ora.asm
               ONLINE  ONLINE       new-rac1                 Started             
               ONLINE  ONLINE       new-rac2                 Started             
ora.gsd
               OFFLINE OFFLINE      new-rac1                                     
               OFFLINE OFFLINE      new-rac2                                     
ora.net1.network
               ONLINE  ONLINE       new-rac1                                     
               ONLINE  ONLINE       new-rac2                                     
ora.ons
               ONLINE  ONLINE       new-rac1                                     
               ONLINE  ONLINE       new-rac2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       new-rac2                                     
ora.cvu
      1        ONLINE  ONLINE       new-rac1                                     
ora.new-rac1.vip
      1        ONLINE  ONLINE       new-rac1                                     
ora.new-rac2.vip
      1        ONLINE  ONLINE       new-rac2                                     
ora.oc4j
      1        ONLINE  ONLINE       new-rac1                                     
ora.racdb.db
      1        OFFLINE OFFLINE                               Instance Shutdown   
      2        OFFLINE OFFLINE                               Instance Shutdown   
ora.racpdb.db
      1        ONLINE  ONLINE       new-rac1                 Open                
      2        ONLINE  ONLINE       new-rac2                 Open                
ora.scan1.vip
      1        ONLINE  ONLINE       new-rac2
  • 查看scan监听：
[grid@new-rac2 ~]$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-DEC-2019 09:46:21

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                03-DEC-2019 16:05:38
Uptime                    0 days 17 hr. 40 min. 42 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0/grid/log/diag/tnslsnr/new-rac2/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.XX.XX)(PORT=1521)))
Services Summary...
Service "racpdb" has 2 instance(s).
  Instance "racpdb1", status READY, has 1 handler(s) for this service...
  Instance "racpdb2", status READY, has 1 handler(s) for this service...
Service "racpdbXDB" has 2 instance(s).
  Instance "racpdb1", status READY, has 1 handler(s) for this service...
  Instance "racpdb2", status READY, has 1 handler(s) for this service...
The command completed successfully

都没问题。
想了很久，参考报错信息:
SEVERE: Error getting hostname for the cluster node new-rac1. This node may not be configured correctly
大胆猜测应该是hostname的问题。

  • 查看/etc/hosts
[grid@new-rac2 ~]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

# Public Network - (eth1)
192.168.XX.XX   new-rac1.XX.XX.XX  testpdb1
192.168.XX.XX   new-rac2.XX.XX.XX  testpdb2

# Private Interconnect - (eth4)
172.16.XX.XX    testpdb1-priv
172.16.XX.XX    testpdb2-priv

# Public Virtual IP (VIP) addresses
192.168.XX.XX    testpdb1-vip.XX.XX.XX  testpdb1-vip
192.168.XX.XX    testpdb2-vip.XX.XX.XX  testpdb2-vip

# Single Client Access Name (SCAN)
192.168.XX.XX    test-pro.XX.XX.XX

问题应该出在这里，两个名字不一样。试着修改（2个节点）

# Public Network - (eth1)
192.168.XX.XX   new-rac1.XX.XX.XX  new-rac1
192.168.XX.XX   new-rac2.XX.XX.XX  new-rac2
  • 再次配置EM：
[oracle@new-rac1 ~]$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Dec 4, 2019 10:14:43 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: racpdb
Service name: racpdb
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: new-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:  
Dec 4, 2019 10:15:40 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

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

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid
Listener port number ................ 1521
Cluster name ................ new-rac-cluster
Database unique name ................ racpdb
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

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 4, 2019 10:15:50 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racpdb/emca_2019_12_04_10_14_43.log.
Dec 4, 2019 10:15:52 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 4, 2019 10:18:01 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Dec 4, 2019 10:18:02 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 4, 2019 10:22:36 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Dec 4, 2019 10:22:38 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Dec 4, 2019 10:23:38 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Dec 4, 2019 10:23:39 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_new-rac1_racpdb to remote nodes ...
Dec 4, 2019 10:23:40 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_new-rac2_racpdb to remote nodes ...
Dec 4, 2019 10:23:44 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/new-rac1_racpdb to remote nodes ...
Dec 4, 2019 10:23:46 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/new-rac2_racpdb to remote nodes ...
Dec 4, 2019 10:23:48 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Dec 4, 2019 10:24:09 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Dec 4, 2019 10:24:27 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://new-rac1.nsfc.gov.cn:1158/em <<<<<<<<<<<
Dec 4, 2019 10:24:30 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
****************  Current Configuration  ****************
INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

racpdb            new-rac1            new-rac1.XX.XX.XX
racpdb            new-rac2            new-rac1.XX.XX.XX


Dec 4, 2019 10:24:30 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/app/oracle/product/11.2.0/dbhome_1/new-rac1_racpdb/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Dec 4, 2019 10:24:30 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: Error starting Database Control on nodes new-rac2. Execute the following command(s) on nodes: new-rac2.
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole


Error starting Database Control on nodes new-rac2. Execute the following command(s) on nodes: new-rac2.
1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole
[oracle@new-rac1 ~]$  emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://new-rac1.nsfc.gov.cn:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/new-rac1_racpdb/sysman/log

直接打开网页后控制台上报错：java.lang.Exception: No such metric - wait_bottlenecks

1.根据安装后的提示，先打开节点的dbconsole服务：

[oracle@new-rac2 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://new-rac1.nsfc.gov.cn: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/new-rac2_racpdb/sysman/log
[oracle@new-rac2 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://new-rac1.nsfc.gov.cn:1158/em/console/aboutApplication
EM Daemon is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/new-rac2_racpdb/sysman/log

2.依然报错。查看资料：
（1）在首页下方有个链接，“监视配置”，在这里重设一下监视用户dbsnmp的密码，测试成功后保存，即可解决。
测试的过程中，报错 ORA-12545:因目标主机或对象不存在。
出现这个报错，一般就是tnsnames.ora和listener.ora文件有误。再次检查tns文件，没有问题，因为tns文件的host后面跟的都是IP地址，不是hostname。再次看报错信息，提示的是和host=new-rac1-vip的连不上。恍然大悟，/etc/hosts文件中的vip name是改过的：

[oracle@new-rac2 admin]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

# Public Network - (eth1)
192.168.XX.XX   new-rac1.XX.XX.XX  new-rac1
192.168.XX.XX   new-rac2.XX.XX.XX  new-rac2

# Private Interconnect - (eth4)
172.16.XX.XX    testpdb1-priv
172.16.XX.XX    testpdb2-priv

# Public Virtual IP (VIP) addresses
192.168.XX.XX    testpdb1-vip.XX.XX.XX  testpdb1-vip
192.168.XX.XX    testpdb2-vip.XX.XX.XX  testpdb2-vip

# Single Client Access Name (SCAN)
192.168.XX.XX    test-pro.XX.XX.XX
  • 修改/etc/hosts文件：
# Public Network - (eth1)
192.168.XX.XX   new-rac1.XX.XX.XX  new-rac1
192.168.XX.XX   new-rac2.XX.XX.XX  new-rac2

..

# Public Virtual IP (VIP) addresses
192.168.XX.XX   new-rac1-vip.XX.XX.XX  new-rac1-vip
192.168.XX.XX   new-rac2-vip.XX.XX.XX  new-rac2-vip

如此看来，是安装时，crs记录的vip name，不能通过更改hosts文件修改，如果要改名字，需要修改网络配置。因为改了新的名字了，crs不认识。

（2）出现这个错误的根本原因是用sys用户登录em时，sys登陆时选择的是normal,如果选择sysdba就没有问题了，sys只能以sysdba身份登录。

shayuwei
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ORACLE 11g RAC EM手动配置
panpong的专栏
12-26 1000
ORACLE 11g RAC EM手动配置前一段通过静默安装方式配置了一套11gr2 RAC，后面再配置EM时按照上面的步骤手动配置时却不成功，症状表现是EM配置完成后，登录页面，出现如下错误:The 主机 CPU Chart could not be generated. 1.Error: Invalid BoundDataSource: no class, method or dataSour
重新配置rac的em
congshugu0910的博客
07-07 217
C:\>emca -config dbcontrol db -repos create -cluster 这个操作不能正常完成，我在log中看到如下信息：2009-7-7 11:04:27 oracle.sysman.e...
11.2 rac配置em
viviliving的专栏
09-24 181
[oracle@lzsiora1~]$more.bash_profile #.bash_profile #Getthealiasesandfunctions if[-f~/.bashrc];then .~/.bashrc fi #Userspecificenvironmentandstartupprograms PATH=$PATH:$HOME/.local/bin:$HOME/bin exportORACLE_UNQNAME=lzsio...
11.2 rac emctl start dbconsole OC4J Configuration issue
11-23 154
某RAC数据库的em在服务器重启之后，手动执行启动不能成功，错误信息如下: [oracle@jyrac1 ~]$ emctl start dbconsole OC4J Configuration issue. /u...
Oracle RAC 2 RAC DataGuard 配置文档
03-22
9. **性能优化**：在RAC 2 RAC配置中，考虑网络带宽、I/O性能和资源分配，以优化redo传输和apply过程。 10. **安全性和合规性**：DataGuard还支持加密传输和审计，确保数据安全，并满足行业法规要求。 "RAC 2 RAC ...
ORACLE10g的RAC配置
06-18
这是oracle10g的详细配置RAC的配置
oracle不能使用EM怎么办 oracle11g如何正确安装配置EM
12-16
oracle不能使用EM的解决方法，具体内容如下 不能登录EM，执行emca -config dbcontrol db 不知道总是默认1522的端口号，无奈，google一番，从下面第二步开始执行。。。（我的监听没问题） 1、打开oracle配置工具里的...
RAC listener.ora详解.docx
04-13
Oracle RAC 监听器配置文件 listener.ora 详解 Oracle RAC 监听器配置文件 listener.ora 是一个核心配置文件，用于配置 Oracle Net Listener 的参数。本文将详细介绍 listener.ora 文件的配置参数、协议地址参数、...
oracle rac资料
05-06
安装Oracle RAC涉及到多个步骤，包括集群软件（如Grid Infrastructure）的安装、Oracle数据库软件的安装和配置，以及网络设置。首先，需要在所有节点上安装Grid Infrastructure，这包括Clusterware和 ASM...
rac的em
cs309086543的博客
12-01 115
用户要求打开em，是一个10g rac的环境。上面有两个数据库 登陆到节点一，export oracle_sid，运行emctl start dbconsole，fail export第二个数据库的实例，emctl s...
ORACLE 11R2 RAC EM 安装日记
Horace_Ding的专栏
05-11 3223
ORACLE环境 1) ORACLE版本 sys@HORACLED> select * from v$version; Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE    11.2.0.3.0 
oracle em配置报错,oracle em 启动报错OC4J Configuration issue
weixin_32025789的博客
04-07 748
oracle em 启动报错OC4J Configuration issue今天在测试服务器上，启动emctlstart dbconsole的时候，报如下错误：[oracle@test ~]$ emctl start dbconsoleOC4J Configuration issue./u01/app/oracle/product/11.2.0/dbhome_1/oc4j/于是重新配置emctl ...
rac em创建
viviliving的专栏
09-25 171
[oracle@lzsiora1~]$more.bash_profile #.bash_profile #Getthealiasesandfunctions if[-f~/.bashrc];then .~/.bashrc fi #Userspecificenvironmentandstartupprograms PATH=$PATH:$HOME/.local/bin:$HOME/bin exportORACLE_UNQNAME=lzsiora e...
ORACLE RAC EM 安装步骤
白昼的技术专栏
09-30 5620
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...
oracle rac手工创建em,ORACLE 11g RAC EM手动配置
weixin_35834213的博客
04-03 496
ORACLE 11g RAC EM手动配置前一段通过静默安装方式配置了一套两个节点的11gr2 RAC，后面再配置EM却不成功，症状表现是EM配置完成后，登录页面，出现如下错误:The 主机 CPU Chart could not be generated.1.Error: Invalid BoundDataSource: no class, method or dataSource provid...
Oracle 10.2.0.5 RAC 通过emca 配置 DB Control
11-28 131
1.查看RAC环境中DB是否存在DB Control repository or Grid Control repository SQL> conn / as sysdbaConnected.SQL&g...
RAC OEM 打开无法显示CPU情况 的解决过程
好记忆也需烂博客
06-03 1613
环境：     ORACLE11G RAC+ASM,双节点。 现象：     emctl status dbconsole,    emctl start dbconsole 都没有问题。    但登录OEM后，看到显示的两节点CPU无法显示具体情况（红叉叉），其它链接也无法打开。 查看到已有高人解决了，现抄录如下： http://www.itpub.n
oracle rac手工创建em,手工创建Oracle数据库
weixin_42525189的博客
04-03 443
Oracle服务器由下列两个实体组成：实例(Instance)与数据库。实例由存储结构和进程组成，并且只短暂存在于RAM和CPU中。数据库由磁盘上的物理文件组成。实例与数据库的关系是一对一的，一个实例连接一个数据库，但也有可能是多对一的，即不同计算机上的多个实例打开共享磁盘系统上的一个公用数据库。这种多对一关系被称为实际应用群集(RealApplication Clusters，简写为RAC)。下...
Oracle-10gRAC安装及维护手册.doc
最新发布
09-08
- 用户可以控制启动和停止RAC数据库，以及数据库的EM (Enterprise Manager) 监控。 - 扩展数据库功能，如添加表空间，同时强调注意事项，以防潜在问题。 在整个安装和维护过程中，文档还提供了详细的操作指南和...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值