Re: [Sqlrelay-discussion] OCIEnvCreate() failed

[David M. <dav...@fi...>]

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...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion



_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com