Re: [Sqlrelay-discussion] RES: OCIEnvCreate() failed
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2011-09-21 16:53:33
|
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/client1/;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 > > Starting listener: > > sqlr-listener -id oracletest -config > /usr/local/firstworks/etc/sqlrelay.conf > > Starting 3 connections to oracletest : > > sqlr-connection-oracle8 -id oracletest -connectionid oracletest > -config /usr/local/firstworks/etc/sqlrelay.conf > > 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. > > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > http://p.sf.net/sfu/rim-devcon-copy2 > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... <mailto:Sql...@li...> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > Learn about the latest advances in developing for the > BlackBerry® mobile platform with sessions, labs& more. > See new tools and technologies. Register for BlackBerry® DevCon today! > http://p.sf.net/sfu/rim-devcon-copy1 > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |