Is anyone running Oracle on Netware?
m...@mailexcite.com
looking at running Oracle 8 servers on Netware 4.11 or 5.0. As all of
our current servers are Netware, this would make sense from an ease of
management standpoint.
However, all the press seems to go to Oracle on NT (or UNIX).
Is anyone out there running Oracle on Netware, with success?
Can anyone tell me why I would be better off with NT ? (Personally, I
trust Netware far more from a stability standpoint)
Barbara Kennedy
also NT. The majority of problems we find are incorrectly configured backup
software (does not seem to matter if it is NT or Netware). You can get an
unstable situation in either case. One is not any easier to manage than the
other except at least with netware I have rconsole - important when you do
remote support over a modem! NT does not have that (cannot run a program on
the server from a workstation without purchasing a software package).
Jim
m...@mailexcite.com wrote in message
<3652f31f...@nntp.ix.netcom.com>...
Steven H. Meller
mentioned in my post here yesterday, I ran out of memory (stack space
specifically) running a PL/SQL stored procedure that was not very large.
Although I had more than enough on the box altogether (288 MB) for a server
that is only running Oracle (the application is still in integration
testing). Same stuff on NT ran flawlessly in a very small SGA footprint.
I am concerned about long term support. After logging a case with Oracle
support, the undocumented system parameter was discovered by myself in a
search of the Problems database. Whereas the NT product is in active
development and escalating use (translates to "money factory").
Don't make exclusively a decision based on today's dollars (marks, yen,
whatever). I agree with you regarding (lack of) stability in NT. But I
view that as somewhat temporary based on the amount of interest registered
by customers in the form of purchasing power. If you've beta tested
software before, you should understand the "safety in numbers" philosophy
that this expresses.
HTH,
Steve
meller at 24by7consulting dot com
m...@mailexcite.com wrote in message
<3652f31f...@nntp.ix.netcom.com>...
>
Fuzzy
<bar...@teleport.com> wrote:
>I work for a company that has many customers running Oracle on Netware and
>also NT. The majority of problems we find are incorrectly configured backup
>software (does not seem to matter if it is NT or Netware). You can get an
>unstable situation in either case. One is not any easier to manage than the
>other except at least with netware I have rconsole - important when you do
>remote support over a modem! NT does not have that (cannot run a program on
>the server from a workstation without purchasing a software package).
>Jim
Not true. Look up the rcmd service in NT - it allows remote control
of NT.
Ciao
Fuzzy
:-)
m...@mailexcite.com
<sme...@nospam.com> wrote:
>My principal complaint has to do with the absence of virtual memory. As
>mentioned in my post here yesterday, I ran out of memory (stack space
>specifically) running a PL/SQL stored procedure that was not very large.
>Although I had more than enough on the box altogether (288 MB) for a server
>that is only running Oracle (the application is still in integration
>testing). Same stuff on NT ran flawlessly in a very small SGA footprint.
I have HIGH hopes for Netware 5, since it now offers virtual memory
support. I don't know, however, if it has been implemented in a way
that existing applications can utilize it/
>I am concerned about long term support. After logging a case with Oracle
>support, the undocumented system parameter was discovered by myself in a
>search of the Problems database. Whereas the NT product is in active
>development and escalating use (translates to "money factory").
As am I. I find it interesting, and somewhat frustrating, that while
NT gives me the most problems by a WIDE margin, it also seems to have
the most options and support. I have always had very dependable
systems that run Netware, but I have very limited choices when it
comes to applications.
Jim Kennedy
(rconsole does; opens a window that is the screen of what is
going on on the server.)
Jim
Jim Kennedy X7055
Jonathan Gennick
>With Oracle 8 (5 user) now shipping with Novell Netware, we are
>looking at running Oracle 8 servers on Netware 4.11 or 5.0. As all of
>our current servers are Netware, this would make sense from an ease of
>management standpoint.
<snip>
>Is anyone out there running Oracle on Netware, with success?
I used to run Oracle on both Netware and NT, and had no
problems with either platform. What I did find was that
dealing with two platforms was a bit of a pain, so I've
consolidated everything onto NT. Why NT? Mostly because the
firm I work for has decided to convert their infrastructure
from Novell to NT. I'm just staying within the desired
architecture.
Consolidating was a good thing, because HP-Unix was recently
introduced into the mix. So now I manage Oracle on HP and
NT--still two platforms, but better two than three.
Jonathan
Mark Bullen
> With Oracle 8 (5 user) now shipping with Novell Netware, we are
> looking at running Oracle 8 servers on Netware 4.11 or 5.0. As all of
> our current servers are Netware, this would make sense from an ease of
> management standpoint.
Okay, I got to admit I'm somewhat of a Netware biggot, we've been using
Oracle on Netware since version 6 and it's been really reliable. That's
four years of experience for me and another couple for my predecessor, so
I know what I'm talking about I guess. The few times a server has ABENDed
during these last 4 years (and I can count them on one hand), the server
has *always* recovered without going to backup tape. Luckily, Oracle
seems to have some talented NLM coders in their midst and they write very
stable code. In my opinion the issue of stability in this case is more
application oriented rather than platform oriented (NT vs. Netware). If
the code is crap, it doesn't matter what OS it runs on, it's going to be a
help desk problem generator. The other piece to the puzzle is obtaining
stable hardware from a good vendor (Compaq, HP, etc.), it makes a
difference no matter what OS you choose.
Needless to say, I'm not impressed with NT server despite MS's hype to the
contrary. It's still far too imature (and has too many roots in desktop
OS and peer-to-peer networking) for my taste. We have one NT server that
I've had to manage for about 2 years now. I've already had to rebuild it
from the ground up which cost me four days to get everything back to
normal. The boot sector took a dirt nap and NT's repair "feature" in
setup could *not* repair it! Talk about frustration! In contrast, in 4
years, I've not had to *ever* rebuild a Netware server -- and we have 11
of them. So, I'd say your trust in it's stability is highly warranted.
It's been my experience also.
However, that being said, it would be easy for me jerk my knee and say
that Netware is the answer. You really have to consider how the DB is
going to be used. In other words, use the right tool for the right job.
My opinion on the OSes:
Advantages of Netware: Pound for pound (i.e. same hardware), an Oracle
server on Netware is faster than on NT if both OSes and DBs are properly
tuned. The tests prove it. NDS and other manageability features
(rconsole) are also an advantage. Support from Oracle is good, they have
a good working relationship with Novell.
Disadvantages of Netware: Oracle on Netware does seem to have a
disadvantage in memory management which can provide for some scalability
problems with large user counts. Also, Netware's disk subsystem is not
multithreaded which means that it can only process a request to retrieve a
block from disk one at a time. However, this can be somewhat overcome by
stuffing the server with gobs of RAM and caching as much of the DB as you
can, which you want to do anyway. Also some of these disadvantages may be
alleviated by NW5 with it's new memory architecture and support for
virtual memory, I just haven't seen any evidence if it works with Oracle
as it's currently written yet.
Advantages of NT: Evidence suggests that it's SMP support is a little
more scalable (although not much from what I've seen) and it can maybe
handle more concurrent users on one server due to more advanced memory
architecture (than NW4 at least).
Disadvantages of NT: Immature. Stability is a question. Remote
manageability is poor. Intregration with NW4/5 networks is poor unless
something like NDS for NT is added.
Well, that's my 2 cents worth. Hope it helps.
choi, sang soon
But Our Oracle did'nt execute this package ,
Error Message is below
SQL> execute dbsm_shared_pool.kepp('SECURITY_INFO');
security_info is table and this statement executed in user not system user .
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "HUMAN.DBMS_SHARED_POOL" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
P.S. HUMAN is Oracle User .
I execute script in SYSTEM user dbsmpool.sql and
grant execute on dbsm_shared_pool to HUMAN ;
Thanks in Advance .
<mailto:top...@freeway.co.kr>
Jurij Modic
You need to create this package under schema SYS (connected as SYS or
INTERNAL), not under SYSTEM. Besides, it is not enough to run only
script "dbmspool.sql" - this is only script for creating package
specification, script for creating package body is called
"prvtpool.plb". So this is what you should do:
1. Drop package SYSTEM.DBMS_SHARED_POOL
2. Connect as SYS or INTERNAL
3. Run dbmspool.sql
4. Run prvtpool.plb
5. Grant EXECUTE on DBMS_SHARED_POOL to HUMAN
> Thanks in Advance .
>
> <mailto:top...@freeway.co.kr>
HTH,
Jurij Modic <jmo...@src.si>
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer
Nisar Tareen
Steven H. Meller wrote in message <36536...@stnws02.atl.mediaone.net>...
>My principal complaint has to do with the absence of virtual memory. As
>mentioned in my post here yesterday, I ran out of memory (stack space
>
Steven,
Check the Shared Memory by command. ipcs -m
and than if you see oracle after closing the instance remove the entry
from shared memory by ipcrm command.
Good Luck.
Nisar Tareen
Allianz Canada.