[aliviu]

I have downloaded and installed Oracle 9i Database Server on Windows 2000 Professional. When trying to create a new database using "Database Configuration Assistant", I failed because the new empty database needed 1144 MB (more than 1 GB !) on HDD. I tried with different templates but the result is the same.
So, I tried to use a CREATE DATABASE statement for setting the dimensions of the files to smaller values. I checked the documentation (Oracle 9i Database Administrator's Guide, cap. 1 Postinstallation Database Creation, Creating a Database Manually) and follow the steps described there:
- I have created the file "init.ora"
- I have created a service using oradim (and the service started)
- I have set ORACLE_SID
- I have launched sqlplus with "/nolog"
Then, I can't connect to ... (to what ?):
- with "connect / as sysdba" I get "ERROR ORA-01031: insufficient privileges"
- with "connect sys/change_on_install as sysdba" I get "ERROR ORA-01017: invalid username/password; logon denied".
Later (in another sqlplus session), I get "ERROR ORA-24314: service handle not initialized".
Is there a way to create a database without having to buy a new HDD ?

[Entermaner]

1.Using the Password File Authentication
And set the Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE in the init.ora file

2.Run the regedt
Choose the \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
And set the ORACLE_ID to your database name

Then....ºÇºÇ,you know.............................................. ................
....................................

Ŷ
The order: set ORACLE_ID=... is not usefull,don`t use it
That`s OK£¿

[kerlion]

1 you need to create a windows service with oradim
2 set ORACLE_SID in windows registry or Env Variable
3. create password file with orapwd
4. setup initSID.ora file
5. create your database

in fact,you can create database use dbca with "new dataabse" template to create a customer database, I ever used it to create mini database
whit 60M SGA and 600M datafiles