Summary of responses for Segmentaion fault

From: Sridhar Sundararaman <sundara_at_essex.ecn.uoknor.edu>
Date: 10 Sep 1993 00:04:02 GMT
Message-ID: <26og9i$spv_at_constellation.ecn.uoknor.edu>

The following are the responses I had for my Segmentation fault problem. Thought might be of help to some of you.

My original Message:

I have a Pro*C program that handles our small library. Everytime this program is run, it first connects to Oracle with the command

        "EXEC SQL CONNECT :userid IDENTIFIED BY :password"

But a weird problem occurs even before the program reaches this stage. It is giving a "Segmentation fault" even before trying to connect. Infact the CONNECT is the first EXEC SQL command in the program only after the EXEC SQL DECLARE and EXEC SQL INCLUDE statements.

Oracle has been installed on the DEC3000/200 on Ultrix. About 20 of us use this program, but not more than 3 or 4 at a time.

What is weird about this problem is that it does not happen to all the users, and even among the users who get it, it happens only once in a while. Could the shell in which the user is, cause any problems??

Any help in this regard would be appreciated.

Thanks in advance,

-Sridhar

Response 1:

Hi there!

---

I'm working on SGI's Indigo II machine and I had similar problems until I increased user memory quotas.Check MAXUMEM parameter and rlimit_xxxx_max parameters where xxxx is data or stack.Your program simply breaks through maximum address space available for these users.Check your kernel parameters and resource quotas set in /etc/default/login on my machine,relink unix and it should be OK.Dec has always had advanced memory management features in their OSes (I know about VMS) and reconfiguring Ultrix might be the clue! Hope it helps!
Kindest regards!
Mladen Gogala
ASTER Ljubljana

Tel  : ++38 61 183-511
FAX  : ++38 61 183-165
Email: gogi_at_aster.si

Snail-mail:
ASTER Ljubljana
Nade Ovcakove 1
61000 Ljubljana
Slovenia

Response 2:

I haven't read to far into the Pro*C file you say resulted in the segmentation fault, nor have I seen any responses in comp.databases.oracle.  When you do find out what the error is please post for us curious people.

In going over the Oracle Precompiler Lab Notes (from Oracle) I see find the following:

   ORACA Read-write Contents
   Field

• ---------------------------------- oradbgf Master Flag 1, for enabling all ogther ORACA fiels 0, otherwise orastxtf Flag for storing the most recently executed SQL statement 3, always 2, upon errors and warnings 1, upon errors only 0, never

Try setting oradbgf first.

Other than that I can't see anything wrong.

---

Daniel Looby            |The shortest distance between two points  
Systems Analyst II      |is under construction. 
dan.looby_at_oit.gatech.edu|         - Noelie Altito
404-894-9587            |
                        

Response 3:

    Any time I have encountered this problem it was due to lack memory on the machine doing the execution.

Thanks for the help. From my part, since I dont have the SU prvilege, I am waiting for our SA to take some action.

-Sridhar
Received on Fri Sep 10 1993 - 02:04:02 CEST