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.
[oracle@oracle-srv ~]$ dbca -silent -createDatabase -templateName /u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/dbca_cdb2_new_template.dbc -gdbName cdb2 -sysPassword oracle -systemPassword oracle [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Copying database files 1% complete 2% complete 18% complete 33% complete Creating and starting Oracle instance 35% complete 40% complete 44% complete 49% complete 50% complete 53% complete 55% complete Completing Database Creation 56% complete 57% complete 58% complete 62% complete 65% complete 66% complete Executing Post Configuration Actions 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb2/cdb26.log" for further details. Database created successfully.
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.
[oracle@oracle-srv ~]$ dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Copying database files 1% complete 13% complete 25% complete Creating and starting Oracle instance 26% complete 30% complete 31% complete 35% complete 38% complete 39% complete 41% complete Completing Database Creation 42% complete 43% complete 44% complete 46% complete 47% complete 50% complete Creating Pluggable Databases 55% complete 75% complete Executing Post Configuration Actions 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb3/cdb3.log" for further details.
This process of creating the database in text mode is very simple and is much faster than using the graphical interface.
