Current Environment:
Operating System: Oracle Linux 6.3Oracle RDBMS Version: 11.2.0.4
Step 1: Please perform below prerequisites before proceeding further.
- Remove New Database entry from /etc/oratab if exists.(Suppose we are going to create database DC, so this database entry should not be in the oratab file.
- Minimum HDD Space at OS level : 2 GB
- Minimum RAM : 2 GB
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,
[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.
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.
- Database Name
- Character Set
- National Character Set
- sys and system user password
Thanks for reading this post ! Please comment if you like this post !
Informative post, continue sharing more like this. Oracle DBA Training
ReplyDelete