node.js - Oracle with node-oracle: Error while trying to retrieve text for error ORA-01804 -

i'm trying use node-oracle connect oracle 11g database in unix. can connect fine database using toad, want application queries , did:

nodejs code:

var oracle = require('oracle');  var connectdata = {   hostname: "host.com",   port: 1521,   database: "db0000",   user: "me",   password: "password" }  oracle.connect(connectdata, function(err, connection) {   if (err) { console.log("error connecting db:", err); return; }    connection.execute("select systimestamp dual", [], function(err, results) {     if (err) { console.log("error executing query:", err); return; }      console.log(results);     connection.close();   }); }); 

then command on 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 following error:

terminate called after throwing instance of 'oracle::occi::sqlexception'   what():  error while trying retrieve text error ora-01804 

some notes:

• i haven't set env variables yet, first test, long node command.
• the paths similar described removed prefixes tie company

i've looked around web , lot of people point poorly configured ld_library_path variable. if ls folder get:

acfslib.pm          libclient11.a      libgnsjni11.so     libmm.a        libntcpaio11.so        liboraz.a          libsql11.a          naect_std.o.dbl             sscoreed.o acfsroot.pl         libclntsh.so       libhasgen11.so     libn11.a       libntcps11.a           liborion11.a       libsqlplus.a        naedhs.o                    stubs acfstoolsdriver.sh  libclntsh.so.10.1  libheteroxa11.so   libnbeq11.a    libntcps11_std.a.dbl   libowm2.so         libsqlplus.so       naeet.o                     sysliblist activation.jar      libclntsh.so.11.1  libimf.a           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        nautab.o                    xmlcomp2.jar clntsh.map          libclsra11.so      libipgo.a          libnjni11.so   libnzjs11.a            libplp11.a         libsrvmhas11.so     nautab_std.o.dbl            xmlcomp.jar facility.lis        libcommon11.a      libipp_bz2.a       libnl11.a      libocci11.a            libplp11_pic.a     libsrvmocr11.so     nigcon.o                    xml.jar jcr-1.0.jar         libcore11.a        libippcore.a       libnldap11.a   libocci.so             libpls11.a         libsvml.a           nigtab.o                    xmlmesg.jar jdev-rt.zip         libcorejava.so     libippdcemerged.a  libnls11.a     libocci.so.11.1        libpls11_pic.a     libuini11.so        nnfgt.o                     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          ojcr.jar                    xmlparserv2_sans_jaxp_services.jar ldflags             libeons.so         libippsmerged.a    libnnz11.a     libocrb11.so           libskgxn2.so       libvsn11_std.a.dbl  oraclexsql.jar              xschema.jar ldflagso            libexpat.a         libipp_z.a         libnnz11.so    libocrutl11.so         libskgxp11.so      libwwg.a            osds_acfslib.pm             xsqlserializers.jar libagent11.a        libexpat.la        libirc.a           libnoname11.a  liboevm.a              libskgxpcompat.so  libxdb.so           osds_acfsroot.pm            xsu12.jar libagfw11.so        libexpat.so        libldapclnt11.a    libnque11.so   libons.so              libskgxpd.so       libxml11.a          osds_unix_linux_acfslib.pm libagtsh.so         libexpat.so.1      libldapjclnt11.a   libnro11.a     libonsx.so             libskgxpg.so       libzt11.a           osntabst.o libagtsh.so.1.0     libexpat.so.1.5.2  libldapjclnt11.so  libnsgr11.a    liborabz2.a            libskgxpr.so       libztkg11.a         s0main.o libasmclntsh11.so   libgeneric11.a     liblxled.a         libnsslb11.a   liborasdkbase.so.11.1  libslax11.a        mail.jar            schagent.jar libcell11.so        libgns11.so        liblzopro.a        libntcp11.a    liborasdk.so.11.1      libsnls11.a        naect.o             scorept.o 

any appreciated.

i've looked @ these question, although similar couldn't troubleshoot problem them:

• error while trying retrieve text error ora-01019
• error while trying retrieve text error ora-01804

cheers.

thanks @evenro, went @ error while trying retrieve text error ora-01804 , tried setting oracle_home environment variable.

it worked, started checking variables needed, in end used:

• oracle_home: pointing @ oracle client basedir
• ld_library_path: point @ lib folder inside client

this how worked in 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 again in comments, appreciated.