在EM12C中添加完主机后,可通过 目标 -> 数据库 -> 添加 -> Oracle数据库 来添加要监控的数据库。
我的被监控环境为11.2.0.3的dataguard环境,添加 primary 库没有问题,但是在添加standby库,始终是 no item fond。
如图:
后来发现在standby主机上的 /etc/oratab文件中并没有相关数据库实例的记录,因为standby库是duplicate过来的,而不是dbca创建的,因此/etc/oratab没有被添加。
修改前的/etc/oratab 的内容 (On standby)
[root@xinjiang ~]# vi /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
修改后的/etc/oratab (On standby)
[root@xinjiang ~]# vi /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
prodx:/s01/app/oracle/product/11.2.0/dbhome_1:N
在standby 端 修改完 /etc/oratab文件后,再重新添加一次,就可以了,,,看来在em12c中添加目标数据库,em会去检查/etc/oratab文件,如果该文件中没有相应数据库的记录,则em就无法找到数据库。