Thread: [Sqlrelay-discussion] OCIEnvCreate() failed
Brought to you by:
mused
Menu
▾
▴
sqlrelay-discussion
|
From: Diogo <dio...@gm...> - 2011-09-17 20:59:56
|
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. |
|
From: David M. <dav...@fi...> - 2011-09-19 02:41:20
|
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 |
|
From: Diogo <dio...@gm...> - 2011-09-19 11:44:42
|
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 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 |
|
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 |
|
From: Diogo <dio...@gm...> - 2011-09-21 17:17:43
|
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
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
----------------------------------------------------------------------------
--
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
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X