0

I installed node-oracle with these instructions: https://github.com/oracle/node-oracledb

However, I've been beating my head against the wall trying to connect to a remote oracle database. So I'm tapping into the community to help me out. I have created different *.ora files (ldap.ora, sql.ora TNS etc...) and set my TNS_ADMIN directory to where those files reside. The bottom line is that I have this connection string:

jdbc:oracle:thin:@ldap://{hostName-1}:{portNumber}/{dbname},cn=OracleContext,dc=world ldap://{hostName-2}:{portNumber}/{dbname},cn=OracleContext,dc=world

I can access the database just fine using Oracle SQL Developer. However I've had no sucess using SQLPlus or Node.

I've already checked these (among many others):

https://community.oracle.com/thread/3759037

How do you connect to an LDAP server using node-oracledb?

Getting error while connecting to oracle

ORA-12560: TNS:protocol adaptor error

Has anyone figured this out yet and can post a solution with the following:

  1. your jdbc connection string
  2. your sample *.ora files or whatever parameter you're passing to oracledb.getConnection() from node?

Thanks,

MT0
  • 143,790
  • 11
  • 59
  • 117
dalcantara
  • 1,613
  • 2
  • 21
  • 35
  • It might help to give the connection strings you tried in SQL*Plus and the errors you have seen. – Christopher Jones Nov 10 '16 at 11:52
  • Here's what's in my sqlnet.ora which (AFIK) means to first connect by ldap, then EZ then tns: NAMES.DIRECTORY_PATH=(LDAP, EZCONNECT, TNSNAMES) The connection strings I've tried in SQLPlus are: sqlplus "/@:/" sqlplus ""/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=)(Port=))(CONNECT_DATA=(SID=)))" both of this attempts gave me this error: ORA-12569: TNS:packet checksum failure I'm going to search on this now. – dalcantara Nov 11 '16 at 15:35

0 Answers0