topic Re: How to create database manually? in Operating System - HP-UX

How to create database manually?

Pinki Meggi — Wed, 11 Jan 2006 05:36:32 GMT

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

Re: How to create database manually?

Devender Khatana — Wed, 11 Jan 2006 05:40:28 GMT

Hi,

This can be done by SQL or through GUI mode.

HTH,
Devender

Re: How to create database manually?

Steven E. Protter — Wed, 11 Jan 2006 05:42:05 GMT

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

Re: How to create database manually?

Arunvijai_4 — Wed, 11 Jan 2006 05:59:48 GMT

Hi Pinki, you can check this link,

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

-Arun

Re: How to create database manually?

Peter Godron — Wed, 11 Jan 2006 07:55:13 GMT

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.

Re: How to create database manually?

Frank de Vries — Wed, 11 Jan 2006 08:13:03 GMT

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

Re: How to create database manually?

Indira Aramandla — Wed, 11 Jan 2006 22:51:23 GMT

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

Re: How to create database manually?

Yogeeraj_1 — Wed, 11 Jan 2006 23:19:01 GMT

hi Pinki,

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

kind regards
yogeeraj

Re: How to create database manually?

Pinki Meggi — Thu, 12 Jan 2006 03:12:16 GMT

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