Oracle 11gR2 RAC Database使用emca配置叢集dbconsole
下面的步驟詳細的說明了在Oracle 11gR2 RAC Database環境下使用emca配置叢集dbconsole遇到的部分問題及解決的方法。
1.資料庫環境。
Oracle Exadata Machine x4-2
Oracle RAC Database 11.2.0.4.6 for Linux x86_64bit
[root@dm01db01 ~]# uname -r
2.6.39-400.126.1.el5uek
2.使用EMCA建立EM。
[root@dm01db01 ~]# su - oracle
[oracle@dm01db01 ~]$ emca -config dbcontrol db -repos create -cluster
......
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
......
收到ORA-12514報錯。
emca工具輸出的日誌被存放在$GRID_BASE/cfgtoollogs/emca目錄下。
檢視/u01/app/grid/cfgtoollogs/emca/emca_2014_06_18_10_26_50.log日誌：
......
Jun 18, 2014 10:27:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: SQLEngine connecting with Service Name: +ASM, oracleHome: /u01/app/11.2.0.4/grid, and user: ASMSNMP scan name: dm01-scan scan port: 1521
Jun 18, 2014 10:27:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Jun 18, 2014 10:27:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: Waiting for 5 second before reconnection
Jun 18, 2014 10:27:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: SQLEngine connecting with Service Name: +ASM, oracleHome: /u01/app/11.2.0.4/grid, and user: ASMSNMP host: dm01db02 port: 1521
Jun 18, 2014 10:27:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
CONFIG: SQLEngine created successfully and connected
Jun 18, 2014 10:27:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value:
Jun 18, 2014 10:27:28 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value: no
從最後面的日誌可以看出，報ORA-12514錯誤的原因是不能通過SCAN LISTENER連線到ASM例項，說明ASM例項沒有向SCAN LISTENER動態註冊。
3.ASM例項向SCAN LISTENER動態註冊。
[root@dm01db01 ~]# su - grid
[grid@dm01db01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 23:18:09 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter spfile
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
spfile string
+DBFS_DG/cluster-clu1/asmparam
eterfile/registry.253.84996746
5
SQL> show parameter remote
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
remote_listener string
remote_login_passwordfile string
EXCLUSIVE
remote_os_authent boolean
FALSE
remote_os_roles boolean
FALSE
SQL> alter system set remote_listener='dm01-scan:1521';
System altered.
SQL> alter system register;
System altered.
SQL> show parameter remote_listener
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
remote_listener string
dm01-scan:1521
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@dm01db01 ~]$ lsnrctl status listener_scan1
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-JUN-2014 23:19:09
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 17-JUN-2014 12:25:14
Uptime 1 days 10 hr. 53 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0.4/grid/log/diag/tnslsnr/dm01db01/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.3.16)(PORT=1521)))
Services Summary...
Service "+ASM" has 2 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "tequdb" has 2 instance(s).
Instance "tequdb1", status READY, has 1 handler(s) for this service...
Instance "tequdb2", status READY, has 1 handler(s) for this service...
The command completed successfully
4.再次使用EMCA建立EM。
[root@dm01db01 ~]# su - oracle
[oracle@dm01db01 ~]$ emca -config dbcontrol db -repos create -cluster
STARTED EMCA at Jun 18, 2014 11:19:44 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: tequdb
Service name: tequdb
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:
Cluster name: cluster-clu1
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:
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0.4/grid
Listener port number ................ 1521
Cluster name ................ cluster-clu1
Database unique name ................ tequdb
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
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jun 18, 2014 11:20:26 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_19_44.log.
Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig createRepository
WARNING: ORA-28003: password verification for the specified password failed
ORA-20006: Password too simple
Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_repos_create_<date>.log for more details.
Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_19_44.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_19_44.log for more details.
這個告警參考如下MOS文章：
EMCA: RepManager Fails With Password Verification Error ORA-28003 (文件 ID 779098.1)
修改時間:2013-10-23
型別:PROBLEMIn this Document
| Symptoms |
| Cause |
| Solution |
| References |
| This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
APPLIES TO:
Enterprise Manager Base Platform - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]Information in this document applies to any platform.
Checked for relevance on 22-Oct-2013
SYMPTOMS
While using EMCA to create DB Console repository, this fails with:
CONFIG: ORA-28003: password verification for the specified password failed
ORA-20003: Password should contain at least one \
ORA-20003: Password should contain at least one \
CAUSE
This is treated in internal BUG 4195090.
SOLUTION
a) Disable the Password verification
b) Create the Repository
c) Enable the password verification.
Note: For disabling the password verification function, Note 114930.1 can be used. For example:
SQL> alter profile default limit password_verify_function null;
5.禁用密碼驗證函式。
[root@dm01db01 ~]# su - oracle
[oracle@dm01db01 ~]$ sql
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 23:29:28 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> set linesize 200
SQL> set pagesize 200
SQL> select * from dba_profiles where profile='DEFAULT';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7
16 rows selected.
SQL> alter profile default limit password_verify_function null;
Profile altered.
6.使用EMCA建立EM。
[oracle@dm01db01 ~]$ emca -config dbcontrol db -repos create -cluster
STARTED EMCA at Jun 18, 2014 11:30:26 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: tequdb
Service name: tequdb
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:
Cluster name: cluster-clu1
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:
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1
Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0.4/grid
Listener port number ................ 1521
Cluster name ................ cluster-clu1
Database unique name ................ tequdb
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
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jun 18, 2014 11:31:01 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_30_26.log.
Jun 18, 2014 11:31:14 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 18, 2014 11:33:54 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jun 18, 2014 11:34:03 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jun 18, 2014 11:34:50 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jun 18, 2014 11:34:50 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dm01db01_tequdb to remote nodes ...
Jun 18, 2014 11:34:52 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dm01db02_tequdb to remote nodes ...
Jun 18, 2014 11:34:54 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/dm01db01_tequdb to remote nodes ...
Jun 18, 2014 11:34:55 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/dm01db02_tequdb to remote nodes ...
Jun 18, 2014 11:34:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jun 18, 2014 11:35:39 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jun 18, 2014 11:36:03 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jun 18, 2014 11:36:03 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://dm01db01.tequ.com:1158/em <<<<<<<<<<<
Jun 18, 2014 11:46:24 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------
tequdb dm01db01 dm01db01.tequ.com
tequdb dm01db02 dm01db01.tequ.com
Jun 18, 2014 11:46:24 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0.4/dbhome_1/dm01db01_tequdb/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jun 18, 2014 11:46:24 PM
成功建立EM。
7.重新啟用密碼驗證函式。
SQL> alter profile default limit password_verify_function VERIFY_FUNCTION_11G;
Profile altered.
SQL> select * from dba_profiles;
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7
16 rows selected.
配置完成後檢查是否能夠正常的登入EM工具，另外還有兩點需要注意：
1).emca是用作業系統oracle使用者執行的。
2).不能使用IP地址訪問EM工具，一定使用機器名訪問，例如：https://dm01db01.tequ.com:1158/em
同時這篇文章也是對《構建最高可用Oracle資料庫系統：Oracle 11gR2 RAC管理、維護與效能優化》的10.6.2小節的補充和完善。
--end--
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26736162/viewspace-2025733/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle 11g rac配置em dbconsole ORA-12514Oracle
- Oracle 11gR2 RAC 叢集服務啟動與關閉總結Oracle
- Oracle 11gr2修改RAC叢集的scan ip,並處理ORA-12514問題Oracle
- oracle RAC 診斷叢集狀態命令Oracle
- oracle 11.2.0.4 rac叢集等待事件enq: TM - contentionOracle事件ENQ
- Oracle叢集（RAC）時間同步（ntp和CTSS）Oracle
- Oracle RAC 11gR2開啟歸檔Oracle
- Oracle 11gR2 RAC 單網路卡轉雙網路卡繫結配置Oracle
- Oracle RAC日常運維-NetworkManager導致叢集故障Oracle運維
- 【ASK_ORACLE】Relink RAC叢集詳細步驟Oracle
- 小知識：使用oracle使用者檢視RAC叢集資源狀態Oracle
- Oracle Linux 6.7中 Oracle 11.2.0.4 RAC叢集CRS異常處理OracleLinux
- 沃趣微講堂 | Oracle叢集技術（二）：GI與Oracle RACOracle
- ORACLE 11GR2 RAC的網路規劃解析Oracle
- Disable Database Audit In Oracle 19c RAC-20220111DatabaseOracle
- oracle 12C RAC 12.1.0.2 叢集日誌（cluster log)目錄Oracle
- rac叢集日常維護命令
- ORACLE RAC 11.2.0.4 FOR RHEL6叢集無法啟動的處理Oracle
- 11gR2 RAC convert ONENODE
- 11gR2 OneNode Convert RAC
- oracle RAC手動配置互信Oracle
- Oracle 例項和RAC叢集下資料庫日誌目錄合集Oracle資料庫
- Oracle Database 19c(19.9) RAC On RedHat 8.3 Using VirtualBox and MacBookOracleDatabaseRedhatMac
- redis偽叢集配置Cluster叢集模式Redis模式
- Kafka叢集配置Kafka
- Oracle RAC叢集解除安裝步驟Oracle
- Oracle 11G RAC叢集安裝（3）——安裝OracleOracle
- 私有IP丟失造成Oracle 12C RAC叢集節點不能啟動Oracle
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- 【BUILD_ORACLE】Oracle 19c RAC搭建（三）使用UDEV配置共享儲存UIOracledev
- Oracle叢集時間同步Oracle
- Docker Elasticsearch 叢集配置DockerElasticsearch
- 【NETWORK】Oracle RAC 心跳地址配置說明Oracle
- Oracle叢集技術 | 叢集的自啟動系列（一）Oracle
- 紅色警報 ORACLE RAC 11.2.0.4 FOR SOLARIS 10 ASM 和DB因叢集心跳丟失重啟OracleASM
- ORACLE RAC 11.2.0.4 ASM加盤導致叢集重啟之ASM sga設定過小OracleASM
- 11gR2 RAC新增節點步驟
- Oracle叢集軟體管理-新增和刪除叢集節點Oracle
- Oracle Database 12c RAC損壞ocr和votedisk恢復實驗OracleDatabase