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
[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
>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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
