Manual Creation of database in windows with oracle 9i

Manual Creation of database in windows with oracle 9i | Manual Creation of database in windows with oracle 9i Step-by-Step By . Suranga De Silva @ ceylonlinux dot com Name of the database db18 Note all commands are in bold letters 1. Open the command prompt and execute the command sqlplus nolog 2. Connect to the default database as sysdba in sql prompt SQL conn sys oracle as sysdba you can see the name of that database by executing select name from v database 3. Now open another command prompt and set oracle SID as set oracle_sid db18 4. Start a windows service with internal password oradim -new - sid database name intpwd password is the syntax. In this case I use ceylonlinux_suranga as password to create db18 service like oradim -new -sid db18 -intpwd ceylonlinux_suranga 5. Create a directory called db18. In my case I created it in d drive Note all my parameter files and .sql file that are going to discuss following are based on my location you can change the location according to yours 6. Here is my that I saved it in d db18 folder. This is the static parameter file that I used in my database creation Note If you are creating a database with a different name and in a different location make sure to edit the relevant fields in this file Copyright c 1991 2001 2002 by Oracle Corporation Cache and I O db_block_size 8192 db_cache_size 25165824 db_file_multiblock_read_count 16 Cursors and Library Cache open_cursors 300 Database Identification db_domain db_name db18 Diagnostics and Statistics 1 background_dump_dest d db18 core_dump_dest d db18 timed_statistics TRUE user_dump_dest d db18 File Configuration controlfiles d -db18 . d db18 d db18 Instance Identification instance_name db18 Job Queues job_qjeue_processes 10 MTS dispatchers PROTOCOL TCP SERVICE orcl1XDB Miscellaneous aq_tm_processes 1 compatible Optimizer hash_join_enabled TRUE query_rewrite_enabled FALSE star_transformation_enabled FALSE Pools java_pool_size 33554432 large_pool_size 8388608 .