According to the article of My Oracle Support entitled: Grid Control Target Maintenance: Overview of Target Discovery in 10g and 11g Grid Control [ID 239224.1]
In the section of Database Discovery:
The Database targets are then assigned a target name using the format: db_name.dbdomain. If the names found in the discovery are not unique, a version number will be appended to the name. If the SP file cannot be read because of a missing OSDBA privilege, the database target will assume the name [sid]_[hostname] , the service_name parameter will be empty for the database target and the default TCP Port 1521 will be assigned to the database.
If that is the case, then how to change to Database Instance shown in the Grid Control if you want to have a consistent name of rac instances.
Here are the steps to change that:
1.
$AGENT_HOME/bin/emctl stop agent
2.
select target_name,target_type from sysman.mgmt_targets
where target_type = 'oracle_emd';
exec sysman.mgmt_admin.cleanup_agent('RAC3:3872');
3.
vi $AGENT_HOME/sysman/emd/targets.xml
(refer to targets.xml of the correct node and change to the correct database instance name accordingly).
4.
rm $AGENT_HOME/sysman/emd/upload/* -f
5.
cd $AGENT_HOME/bin
./emctl clearstate agent
./emctl secure agent
./emctl start agent
./emctl upload agent
留言列表
{{ article.title }}