下面的步骤详细的说明了在Oracle 11gR2 RAC Database环境下使用emca配置集群dbconsole遇到的部分问题及解决的方法。
1.数据库环境。
Oracle Exadata Machine x4-2Oracle RAC Database 11.2.0.4.6 for Linux x86_64bit[root@dm01db01 ~]# uname -r2.6.39-400.126.1.el5uek2.使用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 initSQLEngineRemotelyCONFIG: SQLEngine connecting with Service Name: +ASM, oracleHome: /u01/app/11.2.0.4/grid, and user: ASMSNMP scan name: dm01-scan scan port: 1521Jun 18, 2014 10:27:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotelyWARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptorJun 18, 2014 10:27:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotelyCONFIG: Waiting for 5 second before reconnectionJun 18, 2014 10:27:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotelyCONFIG: SQLEngine connecting with Service Name: +ASM, oracleHome: /u01/app/11.2.0.4/grid, and user: ASMSNMP host: dm01db02 port: 1521Jun 18, 2014 10:27:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotelyCONFIG: SQLEngine created successfully and connectedJun 18, 2014 10:27:22 AM oracle.sysman.emcp.ParamsManager setParamCONFIG: Setting param: CONFIRMATION ANSWER value:Jun 18, 2014 10:27:28 AM oracle.sysman.emcp.ParamsManager setParamCONFIG: 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 sysasmSQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 23:18:09 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> show parameter spfileNAME TYPE------------------------------------ ---------------------------------VALUE------------------------------spfile string+DBFS_DG/cluster-clu1/asmparameterfile/registry.253.849967465SQL> show parameter remoteNAME TYPE------------------------------------ ---------------------------------VALUE------------------------------remote_listener stringremote_login_passwordfile stringEXCLUSIVEremote_os_authent booleanFALSEremote_os_roles booleanFALSESQL> alter system set remote_listener='dm01-scan:1521';System altered.SQL> alter system register;System altered.SQL> show parameter remote_listenerNAME TYPE------------------------------------ ---------------------------------VALUE------------------------------remote_listener stringdm01-scan:1521SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management options[grid@dm01db01 ~]$ lsnrctl status listener_scan1LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-JUN-2014 23:19:09Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))STATUS of the LISTENER------------------------Alias LISTENER_SCAN1Version TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionStart Date 17-JUN-2014 12:25:14Uptime 1 days 10 hr. 53 min. 55 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.oraListener Log File /u01/app/11.2.0.4/grid/log/diag/tnslsnr/dm01db01/listener_scan1/alert/log.xmlListening 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 successfully4.再次使用EMCA创建EM。
[root@dm01db01 ~]# su - oracle[oracle@dm01db01 ~]$ emca -config dbcontrol db -repos create -clusterSTARTED EMCA at Jun 18, 2014 11:19:44 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following information:Database unique name: tequdbService name: tequdbListener port number: 1521Listener ORACLE_HOME [ /u01/app/11.2.0.4/grid ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Cluster name: cluster-clu1Email 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 settingsDatabase ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0.4/gridListener port number ................ 1521Cluster name ................ cluster-clu1Database unique name ................ tequdbEmail address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/11.2.0.4/gridASM port ................ 1521ASM user role ................ SYSDBAASM username ................ ASMSNMP-----------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yJun 18, 2014 11:20:26 PM oracle.sysman.emcp.EMConfig performINFO: 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 createRepositoryINFO: Creating the EM repository (this may take a while) ...Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig createRepositoryWARNING: ORA-28003: password verification for the specified password failedORA-20006: Password too simpleJun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig invokeSEVERE: Error creating the repositoryJun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig invokeINFO: 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 performSEVERE: Error creating the repositoryRefer 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
类型:PROBLEM
In this Document
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 \
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 ~]$ sqlSQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 23:29:28 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL> set linesize 200SQL> set pagesize 200SQL> select * from dba_profiles where profile='DEFAULT';PROFILE RESOURCE_NAME RESOURCE LIMIT------------------------------ -------------------------------- -------- ----------------------------------------DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITEDDEFAULT SESSIONS_PER_USER KERNEL UNLIMITEDDEFAULT CPU_PER_SESSION KERNEL UNLIMITEDDEFAULT CPU_PER_CALL KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITEDDEFAULT IDLE_TIME KERNEL UNLIMITEDDEFAULT CONNECT_TIME KERNEL UNLIMITEDDEFAULT PRIVATE_SGA KERNEL UNLIMITEDDEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITEDDEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11GDEFAULT PASSWORD_LOCK_TIME PASSWORD 1DEFAULT PASSWORD_GRACE_TIME PASSWORD 716 rows selected.SQL> alter profile default limit password_verify_function null;Profile altered.6.使用EMCA创建EM。
[oracle@dm01db01 ~]$ emca -config dbcontrol db -repos create -clusterSTARTED EMCA at Jun 18, 2014 11:30:26 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following information:Database unique name: tequdbService name: tequdbListener port number: 1521Listener ORACLE_HOME [ /u01/app/11.2.0.4/grid ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Cluster name: cluster-clu1Email 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 settingsDatabase ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/dbhome_1Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0.4/gridListener port number ................ 1521Cluster name ................ cluster-clu1Database unique name ................ tequdbEmail address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/app/11.2.0.4/gridASM port ................ 1521ASM user role ................ SYSDBAASM username ................ ASMSNMP-----------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yJun 18, 2014 11:31:01 PM oracle.sysman.emcp.EMConfig performINFO: 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 createRepositoryINFO: Creating the EM repository (this may take a while) ...Jun 18, 2014 11:33:54 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdJun 18, 2014 11:34:03 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepositoryINFO: Uploading configuration data to EM repository (this may take a while) ...Jun 18, 2014 11:34:50 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Uploaded configuration data successfullyJun 18, 2014 11:34:50 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFilesINFO: 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 instantiateOC4JConfigFilesINFO: 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 deployStateDirsINFO: 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 deployStateDirsINFO: 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 secureDBConsoleINFO: Securing Database Control (this may take a while) ...Jun 18, 2014 11:35:39 PM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Jun 18, 2014 11:36:03 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyJun 18, 2014 11:36:03 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://dm01db01.tequ.com:1158/em <<<<<<<<<<<Jun 18, 2014 11:46:24 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessageINFO: **************** Current Configuration **************** INSTANCE NODE DBCONTROL_UPLOAD_HOST---------- ---------- ---------------------tequdb dm01db01 dm01db01.tequ.comtequdb dm01db02 dm01db01.tequ.comJun 18, 2014 11:46:24 PM oracle.sysman.emcp.EMDBPostConfig invokeWARNING: ************************ 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 successfullyFINISHED 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 UNLIMITEDDEFAULT SESSIONS_PER_USER KERNEL UNLIMITEDDEFAULT CPU_PER_SESSION KERNEL UNLIMITEDDEFAULT CPU_PER_CALL KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITEDDEFAULT IDLE_TIME KERNEL UNLIMITEDDEFAULT CONNECT_TIME KERNEL UNLIMITEDDEFAULT PRIVATE_SGA KERNEL UNLIMITEDDEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITEDDEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11GDEFAULT PASSWORD_LOCK_TIME PASSWORD 1DEFAULT PASSWORD_GRACE_TIME PASSWORD 716 rows selected.配置完成后检查是否能够正常的登录EM工具,另外还有两点需要注意:1).emca是用操作系统oracle用户执行的。2).不能使用IP地址访问EM工具,一定使用机器名访问,例如:https://dm01db01.tequ.com:1158/em同时这篇文章也是对《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》的10.6.2小节的补充和完善。--end--