Re: Multiple Oracle Instances on NT

Lisa,

>I have worked exclusively with Oracle on Unix, but not at all with
>Oracle on NT. Our users have come to us with a requirement to run
>an application with their database on NT. They want to build both a
>test and production environment on the same NT box.
>
>I would like to know some "basics" about running Oracle on NT
> - can you run multiple instances of Oracle on one NT machine
> - if so, what do I need to look out for (ie. what things are
>different that a Unix installation)
> - are any of the processes, etc. drastically different - ie.
>security, networking, logging
> - what type of system requirements (ie. memory, CPU) are needed on NT
>
>Thanks for any help you can give me!

I run many instances on an NT box for development (not production) use. Whenever I get a new job for a new client, I build a new instance for developing the application. It works fine on a low-end system for development purposes.

In a recent post (19:18 -0400 6/20/01) I described what I do to create an instance on NT:

>When I create a new instance under NT, I do this:
>
> set ORACLE_SID=newsid
> c:\ORANT\bin\oradim80 -new -sid newsid -intpwd newsid
>-startmode auto -pfile f:\ORANTdb\newsid\init.ora
> c:\ORANT\bin\oradim80 -startup -sid newsid -starttype
>srvc,inst -usrpwd newsid -pfile f:\ORANTdb\newsid\init.ora
> c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run1.sql
> c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run2.sql
>
>where run1.sql is:
>
> spool c:\ORANT\database\spoolmain
> set echo on
> connect INTERNAL/newsid
> startup nomount pfile=f:\ORANTdb\newsid\init.ora
> CREATE DATABASE newsid
> LOGFILE 'f:\ORANTdb\newsid\log1.ora' SIZE 1024K,
>'f:\ORANTdb\newsid\log2.ora' SIZE 1024K
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXLOGHISTORY 1
> DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' SIZE 50M
> MAXDATAFILES 254
> MAXINSTANCES 1
> CHARACTER SET WE8ISO8859P1
> NATIONAL CHARACTER SET WE8ISO8859P1;
> spool off
>
>
>and run2.sql is:
>
> spool c:\ORANT\database\spoolmain
> set echo on
> connect INTERNAL/newsid
> ALTER DATABASE DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' AUTOEXTEND ON;
> CREATE ROLLBACK SEGMENT SYSROL TABLESPACE "SYSTEM" STORAGE
>(INITIAL 100K NEXT 100K);
> ALTER ROLLBACK SEGMENT "SYSROL" ONLINE;
> @c:\ORANT\Rdbms80\admin\catalog.sql;
> @c:\ORANT\Rdbms80\admin\catproc.sql
> @c:\ORANT\Rdbms80\admin\caths.sql
> spool off

Tim

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gardner
  INET: tgardner_at_codeHorse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).