Want to create a new database from scratch without installer

[ifxtechie]

Hi,
I want to create a new database from scratch without using the installer. I figured out some steps to do that. Pls let
me know if this method is correct.
On my windows, I have C:\oracle\admin\OEMREP directory
for oemrep database. For a new database PARTHA, Can I
do like as below:

1. Create a directory - C:\oracle\admin\PARTHA
2. Then create directories
C:\oracle\admin\PARTHA\bdump
C:\oracle\admin\PARTHA\cdump
C:\oracle\admin\PARTHA\create
C:\oracle\admin\PARTHA\pfile
C:\oracle\admin\PARTHA\bdump
3. Copy the init.ora file from
C:\oracle\ora92\admin\sample\pfile\initsmpl.ora to
create a init.ora file at pfile directory i.e.
C:\oracle\admin\PARTHA\pfile.
Then edit this .ora for the control files as

control_files=("C:\oracle\oradata\PARTHA\CONTROL01.CTL",
"C:\oracle\oradata\PARTHA\CONTROL02.CTL",
"C:\oracle\oradata\PARTHA\CONTROL03.CTL&quot

Also edit this file for entries to reflect onto PARTHA
database instead of OEMREP.
4. Create [touch] the files
C:\oracle\oradata\PARTHA\CONTROL01.CTL
C:\oracle\oradata\PARTHA\CONTROL02.CTL
C:\oracle\oradata\PARTHA\CONTROL03.CTL

as these are pointing as control files.
5. Do I need to create the files
C:\oracle\oradata\PARTHADB
for the data.

Now If I restart the machine, do I get my NEW database
PARTHA.
If I get it, what will be my initial password?Do I
need to do anything else.
Or am I missing any steps here. Can anybody pls direct me
in creating the instance.
I haven't implemented this as I have two databases running whcih have been created using the installer. My feeling is if I follow the above steps, it may spoil the existing databases. Is this correct.
Pls suggest me how to proceed.
Thanks very much
Partha

 

[carp]

I think your best courses of action are to
- try creating a database on a different server if you are worried about messing up your existing databases. You DON'T want to be experimenting with this stuff on the same platform as your existing databases if you don't have a good idea of what you are doing.
or
- just use the installer. It was created to make database creation easier and less risky.

Also, please read the documentation on how to create a database - creating an init.ora file and bouncing the machine will NOT create a new database for you!

A good place to start examining what is involved (besides the documentation) is the script that the database assistant creates.

If you want, you can bring up the assistant, go through the steps required to set up the database the way you want it, but instead of having the assistant create the database, have it create the script that creates the database. This will give you a customized tutorial on how to create your database!

Elbert, CO
1451 MST

 

[bookouri]

Go to orafaq and look at the howtos on cloneing a database, that might help you. Also, if you create the database without oracle's help you will have to manually run several files included in the oracle rdbms admin scripts, catalog.sql, catproc.sql would be good terms to look up if you want to do everything manually.