Oracle Autonomous Database and DevOps: A Simple Usage Approach – Part 4

This article is the fourth part of the series of articles on Oracle Autonomous Database and DevOps. For a better understanding, I recommend reading the “Oracle Autonomous Database and DevOps: A Simple Usability Approach – Part 1”, “Part 2” and “Part 3” articles before proceeding with the steps in this article. As in the previous article we treated the secure connection of the ATP instance with Oracle SQL Developer using the wallet file of the provisioned instance, in this article we will proceed with the creation of the Linux application…

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…