dbcontrol console 创建注意事项

  很多朋友在创建em时出现这样那样的问题，在此简单总结一下：

一、em console 创建检查

  1. 环境变量检查，确保如下变量正确设置

ORACLE_HOME
ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib
On AIX: LIBPATH=$LD_LIBRARY_PATH;$ORACLE_HOME/lib32
TNS_ADMIN=<TNS Admin directory> : In case listener is running from non default location

  2. 数据库连接性检查

通过tnsnames连接 conn sys/passwod@tnsnames as sysdba, conndbsnmp/password@tnsnames

 3.  检查主机名和端口

     hostname  ifconfig

如果使用了dns，使用如下命令
$ nslookup <hostname>

确保/etc/hosts中配置了如下解析
127.0.0.1 localhost.localdomain localhost
<ip address> hostname.domain hostname

各组件使用端口一览，确保如下端口可以使用

- JMS [5540-5559] ---> only one port is needed from this range (say 5540)
- RMI [5520-5539] ---> only one port is needed from this range (say 5520)
- Database Control [1158, 5500-5519] ---> only one port is needed from this range (say 5500)
- EM Agent [3938] | [1830-1849] ---> only one port is needed from this range (say 3938)

   4. 检查数据库

数据库权限检查：

utl_smtp
utl_tcp
utl_file
dbms_sql
dbms_obfuscation_toolkit

数据库参数及组件

audit_sys_operations=TRUE
audit_trail='OS'
NLS_SORT  view dba_registry
NLS_COMP view dba_registry

确认数据库对象

SQL > select USERNAME from dba_users where USERNAME in ('SYSMAN','MGMT_VIEW','MGMT_USER');  --确认用户
SQL > SELECT owner, synonym_name name FROM dba_synonyms WHERE table_owner = 'SYSMAN';  --确认无同义词
SQL > select OBJECT_NAME, OWNER from dba_objects where OWNER in ('SYSMAN','MGMT_VIEW','MGMT_USER'); --确认无对象

---删除参考文档：How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g [ID 278100.1]

9876

 

How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g [ID 278100.1]

…

 

 

二、 创建EM console

  1.  单节点创建：

emca -repos create     创建一个EM资料库  会创建SYSMAN账号
#emca -repos recreate 重建一个EM资料库
emca -repos drop        删除一个EM资料库
emca -config dbcontrol db   配置数据库的 Database Control

emca -deconfig dbcontrol db  删除数据库的 Database Control配置
emca -config dbcontrol db -repos create
emca -config dbcontrol db -repos recreate 重建EM资料库并配置

  2.  HA环境创建：参考文档

Configure DB Control 10.2, 11g for use in Active/Passive High Availability Environments [ID 362524.1]

  3.  RAC环境创建：

 

三、 EM  console 管理

   1. 修改默认端口

 

$ emca -reconfig ports -DBCONTROL_HTTP_PORT 1160 -AGENT_PORT 3940 -RMI_PORT 5523 -JMS_PORT 5543

$ emca -reconfig ports -cluster -DBCONTROL_HTTP_PORT <port_number> -RMI_PORT <port_number> -JMS_PORT <port_number> -AGENT_PORT <port_number>

Example:
$ emca -reconfig ports -cluster -DBCONTROL_HTTP_PORT 1159 -AGENT_PORT 3939 -RMI_PORT 5522 -JMS_PORT 5542

Enterprise Manager Console HTTP Port (prodrh) = 5500
Enterprise Manager Agent Port (prodrh) = 3938
Enterprise Manager Console HTTP Port (prodmkg) = 5501
Enterprise Manager Agent Port (prodmkg) = 1830

 
-DBCONTROL_HTTP_PORT <port_number>
-RMI_PORT <port_number>
-JMS_PORT <port_number>
-AGENT_PORT <port_number>

 

 2  修改IP地址

 3 修改主机名

 

四、 em console 创建常见的问题

  1. RAC dbcontrol中有如下警告：
 MemberShip Configuration
 The membership configured for the cluster database does not match the instance list of the database. Please update your configuration from the following link:
Database Configuration

 

  2. ps: 0509-048 Flag -o was used with invalid list.
ps: Not a recognized flag: -
Usage: ps [-ANPaedfklmMZ] [-n namelist] [-F Format] [-o specifier[=header],...]
                [-p proclist][-G|-g grouplist] [-t termlist] [-U|-u userlist] [-c classlist] [ -T pid] [ -L pidlist]
Usage: ps [aceglnsuvwxU] [t tty] [processnumber]

参考MOS文档ID：758568.1

 

  3.  emctl.trc有如下报错
 
009-08-14 19:20:15 Thread-1958 ERROR http: 11: Unable to initialize ssl connection with server, aborting connection attempt
2009-08-14 19:20:15 Thread-1958 ERROR pingManager: nmepm_pingReposURL: Cannot connect tohttps://host:1158/em/upload/: retStatus=-1
2009-08-14 19:20:15 Thread-1958 ERROR ssl: Open wallet failed, ret = 28750
2009-08-14 19:20:15 Thread-1958 ERROR ssl: nmehlenv_openWallet failed
在文档：749243.1 有如下解决方法：
 

  4. emctl.trc：

2010-11-15 20:39:50 Thread-1 ERROR ssl: nzos_Handshake failed, ret=29024
2010-11-15 20:39:50 Thread-1 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt
2010-11-15 20:39:59 Thread-1 ERROR ssl: nzos_Handshake failed, ret=29024

在2010-12月后，10.2.0.4 及10.2.0.5 版本的em新建需要下载补丁安装，补丁号：8350262

 

Troubleshooting Dbconsole EMCA Failures Due to Hostname and Port Related Issues [ID 1107743.1]