Re: Creating new database on NT server

In article <3rhnah$9jk_at_news.vanderbilt.edu>, Randy Fought <FOUGHTRL_at_CTRVAX.VANDERBILT.EDU> says:
>
> I have installed 7.1.3 on an NT machine with the initial
>database. Everything is ok. Now I want to create a new database.
>I am following the User's Guide for Windows NT. I have created a
>new instance with the Instance Manager and modified the network settings
>with the Network Manager to include the new instance. Now I ready to
>create the new database. The first thing I need to do is start the
>instance (step 9, page 3-12). When I do this I get error:
>instance 'DATA' not started. I can still start and use the initial

Because there is no physical datafile. You just created an instance.

>instance 'ORCL' so I am sure I have not trashed the network settings.
> Anyone have a hint or similar experience. I can find no
>additional help or error message associated with the Instance
>Manager not starting. Thanks Randy

I am using Japanese version of ORACLE7 ver 7.1 and running two instances on one machine. They are running OK.

When you need to create second instance and its datafile, do following. 1. SERVICE
   Create Service and start only Service from Instance Manager or    Control Panel's Service.

2. INITSID.ORA
   Open Notepad and edit initSID.ora. SID should be "DATA" in your case.    (initDATA.ora) Put this file to %RDBMS71% directry.

3. ENVIRONMENT VARIABLE
   Edit environment variable or registry key. There are several options.

   If you want to edit environment variable, open Control Panel's System.    Add variable "ORACLE_SID" and set it "DATA".

   If you want to edit registry key, change value of ORACLE_SID to    "DATA".    Or use set command from Command Prompt.    set ORACLE_SID=DATA, and start SQL*DBA.       

4. CREATE DATABASE
   Then open SQL*DBA (Japanese version is sqldba71.exe).    Connect as Internal.
   Start database without mounting database.    (startup nomount)
   Run sql that creates new database. It takes long.    See your manual. This is most important thing.

5. THEN...
   After creating database file, you can start database from Instance    Manager anytime.
   NOTE: If you put initSID.ora under other than %RDBMS71% directry,

         you won't start instance from Instance Manager.

Hope this helps you.

BTW, Japanese version does not contain Network Manager, could you explainme what Network Manager is? please E-mail to me if you have time. Received on Tue Jun 13 1995 - 00:00:00 CEST