PDB status


Job details

Name: PDB status
Platform: Oracle
Category: Availability
Description: Alerts if PDB is not in correct state
Long description: Alerts if PDB is not in correct state
Version: 0.1
Default schedule: * * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & is_containerdb=‘YES’]

Parameters

Name Default value Description
Correct state READ WRITE Job will send alerts if pluggable databases are not in this state
Ignored pdbs PDB$SEED Comma separated list of pdbs that are ignored
Type of alarm 2 What alarm signal to send if PDB‘s are in wrong state. 2=Alarm, 1=Warning, 0=OK
History max time 365 How long should we keep data for, in days

Job Summary

SELECT con_id, name, open_mode FROM sys.v$pdbs;

Description and Functionality

Implementation Details

Dependencies and Concerns

Reporting and Alerts

Operational Schedule

Version and Ownership

This comprehensive monitoring setup ensures that any deviations from expected PDB states are quickly identified, reported, and, ideally, rectified, thus maintaining the integrity and performance of the Oracle database environment.