Discover Autonomous Databases Using EM CLI
You can use the Oracle Enterprise Manager Command Line Interface (EM CLI)
verb add_cloud_db_target
, to discover an Autonomous Database in Oracle
Enterprise Manager.
Format
emcli add_cloud_db_target
-target_name="target_name"
-target_type="target_type"
-agent_host="agent_host"
-zip_file_location="cred_file_zip_location"
-credentials="UserName:<db_username>;password:<db_password>;Role:<db_user_role>"
-wallet_password="wallet_password"
-service_name="tns_service_name"
[-is_dedicated="is_dedicated"]
[-standby_agent_host="standby_agent_host"]
Options
-target_name
: Name of the Autonomous Database target.-target_type
: Type of Autonomous Database. The target type value for Autonomous Data Warehouse databases isoracle_cloud_adw
and the value for Autonomous Transaction Processing databases isoracle_cloud_atp
.-agent_host
: Host on which the agent that you are using to discover the Autonomous Database is installed and running.-zip_file_location
: Location of the Oracle Cloud Infrastructure Client Credentials (Wallet).zip
file. The.zip
file location should be accessible from the OMS host.-credentials
: Monitoring user credentials. It is recommended that you use theadbsnmp
user account. See About User Accounts.-wallet_password
: The wallet password set in the Oracle Cloud Infrastructure console when downloading the OCI Client Credential Wallet.-service_name
: Predefined database service name of the Autonomous Database. Thelow
database service is the default value and to perform monitoring and management tasks, it is recommended that you use thelow
database service.Note that Oracle Enterprise Manager supports both TCP and TCPS using the TLS protocol for Autonomous Databases – Dedicated, and only TCPS using the TLS protocol for Autonomous Databases – Serverless. The default protocol for Autonomous Databases – Dedicated is TCP.
For information on Database Service Names, see the Predefined Database Service Names for Autonomous Database section in the documentation for the Autonomous Database you are discovering.
-is_dedicated
:True
for an Autonomous Database – Dedicated andFalse
for an Autonomous Database – Serverless. If a value is not specified for this parameter, then it defaults to Autonomous Database – Serverless.-standby_agent_host
: Host on which a backup agent is installed. If the primary agent goes down or crashes, then the backup agent monitors the target. This is an optional parameter.
Example
emcli add_cloud_db_target
-target_name="ATPD1"
-target_type="oracle_cloud_atp"
-agent_host="myhostname.example.com"
-zip_file_location="/u01/oracle/atpd/wallet_ATPD1.zip"
-credentials="UserName:adbsnmp;password:password;Role:Normal"
-wallet_password="password"
-service_name="ATPD1_low"
-is_dedicated="True"
-standby_agent_host="standbyhostname.example.com"