Interview Questions

Oracle Create a New DB Instance

Creating a New DB Instance

Steps for Creating New DB instance:

1) Log-in to the DB server as oracle user.

2) Move to the location $ORACLE_HOME/bin

3) Execute the following command (oradb1 is the new db name)

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname oradb1 -sid oradb1 -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration NONE

After running the above command , the following output will be generated

Copying database files
1% complete
3% complete
11% complete
18% complete
26% 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 "$ORACLE_HOME/cfgtoollogs/dbca/oradb1/oradb1.log" for further details.

If there are errors, like (ORA-01031: insufficient privileges), then change the owner of all the files under oracle home to oracle:dba.

chown -R oracel:dba $ORACLE_HOME)

4) Check the above log file for any errors.

5) Check whether tnsping "oradb1" is working fine.

6) Log-in to Toad using system/manager@oradb1 and create the required schema.