Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Segmentation Fault while running the Pro*C reports in 10gR2 on RHEL 5.0

Posted on 2008-11-11
6
Medium Priority
?
737 Views
Last Modified: 2013-12-19
Hi,
We have recentely migrated from Oracle Database version 8.0.4 on HP-UX to Oracle 10g Release 2 (10.2.0.4) on RHEL 5.0. The database migration was successful. We are now trying to migrate the Pro*C reports which were succussfully running in 8.0.4 database on HP-UX and make them run on new 10gR2 (RHEL 5.0.) server.  They are succussfully compiling and the executable files are genertaing. But, when we are trying to run the executables, they are throwing 'Segmentation fault' error. These are running fine in previous 8.0.4 database.
Please help us to find the solution. If u need any further information, please reply back to us asap.

We are attaching a .pc file which contains the code.
0
Comment
Question by:pageast
  • 3
  • 3
6 Comments
 
LVL 27

Expert Comment

by:sujith80
ID: 22928668
Does gdb ing  the core say anything?
0
 

Author Comment

by:pageast
ID: 22928678
Hi,
thanx for replying. Can u please tell me how to get the core. Can you please explain your question ..!!
0
 

Author Comment

by:pageast
ID: 22928769
Hi,
I have checked out for the core file that was supposed to be generated in the following locations:
/oracle10/app/oracle/admin/orac/cdump (CORE_DUMP_DEST)
/oracle10/app/oracle/product/10.2.0/db/precomp/demo/proc
and in complete /oracle10 mount point. There was no core file that has been generated for the Segmentation file error.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 27

Expert Comment

by:sujith80
ID: 22928869
core file should be there in the directory where you have the exe.

It is not generated by oracle, it is generated by the exe.

You have to check gdb to see how to debug the core, definitely it will point you out to the bug.
0
 

Author Comment

by:pageast
ID: 22928901
we are executing the following command :
make -f demo_proc.mk EXE=jobldgr OBJS=jobldgr.o build

We are executing this command in the location:
/oracle10/app/oracle/product/10.2.0/db/precomp/demo/proc
the executable file demo_proc.mk and the file jobldgr.pc are all located in the same folder.

But we cannot find any core file in that directory.
0
 
LVL 27

Accepted Solution

by:
sujith80 earned 1500 total points
ID: 22936495
I guess you already have the executables generated.

You shoul look for the core file in the directory where you run the exe from.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question