Check whether the database uses Oracle Multitenant Architecture; it is a simple operation. You can check this feature by querying the v$database using the CDB field as in the SQL example below: Additionally, in case your database is a multitenant database, you can visualize it by using the following query: Published: 08/11/2018Updated: 12/04/2023 brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries…
Tag: cdb
Creating a CDB database by command line
Sometimes the Oracle DBA needs to create a CDB database without DBCA. This procedure is possible. However, it is needed some additional steps to be done. For instance, to run some scripts to create components who DBCA utilitty create automatically. Therefore, in this post I am going to show how to create a CDB database by command line: Create directories for the Oracle Database. As the database will be named “db2”, some file system structures will contain this word: Create the init<SID>.ora file at $ORACLE_HOME/dbs: Start the…