Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from the command line.
First, the adump directory needs to be created. You can create a directory on all nodes as follows.
1 2 | [oracle@oradb01 ~]$ mkdir -p /u01/app/oracle/admin/ORCL/adump [oracle@oradb01 ~]$ mkdir -p /u01/app/oracle/admin/ORCL/adump |
With DBCA, you can create your rac database with the following command.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | [oracle@oradb01 ~]$ dbca -silent \ -nodelist oradb01,oradb02 \ -createDatabase \ -templateName General_Purpose.dbc \ -gdbName ORCL \ -sid ORCL \ -SysPassword welcome1 \ -SystemPassword welcome1 \ -emConfiguration none \ -redoLogFileSize 1024 \ -recoveryAreaDestination RECO_DG \ -storageType ASM \ -asmsnmpPassword welcome1 \ -diskGroupName DATA_DG \ -recoveryGroupName RECO_DG \ -listeners LISTENER \ -registerWithDirService false \ -characterSet WE8ISO8859P9 \ -nationalCharacterSet AL16UTF16 \ -databaseType MULTIPURPOSE \ -automaticMemoryManagement true \ -totalMemory 20480 \ -sampleSchema false \ -initparams audit_file_dest='/u01/app/oracle/admin/ORCL/adump' \ -initparams compatible='11.2.0.4' \ -initparams db_create_file_dest='+DATA_DG' \ -initparams db_create_online_log_dest_1='+DATA_DG' \ -initparams db_create_online_log_dest_2='+RECO_DG' \ -initparams db_recovery_file_dest='+RECO_DG' \ -initparams diagnostic_dest='/u01/app/oracle' \ -initparams parallel_max_servers=8 \ -initparams processes=1000 |
You can also delete an existing database with the following command.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | [oracle@oradb01 ~]$ dbca -silent -deleteDatabase -sourceDB ORCL Connecting to database 9% complete 14% complete 19% complete 23% complete 28% complete 33% complete 38% complete 47% complete Updating network configuration files 48% complete 52% complete Deleting instances and datafiles 66% complete 80% complete 95% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL.log" for further details. |
Run the following command for a list of all processes and descriptions of their use.
1 | [oracle@oradb01 ~]$ dbca -help |
