create a new database with scripts

[raf]

hi,
I'd like to know how can I create a new instance oracle with scripts, not with Database Configuration Assistant or Universal installer.

I've O.S. win2000, 256mb ram and oracle 8.1.7.0, how can I create tablespace, datafile, redo log files, rollback segments..........?

Thanks
Raf

[agasimani]

1. Define init.ora file.
2. Set proper Environment variables like Oracle ORACLE_SID, ORACLE_HOME, PATH, ORA_NLS
3. create a instance using ORADIM command
4. Make sure that the Oracle service is started from Control Panel's Services
5. start Server Manager and connect as internal
6. execute following command from server manager:
svrmgrl> startup nomount pfile=
7. Run CREATE DATABASE script
8. After succeful completion of step 7, execute catalog.sql and catproc.sql
9. Run additional scripts to create your database objects like rollback segments, tablespaces etc.

Note: Dont forget to take your rollback segments online once you create them

[davey23uk]

If you use the dbca first time round, get to the end and instead of creating the database, save the scritps to a batch file. Then you can open these scripts and see what needs to be done each time.