[R] problem with ROracle - Internal heap ERROR 17177

From: Marco Kienzle <Marco.Kienzle_at_noaa.gov>
Date: Tue 14 Feb 2006 - 06:17:14 EST


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



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Feb 14 06:36:43 2006

This archive was generated by hypermail 2.1.8 : Wed 15 Feb 2006 - 13:30:11 EST