Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to create database manually?

SOLVED
Go to solution
Pinki Meggi
Frequent Advisor

How to create database manually?

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
8 REPLIES
Devender Khatana
Honored Contributor

Re: How to create database manually?

Hi,

This can be done by SQL or through GUI mode.

HTH,
Devender
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.

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Arunvijai_4
Honored Contributor

Re: How to create database manually?

Hi Pinki, you can check this link,

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

-Arun
"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?

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
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 ).
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<>>>
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
Yogeeraj_1
Honored Contributor
Solution

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
yogeeraj
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

Pinki