文章目录
数据库版本: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.
问题解决
- Invalid username/password.
用户名或密码错误。可能是密码错误,也可能是口令文件失效,可以重置口令文件。 - Database is not up.
数据库没起来。 - Scan listener not up.
scan监听没起来。查看scan监听状态:
# 查看scan 监听在哪个节点上
su - grid
srvctl status scan
# 在对应节点,查看scan监听状态
lsnrctl status LISTENER_SCAN1
- 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.
- 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身份登录。