Re: RDBMS on Netware or NT ?
Date: 1995/09/29
Message-ID: <44gt02$oo3_at_noc.tor.hookup.net>
Ulf Pettersson <Ulf.Pettersson_at_ims.ore.se> wrote:
>
> Any special pros and cons in which OS (Netware 4.x or Windows
> NT) I should use for a new Oracle database ?
>
> All information in the area are very welcomed.
>
> Thank you
>
> /Ulf
>
>
>
Here are a number of postings that
I compiled from this newsgroup regarding Novell and Oracle.
You can find them at www.jcc.com , the JCC Resource Search
Engine.
Hope this Helps
Matt.
Windows NT
OS Integration Support<I>
Symmetric multiprocessing
OS threads
Asynchronous I/O
Direct file system support
Native graphical administration tools
OS registry support
Bundled Network Protocol Support :
Named Pipes
SPX/IPX
TCP/IP
NetWare
Integration Support
Direct file system support
Integrated user authentication
Bundled Network Protocol Support :
SPX/IPX
TCP/IP
IBM APPC/SNA LU 6.2
OS/2
OS Integration Support
Symmetric multiprocessing
OS threads
Direct file system support
Integrated user authentication
Native graphical administration tools
Bundled Network Protocol Support :
SPX/IPX
NetBIOS
TCP/IP</I>
SCO UNIX, Solaris x86, UnixWare
OS Integration Support
Symmetric multiprocessing
Asynchronous I/O
Direct file system support
Native installation
Native online help and documentation integration
Native graphical administration tools
Native "OS" service
Bundled Network Protocol Support
TCP/IP
SPX/IPX
- NOVELL ******************************
Oracle FAQ : Novell Issues
One of the things to remember about Novell is that it is primarily designed as a fileserver, not as an operating system in its own right. Oracle essentially exists as a series of NLMs, which I believe cannot really get more memory dynamically (and release it), and, because of my UNIX background, I think this architecture is ugly. Nevertheless, quite good results can be achieved with Novell Oracle servers provided you put enough memory in the server and configure Oracle to use it. Apart from small numbers of users, if you have performance problems, just keep adding more memory to the server. Amounts of the order of 96Mb or 128Mb are not uncommonly required to magically make larger applications suddenly work well.
Xref: alice comp.client-server:964 comp.databases:1615 comp.databases.oracle:3476 Path: alice!malgudi.oar.net!cedarnet.cedarville.edu!calvin!gumby!yale!zip.eecs.umich.edu!panix!news.mathworks.com!news.alpha.net!uwm.edu!vixen.cso.uiuc.edu!howland.reston.ans.net!news.sprintlink.net!gryphon.phoenix.net!usenet From: Michael Natale <mnatale_at_phoenix.net>Newsgroups: comp.databases,comp.databases.oracle,comp.sys.novell,comp.client-server Subject: Re: Oracle Novell sites?
Date: 17 Feb 1995 15:52:50 GMT
Organization: Phoenix Data Systems (713) 486-8337 Lines: 20
Message-ID: <3i2goj$naa_at_gryphon.phoenix.net> References: <1995Feb6.230243.25355_at_bnr.ca> <3hajjg$5dd_at_taquito.abq.bdm.com>
We are using Oracle on Netware, and here are the experiences we encountered.
First, we had problems because we were running it on a file server, and every time someone hit Oracle, the file server utilization went well over 80%.
Second, we were running Norton Anti-Virus for Networks, and it would crash the server ocassionally when it would try to examine Oracles' SGA. We fixed this by putting Oracle on a dedicated database server, and now evrything is working fine. But I think the performance is slower than if you were to run it on Unix.
Hope this helps,
Mike Natale
Houston, Texas, USA
Xref: alice comp.databases:2232 comp.databases.oracle:4928 comp.databases.sybase:2691 Path: alice!malgudi.oar.net!mstar!cis.ohio-state.edu!magnus.acs.ohio-state.edu!usenet.ins.cwru.edu!cleveland.Freenet.Edu!ge425 From: ge425_at_cleveland.Freenet.Edu (Bradley W. Skiles)Newsgroups: comp.databases,comp.databases.sybase,comp.databases.oracle Subject: Re: RDBMS under Novell ?
Date: 9 Mar 1995 20:49:57 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA) Lines: 9
Message-ID: <3jnpll$hts_at_usenet.INS.CWRU.Edu>
I have experience with Oracle v6 and v7 on Novell. Speed does tend to be an issue. The systems I've seen have been reliable, but not speed demons. Do not, under any circumstances, use the same machine for the file server and the database server. And make sure the database server has plenty (read: LOTS) of RAM and multiple hard drives. (Standard stuff any Oracle DBA will tell you.) --brad
-- (Bradley W. Skiles) _________________________________________________________________________________________________________ Xref: alice comp.databases:2247 comp.databases.oracle:4956 comp.databases.sybase:2699 Path: alice!malgudi.oar.net!chemabs!sun1.is.battelle.org!dst.battelle.org!lionel.inhouse.compuserve.com!uunet!news.mathworks.com!hookup!nic.ott.hookup.net!newsadm From: GrahamB_at_psac.com (Brian Graham) Newsgroups: comp.databases,comp.databases.sybase,comp.databases.oracle Subject: Re: RDBMS under Novell ? Message-ID: <3jn9lc$ec1_at_nic.ott.hookup.net> Date: 9 Mar 95 16:16:44 GMT References: <1995Mar8.142824.1328_at_gamelan.shnet.org> Organization: P.S.A.C. Lines: 31 X-Newsreader: WinVN 0.92.6 In article <1995Mar8.142824.1328_at_gamelan.shnet.org>, thomas_at_gamelan.shnet.org (Thomas Funke) says:Received on Fri Sep 29 1995 - 00:00:00 CET
>
>
>A customer plans to use a RDBMS (Sybase or Oracle) under Novell.
>
>In my opinion, a Unix server is a better solution. What are your
>experiences with a Novell-based server ? How stable are they, how about
>data security etc. ?
>
>Any comments appreciated !
>
>--
>----- Thomas Funke ----------------------- thomas_at_gamelan.shnet.org -----
>
>C++ is to C as Lung Cancer is to Lung
We currently have our payroll and financial systems in production on (albeit an Oracle 6 rdbms) on a Novell 3.11 server (486-66). Users are CONSTANTLY complaining about the speed. We are in the process of converting a 250,000 record rdbms off our mainframe and will be running on a 7.1 rdbms on a Sun Sparc 1000. 128Meg ram, currently 4 GIG disk space. Raid units on order. Our Novell databases will be converted immediately after the mainframe is gone. -- Brian Graham . Programmer / DBA ._______|_______. Tel: 613-560-5470 Public Service Alliance \(*)/ Fax: 613-563-3492 of Canada o/ \o Email: grahamb_at_psac.com __________________________________________________________________________________________________________ Xref: alice comp.databases:2289 comp.databases.oracle:5069 comp.databases.sybase:2739 Path: alice!malgudi.oar.net!caen!newsxfer.itd.umich.edu!gatech!newsjunkie.ans.net!newsgate.advantis.net!news-m01.ny.us.ibm.net!news From: flachan_at_ibm.net Newsgroups: comp.databases,comp.databases.sybase,comp.databases.oracle Subject: Re: RDBMS under Novell ? Date: 11 Mar 1995 20:24:39 GMT Lines: 25 Message-ID: <3jt0u7$608_at_news-s01.ca.us.ibm.net> References: <1995Mar8.142824.1328_at_gamelan.shnet.org> Reply-To: flachan_at_ibm.net X-Newsreader: IBM NewsReader/2 v1.09 In <1995Mar8.142824.1328_at_gamelan.shnet.org>, thomas_at_gamelan.shnet.org (Thomas Funke) writes:
>
>A customer plans to use a RDBMS (Sybase or Oracle) under Novell.
>
>In my opinion, a Unix server is a better solution. What are your
>experiences with a Novell-based server ? How stable are they, how about
>data security etc. ?
>
>Any comments appreciated !
>
Don't do it man! We suffered through that experience. Our first mistake was to not dedicate netware servers for the sole purpose of running Oracle. And when we did at one of our sites, it was still slow and unstable. The type of machines that you use to run Netware will make a difference too. If you don't have a good server (like a compaq or an AST) the server will abend on a regular basis. Also, (I hate to sound negative) Oracle doesn't give the same level of attention to this platform then it does for the Sun or HP platform. I'm still waiting for version 7.1.3 here (Canada is always behind in versions anyways). Just go with Unix, it'll make your life a lot easier... Francois Lachance Data Administrator Saskatchewan Highways and Transportation ______________________________________________________________________________________________________ Xref: alice comp.databases.oracle:6395 Path: alice!ragnarok.oar.net!malgudi.oar.net!caen!msunews!uwm.edu!news.alpha.net!solaris.cc.vt.edu!swiss.ans.net!paperboy.amoco.com!tabloid!usenet From: bgmccracken_at_amoco.com (Bill G. McCracken) Newsgroups: comp.databases.oracle Subject: Re: Oracle 7 on Sun 1000 vs Compaq Proliant Date: Thu, 06 Apr 1995 15:04:43 -0700 (PDT) Organization: Amoco Lines: 31 Message-ID: <3m1hh0$p5i_at_tabloid.amoco.com> References: <3kl3rt$a0o_at_blackice.winternet.com> <3lde8b$73d_at_newsbf02.news.aol.com> X-Newsreader: Forte Free Agent v0.38 toddm73670_at_aol.com (ToddM73670) wrote:
>In Message-ID: <3kl3rt$a0o_at_blackice.winternet.com>
>John Chandler writes
>>Does anyone have any experience that would indicate Oracle7
>>performance and scalability, specifically on the Sun 1000 (under
>>Solaris) or Compaq Proliant (under NetWare)?
>We are using Oracle 7.0.x under Netware on a Compaq Proliant 4000 w/ one
>pentium processor board and 192 MB RAM. The hardware performs very well,
>especially the proprietary dual channel High Speed SCSI card. We typically
>have over 60 concurrent connections on average per day. Most of these are
>Indexed lookups for specific information, so load is not as fantastic as
>you might think. However, Netware (we have used v3.x-4.x for ORACLE) does
>not have very good protection when things go wrong. Our server was up and
>down a lot before the latest release of 7.0.x, but still Novell is a
>Ring-Zero O/S. We plan to abandon Novell ASAP and move our stuff to a
>combination of HP-UX and MS-NT.
>Todd Meckenstock
>First USA Merchant Services
>Dallas, TX
>My opinions are my own, and not necessarily those of my employer.
yes, trash Oracle and the Pentium if you want to have a real server, get on a Unix box asap. Novell setup is only going to cause you more grief ($$$) than the additional expense of the true servers of Sun or HP. ******************* NT ***************************************** Xref: alice comp.databases.oracle:16333 Path: alice!ragnarok.oar.net!malgudi.oar.net!kira.cc.uakron.edu!neoucom.edu!news.ysu.edu!news.ecn.uoknor.edu!paladin.american.edu!zombie.ncsc.mil!simtel!lll-winken.llnl.gov!noc.near.net!usenet.teradyne.com!newsmaster From: Bill Pierce <bill.pierce_at_teradyne.com> Newsgroups: comp.databases.oracle Subject: Re: ORACLE on NT Date: 14 Aug 1995 14:50:11 GMT Organization: Teradyne - Boston Lines: 6 Message-ID: <40nnr3$if9_at_steadfast.teradyne.com> References: <40f0fu$6hq_at_coco.cri.dk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 1.1 (Windows; U; 16bit) To: lcn_at_mentor.cri.dk No NT works as well as Unix and is better integrated with the client/server model if PC's are your desktop. Unix has better scripting tools but there are shareware awk/shell/cron and other tools if needed. The OS has less software currently, but that is just until the vendors see a market. Gartner group prediccts NT licenses will eventually outsell unix in the next few years so JUMP ABOARD! ___________________________________________________________________________________________________ Xref: alice comp.databases.oracle:9442 Path: alice!ragnarok.oar.net!malgudi.oar.net!news.sprintlink.net!noc.netcom.net!netcomsv!uu3news.netcom.com!netcomsv!uucp3.netcom.com!kiki.icd.teradyne.com!newsmaster From: Bill Pierce <bill.pierce_at_teradyne.com> Newsgroups: comp.databases.oracle Subject: Re: how many users on a pentium? Date: 17 May 1995 15:06:20 GMT Organization: Teradyne, Incorporated Lines: 3 Message-ID: <3pd3dc$kkm_at_kiki.icd.teradyne.com> References: <3p0348$n50_at_rs10.tcs.tulane.edu> Oracle for NT on a pentium (we have a Compaq Proliant 1500R) of say 100 mhz and 80 megs of memory [dep. on type of processing] will easily support 16 concurrent users. _______________________________________________________________________________________________________ Re: NT vs. Unix From: Bill Pierce <bill.pierce_at_teradyne.com> Date: 2 Jun 1995 19:20:28 GMT Organization: Teradyne, Incorporated Newsgroups. comp.databases.oracle References: 1,2,3 Regarding the comments about ORACLE under NT not ready to support real prod usage: DON'T INSTALL WITH THE DEFAULTS THAT IS A PLAY DATABASE! If you are using the defaults for Oracle install then you obviously do not understand how to install an oracle database and if it took you the same amount of time to install Oracle under sun as under nt then either you are an SUN OS guru or do not understand NT - just the reduced effort in creating accounts/profiles/file systems under NT should save considerable time. Performance wise I have used oracle on a sparcstation with 96 megs of memory and on NT with 80 of memory and found them to be roughly equivalent in full table scans of a 400,000 row table. NT's mutli threaded capab. allows you to not have to mess with MTS di The type of CPU & DISKS will have a lot to do with performance.. when we went to fast wide SCSI the total turn around time for the full table scan was cut by 40%! The ability to use the ORACLE tools (SQL*DBA,Loader,SQL*plus) in a multi-tasking env. and not have to pay a fortune (YES I KNOW WORD RUNS UNDER UNIX) is a real plus. AS a pure database server NT and ORACLE work great. _____________________________________________________________________