Change the Oracle Listener for multiple Instance at once
説明
The Databases Dashboard only allows to configure Listener settings one instance at a time but it is required to update massive Oracle Agents to share the same listener at once.
対策
This task can be achieved from the Agent status Dashboard.
Go to Administration | Agents | Agent Status
Select a sample Oracle Agent.
Under "Listener Name" field, create a new setting for listener or Clone the working ASP secondary configuration from a Oracle that has the required listener and give a custom name.
Return to Agent Status and do a multiple selection of all Oracle Agents with Edit Properties.
Tick he "Listener Name" box and Select the cloned/created ASP Property with listener setting.
Hit Save.
Return to Agent Status screen and Deactivate / Activate the Oracle Agents to refresh the change.
Repeat steps for DB_Oracle and also for DB_Oracle_RAC_Instance if required.