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 ?