How to create database manually?

[Pinki Meggi]

Hi,

Im
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?

Regards

Pinki

[Devender Khatana]

Hi,

This can be done by SQL or through GUI mode.

HTH,
Devender

[Steven E. Protter]

Shalom Pinki,

One of these links might help.

http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html

http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html

http://www.dba-oracle.com/t_oracle10g_398_cluster_ready_parameters_.htm

http://www.informit.com/articles/article.asp?p=409470&seqNum=3

Sorry you have to read so much.

SEP

[Arunvijai_4]

Hi Pinki, you can check this link,

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/create.htm

-Arun

[Peter Godron]

Pinki,
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]

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 ).
REM *
#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.
REM *
create database "P01"
maxinstances 5
maxlogfiles 16
maxdatafiles 150
archivelog
maxloghistory 100
character set "WE8ISO8859P1"
controlfile reuse
logfile
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
datafile
'/picnew/oracle/data1/P01/systemP01_1.dbf ' size 150M;
disconnect
spool off
[orapic@orasrv1:]/picnew/oracle/admin/P01/create<>>>

[Indira Aramandla]

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

[Yogeeraj_1 · Accepted solution]

hi Pinki,

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

kind regards
yogeeraj

[Pinki Meggi]

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

Pinki