RE: Multiple Oracle Instances on NT

I support a client with 10 instances on 1 NT server. Did I choose that, no. And it is a bear to admin. However, after a lot of work, it is VERY stable.

Cheers,

Earl

---

TheOracleDBA
theoracledba_at_lycos.com



On Mon, 25 Jun 2001 23:51:07  
 TAG DBA wrote:


>Hello Lisa...

>I have been handling Oracle on NT last 6 months - and I much prefer UNIX. Here are 

>some things I learnt the hard way...

>

>>>  -  can you run multiple instances of Oracle on one NT machine

>

>yes u can. Another lister has replied to u about this - how one uses "oradim80" to 

>create "instances"/SID's

>Note that the default SID can be set in the registry - so that u dont have to do "set 

>ORACLE_SID=XXXX" everytime

>Note that there is no "oraenv" in NT

>For every SID there will be 2 services in NT - one called OracleServiceURSID and 

>another OracleStartURSID. If u keep the latter as "start automatically" - ur db will 

>come up auto when NT boots up. The former is always required. U can alter the 

>settings by recreating the instance using oradim

>

>>>  -  if so, what do I need to look out for (ie. what things are differentthat a 

>Unix installation)

>>>  -  are any of the processes, etc. drastically different - ie. 

>security,networking, logging

>

>Dont foreget to create the oradba group.  Also Oracle runs as a single process - 

>there are no different shadow processes. So everything is clumped in one. The 

>TaskManager might show u how many threads are running in one process (it does not 

>break up for each app on the machine - so if only the Oracle server is running - the 

>figure u see should correspond to the number of Oracle related processes)

>Further note that Oracle runs as user "system" - thats an internal hidden system mode 

>in NT. So there might be occassions when u change permissions on some orcale related 

>directory and then find that oracle cant access the files - thats cause u removed 

>"systems" access. Just give required permission to "system" on those files/directory

>

>>>  -  what type of system requirements (ie. memory, CPU) are needed on NT

>

>Well that depends on ur requirements. Try to configure ur NT box so that its 

>"dedicated" to the job of being a database server. U can find some notes on metalink 

>on this. Ensure that ur NT box does not double as a PDC (primary domain controller).

>

>Finally reboot machine as often as u can - I have found memory being allocated and 

>not being released. Keep LOTS of memory - I have seen the NT box freezing and 

>refusing connections when it no longer had memory to create a shadown process. (only 

>soln - crash boot the machine)

>Further dont use "copy" command to do ur hotbackups - use the "ocopy" command instead.

>Thats all I can think of now..

>regards,

>~aslam

>(PS: I had enough of NT - migrating to Solaris in a months time)

>

>

>-----Original Message-----

>From:  Yttri, Lisa [SMTP:lisa.yttri_at_cnh.com]

>Sent:  Tuesday, June 26, 2001 1:46 AM

>To:    Multiple recipients of list ORACLE-L

>Subject:       Multiple Oracle Instances on NT

>

>Hi everyone -

>

>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!

>Lisa

> << File: ATT00326.html >> 



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: The Oracle DBA
  INET: theoracledba_at_lycos.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).