Add Oracle Pluggable Database

You can add Oracle Pluggable Database entities using the Add Entity UI or using the cloud agent command line interface (omcli) with the appropriate JSON files.

Step 2: Add the Oracle Pluggable Database using omcli and the Appropriate JSON Files

  1. Download and extract the required JSON file(s) from the master JSON zip file. See the table below for the specific JSON files you'll need.
  2. Edit the file(s) and specify the requisite properties shown below.
    Oracle Pluggable Database (PDB) (Standalone) JSON Properties and Files

    Definition File: omc_oracle_pdb_sample.json

    • displayName: This is Oracle Pluggable Database (PDB) Entity Display Name which is displayed on Infrastructure Monitoring UI
    • timezoneRegion: Time Zone Example: PDT, GMT etc
    • host_name : Fully-qualified Host Name for the Oracle Pluggable Database (PDB)
    • omc_pdb_tbsp_port: Oracle Pluggable Database (PDB) port
    • omc_pdb_tbsp_service_name: Oracle Pluggable Database (PDB) Service Name

    Credential File: omc_oracle_pdb_cred_sample.json

    • DBUserName: Oracle Pluggable Database (PDB)username
    • DBPassword: Oracle Pluggable Database (PDB) user's password
  3. Add the entity using omcli.
    omcli add_entity agent DEFINITION_FILE [-credential_file CREDENTIAL_FILE [-encryption_method_gpg]] 
  4. Verify the status of the newly added entity.
    omcli status_entity agent DEFINITION_FILE

See step 4. Adding Entities to Your Service of Add Entities Using JSON Files for more information.

Step 3: (Optional but recommended) Set up alerts.

To enable lights-out monitoring, you can set up alert rules to generate alerts and send notifications if your entities have performance issues.

See Set Up Alert Rules and Set Up Alert Thresholds and Notifications.

Troubleshooting

If you run into any issues regarding discovery or monitoring of Oracle Pluggable Database, see the following: