By arunraj
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
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.
Technology: