Re: Multiple Oracle databases on Windows NT

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Wed, 19 May 1999 16:44:42 -0600
Message-ID: <37433e8c.0@news.cadvision.com>

Make sure you first create the initXXX.ora files. Use Oradim73 -new and Oradim73 -startup to create the service and = instances. Look in the Gettting started Release 7.3.4 manual, page 3-14

--
Terry Dykstra
Canadian Forest Oil Ltd.

    Vitaliy Mogilevskiy wrote in message = <37431819.70B76143_at_earthlink.net>...

    Hello,
    Here are the steps to accomplish this:

1. ORADIM73 -NEW -SID PROD -INTPWD MANAGER -STARTMODE AUTO -PFILE = D:\ORANT\DATABASE\INITPROD.ORA
2. SET ORACLE_SID=PROD SET LOCAL=2:PROD SVRMGR23 @CRDB.SQL

    DESC:

1. Creates OracleServicePROD which starts the instance
2. Creates the Database under the new instance

    It's been a while since I've done it on NT, but I have saved Batch = files

    so I am sure that the above two steps will work on 7.3.4, because = that's what I've used.

    I know there is a way of creating the second Service which will = start the database

    automatically, but I never used it (had no need to)

    Please note that to start newly created database you will have to     set your ORACLE_SID and LOCAL to the corresponding instance. So if = you have

    multiple databases you'll have to re set those ENV's before starting = the databases.

    You can also type ORADIM73 and use Oracle's GUI version to create a = new instance

    +-------------------------------------------------------------+ 


    | Vitaliy Mogilevskiy                                         | 


    | Senior Consultant                                           | 


    | CORE Technology Group, Inc.                                 | 


    | E-mail:    vit100gain_at_earthlink.net                         | 


    | Fax :      (707) 516-2163                                   | 


    | Web Page:  http://home.earthlink.net/~vit100gain/index.html | 


    |            *** Free DBA Script Library at my Web Page ***   | 


    +-------------------------------------------------------------+ 
      
      
      
      

    Patrick Dewael wrote:

        Hi, 
        I'm working with a Windows NT 4.0 platform and with Oracle =
7.3.4. database 
        server. I would like to install 3 seperate databases (with of =
course 
        different INITxxxx.ora files, redo log files, control files, =
etc.) on this 
        machine which will have to run simultaneously. 

        For the first database I make use of the default installed =
Service on NT, 
        OracleServiceORCL (and OracleStartORCL to start automatically =
when NT 
        reboots). For the 2 other databases I need, correct me if I'm =
wrong, 2 
        additional Services. How can I define these 2 Services and how =
can they be 
        linked to the 2 databases ? Is this done through the =

INITxxxx.ORA files ??

        Please help me,

        Greetings

        Patrick

        have to but Received on Wed May 19 1999 - 17:44:42 CDT