[Sqlrelay-discussion] RES: OCIEnvCreate() failed

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Dave... the verify permissions Everything OK.

Below are the settings.

34 /oracle/product/10.2.0/client1/network/admin> sqlr-start -debug -id
oracletest

Starting listener:

  sqlr-listener -id oracletest -config
/usr/local/firstworks/etc/sqlrelay.conf -debug

Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12778

Starting 3 connections to oracletest :

  sqlr-connection-oracle8 -id oracletest -connectionid oracletest -config
/usr/local/firstworks/etc/sqlrelay.conf -debug

Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.12780

OCIEnvCreate() failed.

error:

Couldn't log into database.

sqlr-connection-oracle8 failed to start.

Thanks to MP3.com for sponsoring:

        Clustered/Replicated database support.

        Perl API.

Thanks to FeedLounge for sponsoring:

        Query routing and filtering.

Ls in tnsnames.ora:

/oracle/product/10.2.0/client1/network/admin> ll

total 16

drwxrwxrwx 2 oracle oracle 4096 Sep 16 18:20 samples

-rwxrwxrwx 1 root   root    172 Sep 16 18:13 shrept.lst

-rwxrwxrwx 1 root   root    175 Sep 16 18:13 sqlnet.ora

-rwxrwxrwx 1 root   root    518 Sep 18 08:32 tnsnames.ora

Sqlplus :

36 /oracle/product/10.2.0/client1/network/admin> sqlplus
barcode/barcode@barcode

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 19 08:41:11 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL>

Tnsping :

37 /oracle/product/10.2.0/client1/network/admin> tnsping barcode

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 19-SEP-2011
08:41:34

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

/oracle/product/10.2.0/client1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
100.0.0.129)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = barcode)))

OK (0 msec)

Sqlrelay.conf :

<?xml version="1.0"?>

<!DOCTYPE instances SYSTEM "sqlrelay.dtd">

<instances>

        <instance id="oracletest" port="9000"
socket="/tmp/oracletest.socket" dbase="oracle8" connections="3"
debug="listener_and_connection" maxconnections="5" maxqueuelength="0"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener"
handoff="pass">

                <users>

                        <user user="oracle" password="oracle"/>

                </users>

                <connections>

                 <connection connectionid="oracletest"
string="user=barcode;password=barcode;oracle_home=/oracle/product/10.2.0/cli
ent1/;oracle_sid=barcode" metric="1"/>

                </connections>

        </instance>

</instances>

De: David Muse [mailto:dav...@fi...] 
Enviada em: domingo, 18 de setembro de 2011 23:44
Para: Discussion of topics related to SQL Relay
Assunto: Re: [Sqlrelay-discussion] OCIEnvCreate() failed

I think this is usually caused by bad permissions on the tnsnames.ora file.
The user that SQL Relay is running as probably doesn't have permissions to
read it.

One solution is to add read permissions for others to the file.  Another is
to put the user that SQL Relay is running as in the group that owns the
tnsnames.ora file.

If that doesn't turn out to be the issue, then please post your
sqlrelay.conf file and tnsnames.ora file.

Dave

On 09/17/2011 04:59 PM, Diogo wrote: 

Hi ,

I'm installing and the problem below. Can anyone help?

Works with Opensuse 11.2? With the Oracle Client installed on the machine
since I can connect with SQLrelay or need to be installed in bank machines?

sqlr-start -id oracletest