Re: Creating database instance in Personal Oracle 7

1.) You should set 3 things in registry: HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE ->    DATBASE_STARTUP = empty
   ORACLE_SID = name of your new db e.g. ORCL    NLS_LANG = language_country.codepage e.g. SLOVAK_SLOVAKIA.EE8MSWIN1250

2.) Create file initSID.ora in $ORACLE_HOME\database (c:\orawin95\database). Sample is inst.ora. You must set at least 'control_files' & 'db_name'. (db_name == SID)

3.) Start sqldba || svrmgrl. Witch you have it depends on the version of Oracle.
4.) Type:

   startup nomount
5.) Type:

   create database ....
6.) After create database you must open database and run the two scripts. First catalog.sql then catproc.sql. While you conected like internal from sqldba.

J.H.

Marty Nord wrote in message <34eeb906.2597040_at_news.inct.net>...
>Can anyone tell me all the steps necessary to create a seperate
>database instance in Persoanl Oracle 7. I have tried several things.
>I can't get the CREATE DATABASE command to work. The Oracle Unleashed
>book that I have says that I need to use SQLDBA to do this. When I
>load SQLDBA the Oracle database starts up on my PC. Then, I am
>supposed to CONNECT INTERNAL. I have to STOP DATABASE and then
>CONNECT INTERNAL and then I try to CREATE DATABASE but I am doing
>something wrong.
>
>If you know where I can get a nice walk through on how to create a
>database/seperate instance in Personal Oracle 7 I would greatly
>appreciate it. If possible, can you email me your reply to
>nordtm_at_inct.net.
>
>Thank you!
>
Received on Mon Feb 23 1998 - 00:00:00 CST