Oracle 11gR2 RAC Database使用emca配置集群dbconsole

前端之家收集整理的这篇文章主要介绍了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
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
sqlEngineRemotely
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

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 \

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.1can be used. For example:

sql> alter profile default limit password_verify_function null;

5.禁用密码验证函数

[oracle@dm01db01 ~]$ sql
sql*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 23:29:28 2014
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。


INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_30_26.log.

INFO: Repository successfully created
INFO: Uploading configuration data to EM repository (this may take a while) ...
INFO: Uploaded configuration data successfully
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dm01db01_tequdb to remote nodes ...
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dm01db02_tequdb to remote nodes ...
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/dm01db01_tequdb to remote nodes ...
INFO: Propagating /u01/app/oracle/product/11.2.0.4/dbhome_1/dm01db02_tequdb to remote nodes ...
INFO: Securing Database Control (this may take a while) ...
INFO: Starting Database Control (this may take a while) ...
INFO: Database Control started successfully
INFO: >>>>>>>>>>> The Database Control URL is https://dm01db01.tequ.com:1158/em <<<<<<<<<<<
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------
tequdb dm01db01 dm01db01.tequ.com
tequdb dm01db02 dm01db01.tequ.com
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;
sql> select * from dba_profiles;
配置完成后检查是否能够正常的登录EM工具,另外还有两点需要注意:
1).emca是用操作系统oracle用户执行的。
2).不能使用IP地址访问EM工具,一定使用机器名访问,例如:https://dm01db01.tequ.com:1158/em

同时这篇文章也是对《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》的10.6.2小节的补充和完善。


来源:http://blog.itpub.net/23135684/viewspace-1188673/

原文链接:https://www.f2er.com/oracle/211526.html

猜你在找的Oracle相关文章