[Sqlrelay-discussion] RES: RES: OCIEnvCreate() failed

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

Hi Dave.thanks for you help =)

103 /> sqlrsh -id oracletest

SQLRShell - Version 0.22

        Connected to: localhost:9000 as oracle

        type help; for a help.

0> select * from empresa;

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

COD_EMPRESA

===========

        Rows Returned   : 0

        Fields Returned : 0

        System time     : 0

0> exit

1> quit;

The connect Ok Now. Set de Variables the Mysql/postgree stop running..

PostGre

root@ferrari desenvshm

105 /> LD_PRELOAD=/usr/local/firstworks/lib/libpqsqlrelay.so

root@ferrari desenvshm

106 /> export LD_PRELOAD

root@ferrari desenvshm

107 /> psql -h localhost -p 8009 -U barcode -W

Password for user barcode:

psql (9.0.3, server 0.0.0)

WARNING: psql version 9.0, server version 0.0.

         Some psql features might not work.

Type "help" for help.

Segmentation fault

Mysql

root@ferrari desenvshm

109 /> LD_PRELOAD=/usr/local/firstworks/lib/libmysql51sqlrelay.so

root@ferrari desenvshm

110 /> export LD_PRELOAD

root@ferrari desenvshm

111 /> mysql -h localhost -P 8009 --user=barcode --password=barcode

Welcome to the MySQL monitor.  Commands end with ; or \g.

root@ferrari desenvshm

De: David Muse [mailto:dav...@fi...] 
Enviada em: quarta-feira, 21 de setembro de 2011 13:56
Para: Discussion of topics related to SQL Relay
Assunto: Re: [Sqlrelay-discussion] RES: OCIEnvCreate() failed

This is definitely strange.  Everythng looks fine to me.  The only thing
that's a little odd is the trailing slash in the oracle_home, but that
shouldn't matter.

There still could be a permissions problem in a directory higher up than the
tnsnames.ora file.  Try setting the runasuser/runasgroup to the same
user/group that you tested sqlplus with and see if that makes any
difference.  It's got to be something like that.

Dave
dav...@fi...

On 09/19/2011 07:44 AM, Diogo wrote: 

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