Creating Database on Oracle Database 18cR1 using DBCA Gui and then Silent

Creating Database on Oracle Database 18cR1 using DBCA Gui & then Silent.

Sounds tricky?, yes it is bit tricky. To create Database in Oracle Database 18cR1, we’ll need to use both dbca utility GUI as well as Silent. However it would not take a long time here. We’ll going to do it very quickly. If you haven’t installed 18c yet you may follow this guide for step by step installation.

Let’s Start.


1. Check if your .bash_profile is pointing to Oracle Database 18c home, and then launch Installation Wizard by typing dbca on linux terminal.

DBCA 18cR1


  • Select Create a database and click NEXT.

DBCA 18cR1


  • Select Advanced configuration and click NEXT.

DBCA 18cR1


  • Select Oracle Single Instance database and select General Purpose or Transaction Processing and click NEXT.

DBCA 18cR1


  • Enter the name of your database and click NEXT.

DBCA 18cR1


  • Select Storage options and click NEXT.

DBCA 18cR1Note: Optionally you can also multiplex of logs and control files.


  • Here I’m using three way multiplexing. click Okay to proceed.

DBCA 18cR1


  • Specify Fast Recovery Area and click NEXT.

DBCA 18cR1


  • Verify the Listener settings and click NEXT.

DBCA 18cR1


  • Configure Database vault if you want. click NEXT.

DBCA 18cR1


  • Specify SGA and PGA for your database and click NEXT.

DBCA 18cR1


  • Specify Port for Enterprise Manager Database Express and click NEXT.

DBCA 18cR1


  • Set Administrator’s password and click NEXT.

DBCA 18cR1


  • Customize your storage selection if you want and click NEXT.

DBCA 18cR1


  • Verify your selections and click Finish. Before you click on Finish, do not forget to save response file.

DBCA 18cR1


  • Database creation in progress.

DBCA 18cR1


Oops! ORA-12754.DBCA 18cR1No prob chill, we have hack for this. let’s click on abort.


2. Now the silent mode comes into picture.

Before we proceed with silent, we’ll have to make one small change in a response file. We need to add one magic line 😛

DBCA 18cR1This is the line. Let’s add it.


  • Edit your saved response file using VI or any other text editor.
[oracle@dbnode1 ~]$ vi dbca_DEMTEST.rsp
  • Go to Initialization Parameter section in your response file.
#-----------------------------------------------------------------------------
# Name : initParams
# Datatype : String
# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
  • Add hidden parameter “_exadata_feature_on=true” in parameter file and then save and exit.
_initParams=undo_tablespace=UNDOTBS1,sga_target=1155MB,db_block_size=8192BYTES,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=DEMTESTXDB),diagnostic_dest={ORACLE_BASE},remote_login_passwordfile=EXCLUSIVE,db_create_file_dest=+DATA/{DB_UNIQUE_NAME}/,db_create_online_log_dest_3=/home/oracle/redo,db_create_online_log_dest_2=/u02/app/oracle/oradata,db_create_online_log_dest_1=/u01/app/oracle/oradata,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,processes=300,pga_aggregate_target=385MB,nls_territory=AMERICA,local_listener=LISTENER_DEMTEST,db_recovery_file_dest_size=25500MB,open_cursors=300,log_archive_format=%t_%s_%r.dbf,compatible=18.0.0,db_name=DEMTEST,db_recovery_file_dest=+FRA,audit_trail=db,_exadata_feature_on=true

[ESC] > :wq > Enter (to save and exit)


  • Let’s now initiate DBCA in silent mode.
[oracle@dbnode1 ~]$ dbca -silent -createDatabase -responseFile ./dbca_DEMTEST.rsp
Enter SYS user password:

Enter SYSTEM user password:
  • Enter password for SYS and SYSTEM users.
[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.
Prepare for db operation
10% complete
Registering database with Oracle Restart
14% complete
Copying database files
43% complete
Creating and starting Oracle instance
45% complete
49% complete
53% complete
56% complete
62% complete
Completing Database Creation
68% complete
71% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/DEMTEST.
Database Information:
Global Database Name:DEMTEST
System Identifier(SID):DEMTEST
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/DEMTEST/DEMTEST0.log" for further details.

And here we go. it’s created now. Let’s invoke SQL*PLUS and check few things on newly created 18c Database.


SQL> select name,open_mode,host_name,version from v$database,v$instance;

NAME      OPEN_MODE            HOST_NAME                 VERSION
--------- -------------------- ------------------------- -----------------
DEMTEST   READ WRITE           dbnode1.demunix.com       18.0.0.0.0

As we can see, our database named DEMTEST is now been created on Oracle Database 18cR1.

 

Peace 🙂