Segmentation Fault (core dumped) while connecting to oarcle

Posted on 2006-12-16 05:33:33-08 by austin

Hi Need Help I am getting Segmentaion fault when running the perl script. aussvcd01% ./fw1_audit.pl Function Called Connecting to Oracle Segmentation Fault (core dumped

Direct Responses: 3821 | 9919 | Write a response

Posted on 2006-12-16 05:45:07-08 by austin in response to 3820

Re: Segmentation Fault (core dumped) while connecting to oarcle

Here are some useful lines from DBD installation Looks good LD_RUN_PATH=/oracle/app/oracle/product/10.2.0/lib32:/oracle/app/oracle/product/10.2.0/rdbms/lib32 Using DBD::Oracle 1.19. Using DBD::Oracle 1.19. Multiple copies of Driver.xst found in: /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/ /usr/local/lib/perl5/site_perl/5.8.7/i86pc-solaris/auto/DBI/ at Makefile.PL line 1635 Using DBI 1.53 (for perl 5.008008 on i86pc-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/ Writing Makefile for DBD::Oracle

Direct Responses: 3832 | Write a response

Posted on 2006-12-18 11:48:11-08 by byterock in response to 3821

Re: Segmentation Fault (core dumped) while connecting to oarcle

Having a quick look at is it seem the error is being throw on DBI rather than DBD. I have no suggestion right now but you would be much better off posting your question to dbi-users@perl.org (you don't need to subscribe in order to post) and you won't be automatically subscribed either as very few people use this form for dbi or driver support. dbi-users is where you'll get the best support

Direct Responses: 4219 | Write a response

Posted on 2007-01-31 16:49:33-08 by jplynch in response to 3832

Re: Segmentation Fault (core dumped) while connecting to oarcle

I'm not sure if I am having the same problem or not, so I will post here first. I recently patched my oracle version to 9.2.0.8 and suddenly all my perl programs that connect to Oracle die with a segmentation fault. I figured I just needed to recompile DBD::Oracle. To be on the safe side I recompiled DBI as well. If I run the programs as root they run fine, but if I swith to one of the other users on the system I get a segmentation fault. My first suspect is I am seeing a permission issue. Anyone have any thoughts? Thanks. -Paul

Direct Responses: Write a response

Posted on 2009-02-10 23:59:41-08 by whocares in response to 3820

Re: Segmentation Fault (core dumped) while connecting to oarcle

...After having spent several useless hours trying to find an answer to this question on both Google and Metalink, and then trying to decipher stack trace output from core dump, it turns out that there was no setting in my .profile (in some cases, .bash_profile) file for LD_LIBRARY_PATH.
If Oracle was working just fine, but suddenly you come in to work and find it to have crashed...
And then- when you go to start the listener, rman, or sqlplus, and you get the mysterious error:

Segmentation Fault (core dumped)

BE SURE YOU HAVE A VALID SETTING FOR THE LD_LIBRARY_PATH

To determine this, simply type: echo $LD_LIBRARY_PATH at the UNIX command prompt. ...It should return the $ORACLE_HOME/lib directory.

BTW- We're using Oracle 10.2.0.3 on Solaris 10.

Hope this saves you more time than I wasted! ;-)

Direct Responses: Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.