[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

741.0. "Oracle, SQL*NET, runaway processes" by REDBRD::BROCKUS (I'm the NRA.) Thu Sep 20 1990 03:42

Is there a notes file for those of us who must live with Oracle, instead
of those who must sell against it?

We have recently had a problem with our 8820 having no idle time, and 
spending an enormous amount of time in supervisor mode.  The system manager
here said he's seen it before, and we should just reboot the machine.

Upon further questioning, he said "Oh, yeah.  I remember now.  This 
happens every so often when one of our remote SQL*net users get upset with
slow response time, and types a control-y at his workstation.  Then he
gets his prompt back and continues, not realizing that he has hurt
the big VAX."

What I did was:  MONI PROC/TOPCPU
Then I selected several of the "piggy" processes named NETnnnn,
where nnnnn in the process name represented the link number.

Then:

MC NCP
SH LINK nnnnn  ! This shows me what node the link came from, say FOO.
SH KNO LINK WITH NODE FOO
TELL FOO SHO KNO LINK WITH NODE BAR  !BAR is our 8820.

The 2 reports will, in these bad cases, show a discrepency.  A process
that exists on our 8820 without a corresponding link to the outside
world needs to have its process deleted.  (DISCONNECT LINK didnt work.)

This fixed our problem, and restored some idle time to our 8820.

We had several of these, and there was no automated way to do this -- yet.

If there was an Oracle notesfile, I'd post this there, instead of here,
which I see as a sales-support tool.

JPB
T.RTitleUserPersonal
Name
DateLines
741.1*They* are the "World's leading database company." MBALDY::LANGSTONRdb Sales Support MercenaryThu Sep 20 1990 22:2120
Call Oracle's support hotline.  They claim to be the world's leading...
If there's anybody left to answer the phone (I know - it's a cheap shot) they
should be able to help you.  We should spend as little of our time (I'm assuming
you're sales support) as is necessary to solve Oracle's problems.

I understand that it's a customer problem, too.  Make sure you're customer knows
that the Oracle support option is one y'all should consider.

One of the nice things about Rdb is that the Rdb engineers work very closely 
with the VMS engineers.  Rdb is engineered with VMS in mind.  VMS is engineered
with DECnet in mind, so that DECnet access is "built-in" to Rdb.  This makes 
remote access with Rdb very clean.  Rdb doesn't have to worry about network
stuff; VMS does all that for Rdb.

Remote access with ORACLE and SQL*Net requires that the ORACLE software stick
its fingers all the down into the network and get around all that stuff that's
built-in to VMS (and every other OS they run on).  No wonder poor orphaned
processes are left lying around.

Bruce
741.2More explanationREDBRD::BROCKUSI'm the NRA.Sat Sep 22 1990 03:5834
I failed to make myself clear.  Some information I placed in my intro
note should have made it into the topic note here.

1.  I am not sales support.  My customer is paying in excess of $100 an
    hour for my Digital added value as a resident.

2.  Part of the added value a customer gets from contracting with Digital
    for a resident is his access to the vast experience base available
    to him via Notes.

3.  While I take every opportunity to promote the use of Digital products
    at my customer's site, some things are simply not changeable.  My
    customer's reliance on Oracle is one of those things.  We are consumers
    of an internally developed software product, and Oracle is deeply
    imbedded in that product.  They have gone so far as to build Oracle
    into their contractual commitments with their own customers.  Changing
    to Rdb is simply not an issue.  (I am working on convincing them to
    do all new work in Rdb, and they are receptive, but this will not
    eliminate Oracle from this site.

4.  As the resident VMS expert, when we have a problem on the cluster, any
    problem, I am expected to diagnose, fix, and develop procedures for
    handling it and/or avoiding it in the future.  That being the case,
    a historical listing in Notes of other manager's experiences would
    make my job easier, and my contributions might help others later.

5.  I, too, am not particularly interested in doing Oracle's job for them.
    But I cannot wait for them to produce a better product, and I cannot insert
    a better product in their place.

Your answers tell me that I am basically on my own.  I accept that, though
it makes my job that much more difficult.


741.3unix people NOVA::NEEDLEMANno good deed goes unpunishedMon Sep 24 1990 15:266
    try belfst::oracle_on_unix
    
    someone there might know something
    
    
    Barry
741.4Oracle haven't fixed itBROKE::ASHELL::WATSONon, not vacation, but holidayFri Oct 05 1990 15:578
    I was at an Oracle course recently and this came up. One of the people
    on the course said that they had reported this to Oracle, who said that
    they were working on it. It is not fixed in the most recent (6.0.30?)
    version they have received.
    
    Apart from that, I must refer you to Oracle support. 
    
    	Andrew.