EM12C 无法发现新数据库目标

在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就无法找到数据库。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值