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.
- Select Create a database and click NEXT.
- Select Advanced configuration and click NEXT.
- Select Oracle Single Instance database and select General Purpose or Transaction Processing and click NEXT.
- Enter the name of your database and click NEXT.
- Select Storage options and click NEXT.
Note: Optionally you can also multiplex of logs and control files.
- Here I’m using three way multiplexing. click Okay to proceed.
- Specify Fast Recovery Area and click NEXT.
- Verify the Listener settings and click NEXT.
- Configure Database vault if you want. click NEXT.
- Specify SGA and PGA for your database and click NEXT.
- Specify Port for Enterprise Manager Database Express and click NEXT.
- Set Administrator’s password and click NEXT.
- Customize your storage selection if you want and click NEXT.
- Verify your selections and click Finish. Before you click on Finish, do not forget to save response file.
- Database creation in progress.
Oops! ORA-12754.No 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 😛
This 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 🙂