create database manually on windows

[oracle query]

please tell me how to create oracle database manually on windows(step by step)

[Duncan Edmonstone]

Here are the steps:

1. Realise that this forum is here to help people with problems/issues that they've made at least some effort to figure out on their own *NOT* to stop the terminally idle from having to do any thinking whatsoever

2. Actually post some useful information such as the version of Oracle...

3. Post in a relevant forum (a Windows forum rather than a UNIX forum might be appropriate)

4. RTFM:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/install003.htm#sthref49

Duncan

[oracle query]

version 9i
i have tried many times but failed at last

pls help me out

[Duncan Edmonstone]

So the manual for DB creation on Windows is here:

http://download.oracle.com/docs/cd/B10501_01/win.920/a95491/create.htm#1005616

You say you've tried many times already... so what happened, what error messages did you get? Do you even have Oracle installed??

Think about what you're asking... If I just went to my local auto shop and said "My car has broken down - I left it at home - tell me how to fix it", what do you think his response would be?

HTH

Duncan

[oracle query]

set oracle_sid = abc
oradim -new -sid abc -intpwd oracle-password
sqlplus "/ as sysdba"


create spfile from pfile = 'c:\oracle\admin\abc\pfile\init.ora'

then rebooting...........

set oracle_sid = abc
sqlplus "/ as sysdba"

sql>startup pfile = c:\oracle\admin\abc\pfile\init.ora;


but not starting, instead giving an error
already mounted first shut it down

[Duncan Edmonstone]

Ok...now we're getting somewhere.

Why are you using oradim? It's generally easier to create the database using dbca as detailed here:

http://download.oracle.com/docs/cd/B10501_01/win.920/a95491/create.htm#1005763

Get rid of what you've created so far using:

oradim -DELETE -SID abc

and then follow the instructions for using dbca at the link above.

HTH

Duncan