C4O – Oracle Scripting - Oracle Container Databases (CDB’s)
Document version control table
Attribute | Setting |
Document title | C4O – Oracle Connector – Deleted connectors keep returning |
Document subject | https://certero.zendesk.com/agent/tickets/14020 |
Document version | 1a |
Document category | Frequently Asked Questions (FAQ) |
Document published date | 08/04/2025 |
Technical level | 100 |
Hosting type | On premise & SaaS provisioned |
Product name | Certero for Oracle |
Product version | 8.x |
Module | Certero for Oracle Database |
Connector | Certero for Oracle Database Database Connector |
Question
Does Certero have any guidance or scripts specific to performing inventory scans on Oracle Container Databases (CDB’s) .
Answer
The following file gives more details, and includes a copy of the scripts used: https://help.certero.com/hc/en-gb/articles/206511039-What-permissions-does-Certero-for-Oracle-need-to-perform-an-inventory-of-an-Oracle-Database
at the bottom of the link there is a script that can be downloaded.
The script contains a line that gives the service account permissions to read the pluggables.
EXECUTE IMMEDIATE 'ALTER USER ' || db_user ||' SET CONTAINER_DATA=ALL CONTAINER=CURRENT'
Last line in the script. If it is not a container database, you need to comment out this line or the script fails.
When adding the users to the connector the user for the container database must be of the format C##. This is known as a common user
A good Oracle URL to consider reading is: https://docs.oracle.com/database/121/ADMQS/GUID-DA54EBE5-43EF-4B09-B8CC-FAABA335FBB8.htm
The question was asked in Ticket: 14020: https://certero.zendesk.com/agent/tickets/14020
1
I