Re: Multiple Oracle Instances on NT
Title: Multiple Oracle Instances on NT yOU CAN RUN SEVERAL ÝNSTANCES ON nT . I DO IT NOW. NOTHING IS DIFFERENT. BUT DO NOT FORGET TO MAKE ONE INSTANCE DEFAULT . - Original Message - From: Yttri, Lisa To: Multiple recipients of list ORACLE-L Sent: Monday, June 25, 2001 11:15 PM 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
RE: Multiple Oracle Instances on NT
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= 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 application/ms-tnef
RE: Multiple Oracle Instances on NT
We are running an Oracle 8i (8.1.6.) server on NT 30-250 concurrent users day and night since two years. It is a dedicated Compaq Proliant server, never had any problems. Since two years the databse is running without a single reboot. Tamas Szecsy -Original Message- Sent: Tuesday, June 26, 2001 7:30 AM To: Multiple recipients of list ORACLE-L 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= 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) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas 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).
RE: Multiple Oracle Instances on NT
Title: Multiple Oracle Instances on NT Hi, If I am not wrong Oracle instance on NT is a single process composed of all oracle's threads. UNIX ps -ef MTS is not supported by NT Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. KaradenizSent: Tuesday, 26 June 2001 3:22 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Multiple Oracle Instances on NT yOU CAN RUN SEVERAL ÝNSTANCES ON nT . I DO IT NOW. NOTHING IS DIFFERENT. BUT DO NOT FORGET TO MAKE ONE INSTANCE DEFAULT . - Original Message - From: Yttri, Lisa To: Multiple recipients of list ORACLE-L Sent: Monday, June 25, 2001 11:15 PM 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
RE: Multiple Oracle Instances on NT
Sinardy, MTS has been available on NT since Oracle 8.0.3. -- Anita --- Sinardy Xing [EMAIL PROTECTED] wrote: Multiple Oracle Instances on NTHi, If I am not wrong Oracle instance on NT is a single process composed of all oracle's threads. UNIX ps -ef MTS is not supported by NT Sinardy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. Karadeniz Sent: Tuesday, 26 June 2001 3:22 PM To: Multiple recipients of list ORACLE-L Subject: Re: Multiple Oracle Instances on NT yOU CAN RUN SEVERAL ÝNSTANCES ON nT . I DO IT NOW. NOTHING IS DIFFERENT. BUT DO NOT FORGET TO MAKE ONE INSTANCE DEFAULT . - Original Message - From: Yttri, Lisa To: Multiple recipients of list ORACLE-L Sent: Monday, June 25, 2001 11:15 PM 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 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
RE: Multiple Oracle Instances on 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. Just thought I would mention, that is only for 8.0, 8i has one service:) Kev -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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).
RE: Multiple Oracle Instances on NT
Title: Multiple Oracle Instances on NT I would say it depends on the size and amount of connections. Currently we have two instances running on one NT server, but they are not very large, only a couple of gigs. The machine is a dual 550 PIII with a gig of ram. It seems to run fine, except for the memory leak we may have encountered last week. Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Yttri, LisaSent: Monday, June 25, 2001 4:16 PMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Multiple Oracle Instances on NT
Title: Multiple Oracle Instances on NT Lisa, I am not an Oracle expert, but I can tell you from my brief experience that you should try to convince your users and management to NOT put test and production on one NT box. If you have something go wrong on the test it may require a bounce of the server to fix it. I know cuz this is the situation I am in. I had to bounce the box on Friday. We had to get everyone out of production to do this. Dave -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 3:16 PMTo: Multiple recipients of list ORACLE-LSubject: 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
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: [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).
RE: Multiple Oracle Instances on NT
Why run oracle on NT? Run it on Unix and let the apps/appserver reside on NT. I would seriously debate this requirement... Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: Yttri, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 3:16 PM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Multiple Oracle Instances on NT
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= 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) application/ms-tnef