Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

How to create database manually?

Go to solution
Pinki Meggi
Frequent Advisor

How to create database manually?


I have installed oracle database 10g software succesfully on HP-UX11i, now i want to create a database, how can i create a database without running dbca? i have find out a script to create a database with sql, but i have to create the instance before, and i dont know how to create it on HP-UX, can anyone help me plase?


Devender Khatana
Honored Contributor

Re: How to create database manually?


This can be done by SQL or through GUI mode.

Impossible itself mentions "I m possible"
Steven E. Protter
Exalted Contributor

Re: How to create database manually?

Shalom Pinki,

One of these links might help.

Sorry you have to read so much.

Steven E Protter
Owner of ISN Corporation
Honored Contributor

Re: How to create database manually?

Hi Pinki, you can check this link,

"A ship in the harbor is safe, but that is not what ships are built for"
Peter Godron
Honored Contributor

Re: How to create database manually?

I think you can use dbca and then spool the script to a file.
That file can then be run the generate the db or amended and used as a template.
Frank de Vries
Respected Contributor

Re: How to create database manually?

startup sqlplus
and run the db create script,
looks something like this

set echo on
spool /picnew/oracle/admin/P01/create/crdbP01.lst

REM * Start the instance (ORACLE_SID here must be set to ).
#connect internal # will do this self AFV
startup nomount

REM * Create the database.
REM * SYSTEM tablespace configuration guidelines:
REM * General-Purpose ORACLE RDBMS 5Mb
REM * Additional dictionary for applications 10-50Mb
REM * Redo Log File configuration guidelines:
REM * Use 3+ redo log files to relieve ``cannot allocate new log...'' waits.
REM * Use ~100Kb per redo log file per connection to reduce checkpoints.
create database "P01"
maxinstances 5
maxlogfiles 16
maxdatafiles 150
maxloghistory 100
character set "WE8ISO8859P1"
controlfile reuse
GROUP 1 '/picnew/oracle/redo/P01/redo1aP01.log' SIZE 30481K,
GROUP 2 '/picnew/oracle/redo/P01/redo2aP01.log' SIZE 30481K,
GROUP 3 '/picnew/oracle/redo/P01/redo3aP01.log' SIZE 30481K,
GROUP 4 '/picnew/oracle/redo/P01/redo4aP01.log' SIZE 30481K
'/picnew/oracle/data1/P01/systemP01_1.dbf ' size 150M;
spool off
Look before you leap
Indira Aramandla
Honored Contributor

Re: How to create database manually?

Hi Pinki,

You can use DBCA to generate the database creation script and save the scripts, without creating the database

Then you may use the saved database creation scripts edit them and then use them to create the database manually. You can create the template initially through dbca, and copy/edit the templates to suit your new databases.

Indira A
Never give up, Keep Trying
Honored Contributor

Re: How to create database manually?

hi Pinki,

Attached a killer document from metalink, old yet very useful article that will definitely help

kind regards
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Pinki Meggi
Frequent Advisor

Re: How to create database manually?

Hi all,

thanks alot for your help, i think i just have enough information to create the database.
The document from metalink is really very useful, thanks yogeeraj. The link given by Arun is also very useful, thaks alot once again.

Best Regards