From owner-freebsd-database@FreeBSD.ORG  Fri May 18 16:39:09 2007
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id A3A3316A401
	for <freebsd-database@freebsd.org>;
	Fri, 18 May 2007 16:39:09 +0000 (UTC)
	(envelope-from itetcu@FreeBSD.org)
Received: from it.buh.tecnik93.com (it.buh.tecnik93.com [81.196.204.98])
	by mx1.freebsd.org (Postfix) with ESMTP id 629DA13C468
	for <freebsd-database@freebsd.org>;
	Fri, 18 May 2007 16:39:09 +0000 (UTC)
	(envelope-from itetcu@FreeBSD.org)
Received: from it.buh.tecnik93.com (localhost [127.0.0.1])
	by it.buh.tecnik93.com (Postfix) with ESMTP id 37B752C50D76;
	Fri, 18 May 2007 19:19:47 +0300 (EEST)
Date: Fri, 18 May 2007 19:19:46 +0300
From: Ion-Mihai Tetcu <itetcu@FreeBSD.org>
To: Sally Janghos <list@deeboz.ca>
Message-ID: <20070518191946.567e1f6c@it.buh.tecnik93.com>
In-Reply-To: <20070509214454.GA65527@deeboz.ca>
References: <20070509214454.GA65527@deeboz.ca>
X-Mailer: Claws Mail 2.9.1 (GTK+ 2.10.12; i386-portbld-freebsd7.0)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Cc: freebsd-database@freebsd.org
Subject: Re: oci8 php extension Bus error (core dumped)
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 18 May 2007 16:39:09 -0000

On Wed, 9 May 2007 15:44:54 -0600
Sally Janghos <list@deeboz.ca> wrote:

> I'm experiencing a Bus error (core dumped) when running a
> oci_connect.  Can anyone give me some advise to start troubleshooting?
> 
> Here is what I've got on my system (the Oracle 10g Express instance
> is on a WinXP box):
> 
> FreeBSD 6.1-RELEASE-p2
> 
> PHP 5.2.1 with Suhosin-Patch 0.9.6.2 (cli) (built: Mar 21 2007
> 20:28:04) Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend
> Technologies
> 
> OCI8 Support => enabled
> Version => 1.2.3
> Revision => $Revision: 1.269.2.16.2.30 $
> Active Persistent Connections => 0
> Active Connections => 0
> Oracle Version =>
> Compile-time ORACLE_HOME =>
> Libraries Used =>
> Temporary Lob support => disabled
> Collections support => disabled
> 
> Directive => Local Value => Master Value
> oci8.default_prefetch => 10 => 10
> oci8.max_persistent => -1 => -1
> oci8.old_oci_close_semantics => 0 => 0
> oci8.persistent_timeout => -1 => -1
> oci8.ping_interval => 60 => 60
> oci8.privileged_connect => Off => Off
> oci8.statement_cache_size => 20 => 20
> 
> The script I'm trying to run:
> 
> <?php
>   PutEnv("ORACLE_SID=EX");
>   PutEnv("ORACLE_HOME=/usr/local/oracle8-client");
>   $c=oci_connect("user", "passwd", "EX");
> ?>

Please check your 
/usr/local/oracle8-client/network/admin/tnsnames.ora

So you have 'EX' defined correctly in there ?
Does it match the corresponding config on your windows box ?

--
IOnut