Re: creating multiple instances on NT

Follow the steps below
1. make a copy of yoyur existng initsid file and make requisite changes (db_name, control_files etc to reflect new SID)
2. use oradim73 to create a new service/instance as below   C:\oradim73 -NEW -SID newsid -PFILE path to new initsid -USRPWD internal password -STARTTYPE SRVC, INST -STARTMODE AUTO 3. set oracle_sid (e.g. C:\ set oracle_sid=newsid) 4. make sure the new service is started by looking at the services from control panel. The service will be something like "oracleserviceSID"

5. fire up server manager
6. connect internal/new password you specified for -USRPWD
7. startup nomount pfile=path to new initSID
8. if you get ora-09352 the service is not started - start the service and proceed
9. run the create database script

HTH
Venkat

>I'm a Unix person and am now supporting 2 installations of Oracle 7.3 on NT
>4.0. I need to create
>multiple instances on each of these boxes. I'm use to setting up a new user,
>setting up my environment,
>specifying a new oracle_sid, same oracle home, planning the dbase, creating
>a new init file w/ correct information
>starting up the dbase in no mount mode specifying pfile=that initnew.ora
>file I just created, and issuing the create database command.
>And life is good.
>
>How do I do this on NT? I do the planning, create the new init file.do I
>have a edit the registry? I imagine that I need to create a new service for
>this new instance. How do I get into sqlplus and not point to the one
>default dbase that I have?
Received on Tue Jun 09 1998 - 16:03:19 CDT