oci8+rubyscript2exe -> TNS-12538

P

pihentagy

Hi all!

I tried to pack to an exe a ruby script, which uses oci8.
On my machine it works fine, but when I run it on an other machine I
get the following error:
(I also dumped the files packed by rubyscript2exe)
Can somebody hint what could be the problem?
Do I need any other file to run the program in any other machine?

Any type of hints is welcome

Thanks
Gergo

***********************************************************************
Fatal NI connect error 12538, connecting to:
(DESCRIPTION=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=ADONIS)
(Port=1521))(CONNECT_DATA=(SID=PPRO2003)(CID=(PROGRAM=C:
\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.2\bin\ruby.exe)(HOST=POLLUX)
(USER=bkozma))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 11-JAN-2008 10:37:11
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12538
TNS-12538: TNS:no such protocol adapter
ns secondary err code: 12560
nt main err code: 508
TNS-00508: No such protocol adapter
nt secondary err code: 0
nt OS err code: 0

Here comes files packed in the exe:

d bin
f bin\digest.so (24663)
f bin\etc.so (20561)
f bin\fcntl.so (20565)
f bin\iconv.dll (892928)
f bin\iconv.so (24661)
f bin\LIBEAY32.dll (1077248)
f bin\msvcrt-ruby18.dll (872518)
f bin\OCI.DLL (114688)
f bin\oci8lib.so (61509)
f bin\openssl.so (180313)
f bin\OraClient9.Dll (1536272)
f bin\OraCommon9.Dll (590096)
f bin\ORACORE9.DLL (647440)
f bin\OraGeneric9.Dll (2445584)
f bin\oraldapclnt9.dll (147728)
f bin\oran9.dll (733456)
f bin\orancds9.dll (24848)
f bin\orancrypt9.dll (94480)
f bin\oranhost9.dll (24848)
f bin\oranl9.dll (180496)
f bin\oranldap9.dll (69904)
f bin\oranls9.dll (491792)
f bin\oranms.dll (28944)
f bin\oranmsp.dll (65808)
f bin\orannts9.dll (53520)
f bin\orannzsbb9.dll (561424)
f bin\oranoname9.dll (24848)
f bin\oranro9.dll (221456)
f bin\orantns9.dll (28944)
f bin\OraPls9.Dll (3223824)
f bin\oraslax9.dll (28944)
f bin\orasnls9.dll (65808)
f bin\orasql9.dll (475408)
f bin\ORATRACE9.dll (246032)
f bin\oraunls9.dll (69904)
f bin\oravsn9.dll (24848)
f bin\orawtc9.dll (24848)
f bin\oraxml9.dll (512272)
f bin\oraxsd9.dll (127248)
f bin\ruby.exe (20541)
f bin\rubyw.exe (20542)
f bin\sha2.so (24666)
f bin\socket.so (45143)
f bin\SSLEAY32.dll (200704)
f bin\stringio.so (28763)
f bin\syck.so (122963)
f bin\thread.so (24663)
f bin\Win32API.so (20571)
f bin\zlib.so (45056)
f bin\zlib1.dll (59904)
d lib
d lib\date
f lib\date\format.rb (26717)
f lib\date.rb (52154)
f lib\delegate.rb (8739)
d lib\digest
f lib\digest\sha2.rb (1475)
f lib\digest\sha2.so (24666)
f lib\digest.rb (1145)
f lib\digest.so (24663)
f lib\etc.so (20561)
d lib\ev
f lib\ev\ftools.rb (4338)
f lib\fcntl.so (20565)
f lib\fileutils.rb (43014)
f lib\forwardable.rb (6310)
f lib\ftools.rb (6316)
f lib\iconv.so (24661)
f lib\jcode.rb (4400)
d lib\net
f lib\net\http.rb (65629)
f lib\net\protocol.rb (7810)
f lib\oci8.rb (42853)
f lib\oci8lib.so (61509)
d lib\openssl
f lib\openssl\bn.rb (637)
f lib\openssl\buffering.rb (3791)
f lib\openssl\cipher.rb (1333)
f lib\openssl\digest.rb (1197)
f lib\openssl\ssl.rb (3102)
f lib\openssl\x509.rb (4444)
f lib\openssl.rb (508)
f lib\openssl.so (180313)
f lib\parsedate.rb (1359)
f lib\rational.rb (11847)
d lib\rbconfig
f lib\rbconfig\datadir.rb (637)
f lib\rbconfig.rb (6060)
d lib\rubygems
f lib\rubygems\custom_require.rb (3585)
d lib\rubygems\digest
f lib\rubygems\digest\sha2.rb (356)
f lib\rubygems\gem_openssl.rb (1102)
f lib\rubygems\remote_fetcher.rb (4030)
f lib\rubygems\rubygems_version.rb (133)
f lib\rubygems\security.rb (16910)
f lib\rubygems\source_index.rb (10922)
f lib\rubygems\specification.rb (21814)
f lib\rubygems\user_interaction.rb (6354)
f lib\rubygems\version.rb (8202)
f lib\rubygems.rb (15196)
d lib\rubyscript2exe.gems
d lib\rubyscript2exe.gems\gems
d lib\rubyscript2exe.gems\specifications
f lib\rubyscript2exe.rb (2210)
f lib\socket.so (45143)
f lib\stringio.so (28763)
f lib\syck.so (122963)
f lib\tempfile.rb (4431)
f lib\thread.rb (104)
f lib\thread.so (24663)
f lib\time.rb (32241)
f lib\timeout.rb (2298)
f lib\tmpdir.rb (1041)
f lib\ubygems.rb (268)
d lib\uri
f lib\uri\common.rb (17567)
f lib\uri\ftp.rb (3453)
f lib\uri\generic.rb (24153)
f lib\uri\http.rb (2650)
f lib\uri\https.rb (498)
f lib\uri\ldap.rb (3342)
f lib\uri\mailto.rb (6684)
f lib\uri.rb (694)
f lib\Win32API.so (20571)
d lib\yaml
f lib\yaml\basenode.rb (6129)
f lib\yaml\constants.rb (1186)
f lib\yaml\error.rb (1069)
f lib\yaml\rubytypes.rb (13080)
f lib\yaml\stream.rb (700)
f lib\yaml\syck.rb (271)
f lib\yaml\tag.rb (3156)
f lib\yaml\types.rb (5114)
f lib\yaml\ypath.rb (1328)
f lib\yaml.rb (12525)
f lib\zlib.so (45056)
f bootstrap.rb (2642)
f empty.rb (0)
d app
f app\heti_jelentes.rb (7960)
i eee.info
c %tempdir%\bin\ruby.exe -r %tempdir%\bootstrap.rb -T1 %tempdir%
\empty.rb %tempdir%\app\heti_jelentes.rb
 
K

KUBO Takehiro

Hi,

Hi all!

I tried to pack to an exe a ruby script, which uses oci8.
On my machine it works fine, but when I run it on an other machine I
get the following error:
(I also dumped the files packed by rubyscript2exe)
Can somebody hint what could be the problem?
Do I need any other file to run the program in any other machine? (snip)
f bin\OraClient9.Dll (1536272)
f bin\OraCommon9.Dll (590096)
f bin\ORACORE9.DLL (647440)

It looks like using Oracle full client. Don't copy Oracle full client libraries.
They need to be in the installed location. Otherwise, they won't work.

IMO, it is a case to use Oracle instant client.
 
P

pihentagy

Hi!

Thanks for the answer!

Unfortunately using the instant client causes another error, namely:

D:\temp>D:\temp\heti_jelentes_uj.exe
Starting up
C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/oci8.rb:51:in
`init': OCI Library Initialization Error (OCIError)
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
oci8.rb:51
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
rubygems/custom_require.rb:27:in `gem_original_require'
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
rubygems/custom_require.rb:27:in `require'
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.2\app
\heti_jelentes.rb:2
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.
2\bootstrap.rb:77:in `load'
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.
2\bootstrap.rb:77
 
P

pihentagy

Hi!

Thanks for the answer!

Unfortunately using the instant client causes another error, namely:

D:\temp>D:\temp\heti_jelentes_uj.exe
Starting up
C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/oci8.rb:51:in
`init': OCI Library Initialization Error (OCIError)
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
oci8.rb:51
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
rubygems/custom_require.rb:27:in `gem_original_require'
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
rubygems/custom_require.rb:27:in `require'
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.2\app
\heti_jelentes.rb:2
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.
2\bootstrap.rb:77:in `load'
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.
2\bootstrap.rb:77
 
K

KUBO Takehiro

Hi,

Hi!

Thanks for the answer!

Unfortunately using the instant client causes another error, namely:

D:\temp>D:\temp\heti_jelentes_uj.exe
Starting up
C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/oci8.rb:51:in
`init': OCI Library Initialization Error (OCIError)

OCI.DLL in instant client requires ORAOCIICUS10.DLL (basic lite)
or ORAOCIEI10.DLL(basic). Either of the two dlls needs to be in the
PATH or in the same directory where oci.dll is.
 
P

pihentagy

Hi!

Thanks, for the answer, makes my day :) Now the error I get is not
related to OCI :) So you solved the OCI part, which I was afraid of.
 
P

pihentagy

Sorry. I must be annoying... But another error comes:

D:\temp>heti_jelentes_legujabb.exe
C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/oci8lib.so: 126:
The specified module could not be found. - C:/DOCUME~1/bkozma/eee/
eee.heti_jelentes.exe.2/lib/oci8lib.so (LoadError)
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
rubygems/custom_require.rb:27:in `require'
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
oci8.rb:20
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
rubygems/custom_require.rb:27:in `gem_original_require'
from C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/
rubygems/custom_require.rb:27:in `require'
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.2\app
\heti_jelentes.rb:2
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.
2\bootstrap.rb:77:in `load'
from C:\DOCUME~1\bkozma\eee\eee.heti_jelentes.exe.
2\bootstrap.rb:77


File list was:
d bin
f bin\digest.so (24663)
f bin\etc.so (20561)
f bin\fcntl.so (20565)
f bin\iconv.dll (892928)
f bin\iconv.so (24661)
f bin\LIBEAY32.dll (1077248)
f bin\msvcrt-ruby18.dll (872518)
f bin\OCI.DLL (352256)
f bin\oci8lib.so (61509)
f bin\openssl.so (180313)
f bin\oraociicus10.dll (18194432)
f bin\ruby.exe (20541)
f bin\rubyw.exe (20542)
f bin\sha2.so (24666)
f bin\socket.so (45143)
f bin\SSLEAY32.dll (200704)
f bin\stringio.so (28763)
f bin\syck.so (122963)
f bin\thread.so (24663)
f bin\Win32API.so (20571)
f bin\zlib.so (45056)
f bin\zlib1.dll (59904)
d lib
d lib\date
f lib\date\format.rb (26717)
f lib\date.rb (52154)
f lib\delegate.rb (8739)
d lib\digest
f lib\digest\sha2.rb (1475)
f lib\digest\sha2.so (24666)
f lib\digest.rb (1145)
f lib\digest.so (24663)
f lib\etc.so (20561)
d lib\ev
f lib\ev\ftools.rb (4338)
f lib\fcntl.so (20565)
f lib\fileutils.rb (43014)
f lib\forwardable.rb (6310)
f lib\ftools.rb (6316)
f lib\iconv.so (24661)
f lib\jcode.rb (4400)
d lib\net
f lib\net\http.rb (65629)
f lib\net\protocol.rb (7810)
f lib\oci8.rb (42853)
f lib\oci8lib.so (61509)
d lib\openssl
f lib\openssl\bn.rb (637)
f lib\openssl\buffering.rb (3791)
f lib\openssl\cipher.rb (1333)
f lib\openssl\digest.rb (1197)
f lib\openssl\ssl.rb (3102)
f lib\openssl\x509.rb (4444)
f lib\openssl.rb (508)
f lib\openssl.so (180313)
f lib\parsedate.rb (1359)
f lib\rational.rb (11847)
d lib\rbconfig
f lib\rbconfig\datadir.rb (637)
f lib\rbconfig.rb (6060)
d lib\rubygems
f lib\rubygems\custom_require.rb (3585)
d lib\rubygems\digest
f lib\rubygems\digest\sha2.rb (356)
f lib\rubygems\gem_openssl.rb (1102)
f lib\rubygems\remote_fetcher.rb (4030)
f lib\rubygems\rubygems_version.rb (133)
f lib\rubygems\security.rb (16910)
f lib\rubygems\source_index.rb (10922)
f lib\rubygems\specification.rb (21814)
f lib\rubygems\user_interaction.rb (6354)
f lib\rubygems\version.rb (8202)
f lib\rubygems.rb (15196)
d lib\rubyscript2exe.gems
d lib\rubyscript2exe.gems\gems
d lib\rubyscript2exe.gems\specifications
f lib\rubyscript2exe.rb (2210)
f lib\socket.so (45143)
f lib\stringio.so (28763)
f lib\syck.so (122963)
f lib\tempfile.rb (4431)
f lib\thread.rb (104)
f lib\thread.so (24663)
f lib\time.rb (32241)
f lib\timeout.rb (2298)
f lib\tmpdir.rb (1041)
f lib\ubygems.rb (268)
d lib\uri
f lib\uri\common.rb (17567)
f lib\uri\ftp.rb (3453)
f lib\uri\generic.rb (24153)
f lib\uri\http.rb (2650)
f lib\uri\https.rb (498)
f lib\uri\ldap.rb (3342)
f lib\uri\mailto.rb (6684)
f lib\uri.rb (694)
f lib\Win32API.so (20571)
d lib\yaml
f lib\yaml\basenode.rb (6129)
f lib\yaml\constants.rb (1186)
f lib\yaml\error.rb (1069)
f lib\yaml\rubytypes.rb (13080)
f lib\yaml\stream.rb (700)
f lib\yaml\syck.rb (271)
f lib\yaml\tag.rb (3156)
f lib\yaml\types.rb (5114)
f lib\yaml\ypath.rb (1328)
f lib\yaml.rb (12525)
f lib\zlib.so (45056)
f bootstrap.rb (2642)
f empty.rb (0)
d app
f app\heti_jelentes.rb (8015)
i eee.info
c %tempdir%\bin\ruby.exe -r %tempdir%\bootstrap.rb -T1 %tempdir%
\empty.rb %tempdir%\app\heti_jelentes.rb
 
K

KUBO Takehiro

Hi,

Sorry. I must be annoying... But another error comes:

D:\temp>heti_jelentes_legujabb.exe
C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib/oci8lib.so: 126:
The specified module could not be found. - C:/DOCUME~1/bkozma/eee/
eee.heti_jelentes.exe.2/lib/oci8lib.so (LoadError)

I have some questions.

What OS do you use?
oci.dll depends on msvcr71.dll and psapi.dll.
They may not be on old Windows OS.

Does instant client's sqlplus run on the machine?

Can you run the following command on the machine?
ruby -I C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib -r
oci8lib -e "puts 'OK'"
 
O

Omar Campos

[Note: parts of this message were removed to make it a legal post.]

#unsubscribe
 
P

pihentagy

Hi!

Sorry for the delay. I have some urgent works...
I have some questions.

What OS do you use?
oci.dll depends on msvcr71.dll and psapi.dll.
They may not be on old Windows OS.

Both the developer and the destination machine has Windows XP
Does instant client's sqlplus run on the machine?
Err, haven't tried it. On which machine btw?
Can you run the following command on the machine?
ruby -I C:/DOCUME~1/bkozma/eee/eee.heti_jelentes.exe.2/lib -r
oci8lib -e "puts 'OK'"
On the dev machine, of course, prints ok. But the destination machine
does not have ruby installed of course.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top