node.js - Oracle with node-oracle: Error while trying to retrieve text for error ORA-01804 - Stack Overflow
Join Stack Overflow to learn, share knowledge, and build your career.
or sign in with
I'm trying to use
to connect to a Oracle 11g database in UNIX. I can connect fine to the database using TOAD, but now I want to do application queries and this is what I did:
NodeJS code:
var oracle = require('oracle');
var connectData = {
hostname: "",
port: 1521,
database: "DB0000",
user: "me",
password: "password"
oracle.connect(connectData, function(err, connection) {
if (err) { console.log("Error connecting to db:", err); }
connection.execute("SELECT systimestamp FROM dual", [], function(err, results) {
if (err) { console.log("Error executing query:", err); }
console.log(results);
connection.close();
Then I this command on the unix box:
sh-3.2$ OCI_LIB_DIR= /oracle/client/v11.2.0.2-64bit/client_1/lib/ OCI_INCLUDE_DIR=/client/v11.2.0.2-64bit/client_1/rdbms/public/ OCI_HOME=/oracle/clien
t/v11.2.0.2-64bit/client_1/ NLS_LANG=.UTF8 LD_LIBRARY_PATH=/client/v11.2.0.2-64bit/client_1/lib/ /bin/node app.js
I get the following error:
terminate called after throwing an instance of 'oracle::occi::SQLException'
Error while trying to retrieve text for error ORA-01804
Some notes:
I haven't set up env variables properly yet, this was my first test, thus the long node command.
the paths are similar to those described but I removed the prefixes which would tie this to my company
I've looked around the web and a lot of people point this to a poorly configured LD_LIBRARY_PATH variable. If I ls that folder I get:
acfslib.pm
libclient11.a
libgnsjni11.so
libntcpaio11.so
libsql11.a
naect_std.o.dbl
sscoreed.o
acfsroot.pl
libclntsh.so
libhasgen11.so
libntcps11.a
liborion11.a
libsqlplus.a
acfstoolsdriver.sh
libclntsh.so.10.1
libheteroxa11.so
libnbeq11.a
libntcps11_std.a.dbl
libowm2.so
libsqlplus.so
sysliblist
activation.jar
libclntsh.so.11.1
libncrypt11.a
libntns11.a
libplc11.a
libsqora.so.11.1
naeet_std.o.dbl
transx.zip
classgen.jar
libclntst11.a
libintlc.so.5
libnhost11.a
libnus11.a
libplc11_pic.a
libsrvm11.so
xmlcomp2.jar
clntsh.map
libclsra11.so
libnjni11.so
libnzjs11.a
libplp11.a
libsrvmhas11.so
nautab_std.o.dbl
xmlcomp.jar
facility.lis
libcommon11.a
libipp_bz2.a
libocci11.a
libplp11_pic.a
libsrvmocr11.so
jcr-1.0.jar
libcore11.a
libippcore.a
libnldap11.a
libocci.so
libpls11.a
xmlmesg.jar
jdev-rt.zip
libcorejava.so
libippdcemerged.a
libnls11.a
libocci.so.11.1
libpls11_pic.a
libuini11.so
xmlparserv2.jar
lclasses12.zip
libcxaguard.so.5
libippdcmerged.a
libnnet11.a
libocijdbc11.so
libpsa11.a
libunls11.a
ntcontab.o
xmlparserv2_jaxp_services.jar
lclasses14.zip
libdbcfg11.so
libippsemerged.a
libnnetd11.a
libocr11.so
librdjni11.so
libvsn11.a
xmlparserv2_sans_jaxp_services.jar
libeons.so
libippsmerged.a
libnnz11.a
libocrb11.so
libskgxn2.so
libvsn11_std.a.dbl
oraclexsql.jar
xschema.jar
libexpat.a
libipp_z.a
libnnz11.so
libocrutl11.so
libskgxp11.so
osds_acfslib.pm
xsqlserializers.jar
libagent11.a
libexpat.la
libnoname11.a
libskgxpcompat.so
osds_acfsroot.pm
libagfw11.so
libexpat.so
libldapclnt11.a
libnque11.so
libskgxpd.so
libxml11.a
osds_unix_linux_acfslib.pm
libagtsh.so
libexpat.so.1
libldapjclnt11.a
libnro11.a
libonsx.so
libskgxpg.so
osntabst.o
libagtsh.so.1.0
libexpat.so.1.5.2
libldapjclnt11.so
libnsgr11.a
liborabz2.a
libskgxpr.so
libztkg11.a
libasmclntsh11.so
libgeneric11.a
liblxled.a
libnsslb11.a
liborasdkbase.so.11.1
libslax11.a
schagent.jar
libcell11.so
libgns11.so
liblzopro.a
libntcp11.a
liborasdk.so.11.1
libsnls11.a
Any help would be greatly appreciated.
I've looked at these question, but although similar I couldn't troubleshoot my problem with them:
3,58532340
Thanks to @evenro, I went back to look at
and tried setting the ORACLE_HOME environment variable.
It worked, but then I started checking which variables I really needed, so in the end I only used:
ORACLE_HOME: pointing at the oracle client basedir
LD_LIBRARY_PATH: point at the lib folder inside the client
This is how it worked in the end:
ORACLE_HOME=/somefolder/oracle/client/v11.2.0.2-64bit/client_1/ LD_LIBRARY_PATH=/somefolder/oracle/client/v11.2.0.2-64bit/client_1/lib/ node app.js
Thank you again for all the help in the comments, much appreciated.
3,58532340
In my case I solved it like this for python
I solved this by simply zipping the files properly with the symbolic links
First I created three symbolic links :
ln -s ./lib/libaio.so.1.0.1 ./lib/libaio.so.1
ln -s ./lib/libaio.so.1.0.1 ./lib/libaio.so
ln -s ./lib/libaio.so.1.0.1 ./libaio.so.1.0.1
ln -s ./lib/libclntsh.so.12.1 ./lib/libclntsh.so
then I was zipping it incorrectly I did it like this:
zip --symlinks -r9 ~/lamda.zip *
It worked! properly then.Hope it helps somebody.
Your Answer
Sign up or
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Post as a guest
By posting your answer, you agree to the
Not the answer you're looking for?
Browse other questions tagged
The week's top questions and answers
Important community announcements
Questions that need answers
By subscribing, you agree to the
Stack Overflow works best with JavaScript enabled相关文章推荐
使用Universal USB Installer创建安装Linux U盘系统详细步骤。
Universal-USB-Installer这个工具是用来制作U盘启动盘的，下面以制作Ubuntu版本Linux系统的U盘启动盘为例，方法如下：
1、安装Universal USB Install...
1、Oracle 支持在具有 DHCP 分配的 IP 地址的系统上进行安装检查完成。此次检查的总体结果为: 未执行 建议案: Oracle 支持在具有 DHCP 分配的 IP 地址的系统上进行安装。但...
在OEL 5.8上安装oracle clusterware 10.2.0.1 在最后一个node上执行root..sh的时候会出现以下问题：
Oracle CRS stack installed a...
出现错误：
Checking operating system package requirements ...
Check complete. The overall result of thi...
补充：ubuntu官方提供了一个用于在u盘中安装可读写的ubuntu系统的程序：Startup Disk Creator 。 ========关于persistence的问题： 1）What is ...
Ubuntu 11.04 正式版发布了,相信很多朋友一定对Ubuntu 的新界面跃跃欲试吧?不妨安装一下尝尝鲜。老饕介绍过硬盘安装Ubuntu双系统，这当然是一个非常好的方法：刻光盘不用了，直接在硬盘...
操作系统：OracleLinux 6.1 32位数据库： Oracle11.2.0.3
因为Oracle 11g以后的Patchset 可以直接用来安装，所以我也是直接安装成11.2.0.3， 这样...
在安装oracle10g数据库时出现错误oui-25031，一些configuration assistant失败，也就是说安装oracle数据库失败。会出现如下图
他的最新文章
他的热门文章
您举报文章：
举报原因：
原文地址：
原因补充：
(最多只允许输入30个字)相关文章推荐
型号：IBM System x43I20）
硬件要求：
CPU： 4个Intel 8核E7-4820 Xeon处理器
内存：16G * 16
电源：2个热插...
历尽种种磨难，终于把工作用的32位oracle 10g 装到64 位 windows7上了。不要问我为什么不装64位oracle或者 oracle 11g，工作需要，这是唯一理由。
遇到的种种问题，...
昨天，在部署一个测试环境的时候遇到一个报错。
windows server 2008 x86 sp2 + oracle10g(10.2.0.4)
操作系统安装很easy。PS:以前都是在服务器上安...
转自：/jizizeng/item/4df954c30b0d3d29ef4665da
因开发环境需要，在Windows Server 2008 R2 E...
一、背景交代
客户刚刚到的一台新服务器，型号为：IBM X3850，自带的操作系统为：Windows Server ；需要安装版本为10.2.0.4版本的Oracle数据库。
...
windows server 2008安装Oracle 11g r2先决条件检查失败，提示oracle 交换空间不足的解决方法...
Windows server 2008 R2 安装 Oracle 11g R2 dataguard过程有点复杂，尽量明白各个步骤的意义，认真，耐心一定可以配置成功。...
他的最新文章
他的热门文章
您举报文章：
举报原因：
原文地址：
原因补充：
(最多只允许输入30个字)ORA-00923: FROM keyword not found where expected tips
��
Burleson is the American Team
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.&
Feel free to ask questions on our
experience!
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
&Oracle technology is changing and we
strive to update our BC Oracle support information.& If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback.& Just&
and include the URL for the page.
&&&&&&&&&&&&&&&&&&&&
Burleson Consulting
The Oracle of
Database Support
Copyright & 1996 -& 2017
All rights reserved by
is the registered trademark of Oracle Corporation.
Remote Emergency Support provided by}