--- title: "C4O - Oracle Technology - Databases v1a" canonical: "https://ai-docs.certero.com/space/CUP/119799879/C4O%20-%20Oracle%20Technology%20-%20Databases%20v1a" format: markdown --- # Document version control table | | | | --- | --- | | **Attribute** | **Setting** | | Document title | C4O - Oracle Transactions – Databases | | Document subject | Understanding the functionality of the Databases screen | | Document version | 1a | | Document category | Frequently Asked Questions (FAQ) | | Document published date | 22/01/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** How do I understand what information is being displayed in the / Oracle Technology / Databases screen, and what it means to me as a customer. # **Answer** | | | --- | | **Associated Module** | | Oracle | | | | --- | | **Navigation** | | / Oracle Technology / Databases | | | | | | --- | --- | --- | | **Header** | **Field** | **Description** | | <span style="color: #000000">Summary</span> | <span style="color: #000000">Unique Name</span> | <span style="color: #000000">This is the unique Database name.</span> | | | <span style="color: #000000">Edition</span> | <span style="color: #000000">This is the edition of Database which has been detected. It will reflect either ‘Enterprise’ or ‘Standard’.</span> | | | <span style="color: #000000">Version</span> | <span style="color: #000000">This is the current version of the Database. Certero automatically restricts at 1 decimal place.</span> | | | <span style="color: #000000">Platform</span> | <span style="color: #000000">This reflects the Operating Systems software that is installed on the host.</span> | | | <span style="color: #000000">Clustered</span> | <span style="color: #000000">Yes / No – reflects whether the host is a member of a cluster. Caution, where it’s a member of a single node cluster then this will still reflect Yes.</span> | | | <span style="color: #000000">Instances</span> | <span style="color: #000000">Reflects how may instances there are within Certero.</span> | | | <span style="color: #000000">Excluded</span> | <span style="color: #000000">Yes / No – Where excluded then the data will not be included in the compliance reporting, or in the OSW documentation / GLAS extracts. You can amend the value by using the mouse right click on the database / Actions / Set Status and Comments.</span> | | | <span style="color: #000000">Licensable Options</span> | <span style="color: #000000">This reflects how many potentially chargeable Options & Packs have been detected.</span> | | | <span style="color: #000000">Multitenant</span> | <span style="color: #000000">The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and no schema objects that appears to an Oracle Net client as a non-CDB.</span> | | | <span style="color: #000000">DBID</span> | <span style="color: #000000">The DBID is an internal, uniquely generated number that differentiates databases. Oracle creates this number automatically as soon as you create the database.</span> | | | <span style="color: #000000">Container DBID</span> | <span style="color: #000000">An Oracle container DBID is a unique identifier for a container database (CDB). A CDB is a collection of databases that share common features.</span> | | | <span style="color: #000000">Named Users</span> | <span style="color: #000000">This is the amount of named users which have been defined against the database. The defined quantities can be using the ‘Named User Criteria’ within the database properties. You can use the Query Builder or Group Membership to define the quantity.</span> | | | <span style="color: #000000">Comment</span> | <span style="color: #000000">This is a free text cell. You can add comments using the mouse right click on the database / Actions / Set Status and Comments.</span> | | <span style="color: #000000">Database Info</span> | <span style="color: #000000">Unique ID</span> | <span style="color: #000000">This is the unique Database name.</span> | | | <span style="color: #000000">Name</span> | <span style="color: #000000">This is the name by which the database is known.</span> | | | <span style="color: #000000">Database Role</span> | <span style="color: #000000">Primary / Secondary: The primary role is the role of the database that is currently active, while the secondary role is the role of the database that is currently in standby.</span> | | | <span style="color: #000000">Open Mode</span> | <span style="color: #000000">Determines whether it is available for general use, or if it is restricted to database administrators.</span> | | | <span style="color: #000000">Log Mode</span> | <span style="color: #000000">Oracle database log mode is a setting that controls how Oracle saves and manages log files. The two main log modes are ARCHIVELOG mode and NOARCHIVELOG mode.</span> | | | <span style="color: #000000">Control File Type</span> | <span style="color: #000000">Type of control file:</span><br><span style="color: #000000">**STANDBY**</span><span style="color: #000000"> - Indicates that the database is in standby mode</span><br><span style="color: #000000">**CLONE**</span><span style="color: #000000"> - Indicates a clone database</span><br><span style="color: #000000">**BACKUP**</span><span style="color: #000000"> | </span><span style="color: #000000">**CREATED**</span><span style="color: #000000"> - Indicates the database is being recovered using a backup or created control file</span><br><span style="color: #000000">**CURRENT**</span><span style="color: #000000"> - database is available for general use</span> | | | <span style="color: #000000">Switchover Status</span> | <span style="color: #000000">The Oracle database switchover status indicates the role of a database, whether a switchover is allowed, and the status of a switchover request.</span> | | | <span style="color: #000000">Environment </span> | <span style="color: #000000">This is a cosmetic definition where the customer can define the environment type from a drop-down list. It helps when attributing hosts to license types etc.</span> | | | <span style="color: #000000">Created</span> | <span style="color: #000000">This defines the date when the database was initially created.</span> | | <span style="color: #000000">Connection</span> | <span style="color: #000000">Unique Name</span> | <span style="color: #000000">This is the unique Database name.</span> | | | <span style="color: #000000">Connection String</span> | <span style="color: #000000">This gives important information with regards to how Certero will connect with the database.</span> | | | <span style="color: #000000">First Inventory</span> | <span style="color: #000000">This is the Date / Time stamp for the initial successful inventory of the database. Generally, this indicates the start date for where license entitlement should have been procured</span> | | | <span style="color: #000000">Last Inventory</span> | <span style="color: #000000">This is the Date / Time stamp for the last successful inventory of the database. Where the date is older than the period between the connectors running (e.g Weekly / monthly) then this might indicate a problem with the connector, or that the connector has been archived. Where the connector has been archived then there is a manual requirement to archive the database within Oracle Technology / Databases. Until archived / excluded then the database will consume license entitlement.</span> | Documentation was created using information from Certero Version: 8.7.233.39317 <sup>1</sup> <sup>I</sup>