problem with ROracle - Internal heap ERROR 17177

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

problem with ROracle - Internal heap ERROR 17177

Marco Kienzle
Dear R-users,

here is an error that you might encounter when using ROracle.

> library(ROracle)
Loading required package: DBI
> con <- dbConnect(dbDriver("Oracle"), "mkienzle/******@tabs")
> dbListTables(con)
********** Internal heap ERROR 17177 addr=0x0 *********


******************************************************
HEAP DUMP heap name="Alloc statemen"  desc=0x9163cc4
....
etc...
....
Segmentation fault


People have been reporting such an error when different version of the
Oracle client and server are used
(http://homepage.internet.lu/dbacomp/html/9i.html). David James
suggests compiling ROracle using ProC/C++ argument PREFETCH=0.

To do so and fix this problem, you have to re-install ROracle using a
modified Makefile.in file. Below is a description of how to do so under
Linux.

        (1) REMOVE the currently installed ROracle package
        (2) un-pack ROracle-<version>.tar.gz
        (3) modify ROracle/src/Makefile.in by adding the PREFETCH=0
    argument to the ProC/C++ command
       
        ----original version----
        RS-Oracle.c: RS-Oracle.h RS-Oracle.pc
         $(PROC) CODE=$(CODE) MODE=$(MODE) INCLUDE=$(RHOME)/include \
                 PARSE=$(PARSE) LINES=$(LINES) RS-Oracle.pc

        ----modified version----
        RS-Oracle.c: RS-Oracle.h RS-Oracle.pc
         $(PROC) CODE=$(CODE) MODE=$(MODE) INCLUDE=$(RHOME)/include \
                 PARSE=$(PARSE) LINES=$(LINES) PREFETCH=0 RS-Oracle.pc

        (4) INSTALL the "modified" ROracle package


cheers,
marco

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html