Pre-condition: You must have Oracle database software installed and this note is for 10g.
You will only need to create an instance if you don’t already have one or if you wish to create a new instance. Check what you already have using ps -ef |grep ora
1. Make a copy of the response file (dbca.rsp in the installation binary directory, which should be [installation bin dir]/Disk1/response/dbca.rsp).
2. Make a copy: cp dbca.rsp ..
3. Edit the response file with local environment configuration information. The parameters that you should update are:
TEMPLATENAME = “New Database”
3. run ONE of the the following two command as Oracle user:
dbca -progress_only -responseFile [response file]
dbca -silent -responseFile [response file]
Note: -progress_only option will require graphical display. Set your DISPLAY env parameter if you are working remotely.