I must thank my fellow DBA Franky Weber Faust for his publication in his blog.

A database is a collection of information that is organized so that it can be easily accessed, managed and updated.Data is organized into rows, columns, and tables, and it is indexed to make it easier to find relevant information. Data gets updated, expanded and deleted as new information is added. Databases process workloads to create and update themselves, querying the data they contain and running applications against it. In the technology market, we can find a different kind of database available. Each and every database has its own method to create. In oracle, 12cR2 is the latest version. In this article, we are going to create oracle database with DBA in text mode.

How to create Oracle Database 12cR2 with DBCA in silent mode with template

This is the template I used to create this database, so feel free to download it: dbca_cdb2_new_template.dbc .Adjust the template according to your needs.

We are going to the process of creating Oracle Database 12cR2 … Execute, with the oracle user, the Database Configuration Assistant (dbca) passing the following parameters: -silent to start it in text mode, -createDatabase to create a database, -templateName Pointing to the template to be used, -gdbName for the database name, -sysPassword for the SYS password, -systemPassword for the SYSTEM password. This database will be created as nonCDB.

 

Process for creating Oracle Database 12cR2 with DBCA in silent mode with response file

Now let’s create another database, this time using a response file.

This is the response file I used to create this database, feel free to download it: dbca.rsp . In this response file I passed the template used above by changing only the parameters with the name of the database. Edit it for your needs.

Execute, with the oracle user, the Database Configuration Assistant (dbca) passing the following parameters: -silent to start it in text mode, -create database to create a database and -responseFile pointing to the response file to be used. This database will be created as a CDB.

 

This process of creating the database in text mode is very simple and is much faster than using the graphical interface.

Leave a Reply

Your email address will not be published. Required fields are marked *