Oracle 11gR2 RAC Database使用emca配置集群dbconsole
发布时间：2020-12-12 15:38:49 所属栏目：百科 来源：网络整理
导读：下面的步骤详细的说明了在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-4
|
下面的步骤详细的说明了在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 WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor CONFIG: Waiting for 5 second before reconnection CONFIG: SQLEngine created successfully and connected CONFIG: Setting param: CONFIRMATION ANSWER value: 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 remote_listener string remote_login_passwordfile string EXCLUSIVE remote_os_authent boolean FALSE remote_os_roles boolean SQL> alter system set remote_listener='dm01-scan:1521'; System altered. SQL> alter system register; SQL> show parameter remote_listener NAME TYPE dm01-scan:1521 SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production [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,102); font-family:"Courier New"; font-size:16px">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",102); font-family:"Courier New"; font-size:16px">Service "tequdb" has 2 instance(s). Instance "tequdb1",102); font-family:"Courier New"; font-size:16px"> Instance "tequdb2",102); font-family:"Courier New"; font-size:16px">The command completed successfully 4.再次使用EMCA创建EM。 [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,102); font-family:"Courier New"; font-size:16px">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 INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_19_44.log. INFO: Creating the EM repository (this may take a while) ... WARNING: ORA-28003: password verification for the specified password failed ORA-20006: Password too simple SEVERE: Error creating the repository INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_repos_create_.log for more details. 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 类型: PROBLEM In this Document |