Current Environment: Operating System: Oracle Linux 6.3Oracle RDBMS Version: 11.2.0.4 Step 1: Please perform below prerequisites before proceeding further.
Step 2: Prepare response file [oracle@dc u02]$ cat create_db.rsp RESPONSEFILE_VERSION = "11.2.0" OPERATION_TYPE = "createDatabase" [CREATEDATABASE] GDBNAME = "DC" SID = "DC" TEMPLATENAME = "General_Purpose.dbc" SYSPASSWORD = "oracle" SYSTEMPASSWORD = "oracle" STORAGETYPE=FS DATAFILEDESTINATION="/oradisk" CHARACTERSET = "WE8MSWIN1252" NATIONALCHARACTERSET= "AL16UTF16" MEMORYPERCENTAGE = "40" DATABASETYPE = "MULTIPURPOSE" where, RESPONSEFILE_VERSION = "11.2.0" => RDBMS version OPERATION_TYPE = "createDatabase" =>[CREATEDATABASE] => This is create database command. GDBNAME = "DC" => This is global DB name. SID = "DC" => This is SID name. TEMPLATENAME = "General_Purpose.dbc" => This is just a template name. SYSPASSWORD = "oracle" => You must need this password to create DB. SYSTEMPASSWORD = "oracle" => You must need this password to create DB. STORAGETYPE=FS => This is storage type whether FS or ASM if available. DATAFILEDESTINATION=/oradisk" => This is the location of datafiles, controlfiles, and redolog files but if you want to separate this location for datafiles, controlfiles, and redolog files then you can do this too.For this, you require more parameter. CHARACTERSET = "WE8MSWIN1252" => This is again an important. Use valid character set. NATIONALCHARACTERSET= "AL16UTF16" => This is an important. Use valid national character set. MEMORYPERCENTAGE = "40" => This is the % of your server memory(RAM). DATABASETYPE = "MULTIPURPOSE" => Type of the database Step 2: Set environment variables and run the below command to create database in silent mode. 15:26:27 SQL> !dbca -silent -createDatabase -responseFile create_db.rsp Copying database files 1% complete 3% complete 37% complete Creating and starting Oracle instance 40% complete 45% complete 50% complete 55% complete 56% complete 60% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 85% complete 96% complete 100% complete Look at the log file "/home/oracle/u01/cfgtoollogs/dbca/DC/DC.log" for further details. 15:28:34 SQL> 15:28:34 SQL> 15:28:41 SQL> 15:28:42 SQL> 15:28:42 SQL> ! [oracle@dc u02]$ ps -ef | grep pmon oracle 3889 1 0 15:28 ? 00:00:00 ora_pmon_DC oracle 3972 3953 0 15:28 pts/0 00:00:00 grep pmon Step 3: Check the log file and see if you get any error. Also verify below things.
|
📚 Refer More Popular Posts:
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !

