Pro*C/Net8 Problem

From: <kirk_at_kaybee.org>
Date: 2000/04/12
Message-ID: <8d2pq7$6o$1@news-int.gatech.edu>#1/1

I can't get my Pro*C program to connect to a remote database (I am using Oracle 8i with all the latest patches, running on Linux). It simply segfaults. However, I can connect fine to a local database. The difference is that, when connecting to a local database, I simply do this:

CONNECT user IDENTIFIED BY pass;

When connecting to a remote database, I do this:

CONNECT user IDENTIFIED BY pass USING connect_string;

where 'connect_string' is a name properly defined in tnsnames.ora (i.e. running sqlplus user/pass_at_connect_string works just fine).

When I turn on Net8 Tracing, here is what I get right before it segfaults (IP address changed below, but in the real log, it resolves correctly):

nttbnd2addr: entry
nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: W.X.Y.Z
nttbnd2addr: exit

nsmal: 428 bytes at 0x824bfb8
nsmal: 1620 bytes at 0x824c168

nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: No PROTOCOL.ORA file is found
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 8.

-- 
 Kirk Bauer -- CmpE, Georgia Tech -- kirk_at_kaybee.org -- Avid Linux User
    GT Sport Parachuting Club!  http://cyberbuzz.gatech.edu/skydive
     Opinions expressed are my own, but they should be everybody's.

Received on Wed Apr 12 2000 - 00:00:00 CDT