If you have created and enabled a new service and then created a pluggable database, you may receive this error if you want to switch …
Read More »ORACLE
How To Reset ILOM SP(Service Processor) of Exadata Compute and Cell Node
We can reset the ILOM SP of compute nodes and cell nodes as follows: You can connect to the Ilom IP via ssh and run …
Read More »How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c
Connect to Root Container The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be …
Read More »Exadata – Disk Scrubbing Feature
Disk scrubbing exists on Exadata cell nodes to automatically repair the failed sector of the disk when the system is idle without compromising system performance. …
Read More »How To Check Object Privileges Granted to a Role or User in Oracle
To perform various operations on database objects, system and object privileges must be assigned to users. Each system privilege allows a user to perform certain …
Read More »Find UNDO Usage by Sessions
You can find the undo usage of a session with the following query. Historical information is also available. You can find the undo usage of …
Read More »Enable Trace For a Session in Oracle
You may need to enable trace for a session for many reasons. For example, you may need to determine which queries run in a session. …
Read More »PDB$SEED Database in Container Database
The PDB$SEED or SEED database is a pluggable database template for pluggable databases to be created by users. Used as a template to create new …
Read More »Apply Patch on Oracle DB Home
Steps to Apply Patch on DB Home This document shows how to apply patch on Oracle home / databases. July 2019 PSU for Oracle databases. …
Read More »Query Whether the Oracle Database is CDB or Non-CDB
You can query the CDB column in the V$DATABASE view to see if a database is CDB. If the current database is CDB, the column …
Read More »