oracle11g - Unable to connect to Oracle 11g using node-oracle driver for Node.js: are they compatible? -


we trying use node.js app connect oracle 11g server (enterprise edition 11.2.0.1.0 - 64bit production) ubuntu 12.04.1 lts server. running node v0.10.12 , nearinfinity node-oracle module 0.3.1. there other posts here on stackoverflow talk other node oracle module node-db-oracle, version no longer maintained , cannot built node 0.10.12 due node-waf being deprecated.

even tiniest node program not connect though using same connection info can connect sqlplus64 client , simple 3 line php program. have tried different options connecting, such specifying connection info in json passed connect function, specifying user, password, , referencing connection string in oracle tnsnames.ora file, or passing connection string directly json. 1 of 2 errors:

error: ora-12154: tns:could not resolve connect identifier specified

or if change parameters bit:

error: ora-12514: tns:listener not know of service requested in connect descriptor

i have tried connecting different oracle servers in our datacenter: 1 single server using sid=databasename convention , rac system using service_name=database_servicename convention. same story both cases.

i have looked @ other node.js/oracle posts here , have tried speak of. firing sqlplus64 username/password@sid_name connects immediately. beginning conclude combination of versions using not work together. ideas?

the solution use recent patch module hasn't been released yet. current release 0.3.1 of node-oracle. version not have tns support fix. if check out latest code module github new directory , build there ('npm link' in directory) , npm link oracle project directory new version fix. had work through number of permission problem platform specific won't delve here. have requested authors of module release patched version presumable 0.3.2.


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -