[Sqlrelay-discussion] OCIEnvCreate failed, Oracle 10g, Solaris x86-64

[Daniel S. <sql...@bo...>]

All, 

I'm having an issue with sqlrelay 0.41 (I have not tried any earlier
versions).  When starting up sqlrelay, I get OCIEnvCreate() failed.  I've
tried the following to remedy the situation: 

1. Installed with 10g libraries from local Oracle DB install (64Bit) 

2. Installed with 10g instantclient libraries for 64bit 

3. Installed with 10g instantclient libraries for 32bit 

4. Tried removing code from oracle8connection.C to roll back to
OCIInitialize instead of OCIEnvCreate, with similar results 

5. Enabled debug to see what's going on. 

See output from my tests below.  Any insight would be appreciated. 

Thanks, 

Daniel Smith 

    [ ?0  dc1testlab112  root  3  !1509  &0  12:01:59 ]
/opt/firstworks # sqlr-start -id oracletest

Starting listener:
  sqlr-listener -id oracletest -config /opt/firstworks/etc/sqlrelay.conf
-debug
Debugging to: /opt/firstworks/var/sqlrelay/debug/sqlr-listener.8825

Starting 3 connections to oracletest :
  sqlr-connection-oracle8
-id oracletest -connectionid oracletest -config
/opt/firstworks/etc/sqlrelay.conf -debug
Debugging to: /opt/firstworks/var/sqlrelay/debug/sqlr-connection.8861
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. 

    [ ?1  dc1testlab112  root  3  !1510  &0  12:02:07 ]
/opt/firstworks # cat var/sqlrelay/debug/sqlr-listener.8825
04/29/2009 12:02:06 CDT listener [8825] : creating shared memory and
semaphores

04/29/2009 12:02:06 CDT listener [8825] : id filename:

04/29/2009 12:02:06 CDT listener [8825] :
/opt/firstworks/var/sqlrelay/tmp/ipc/oracletest

04/29/2009 12:02:06 CDT listener [8825] :       creating shared
memory...

04/29/2009 12:02:06 CDT listener [8825] :       creating
semaphores...