Page Contents

loopback-connector-oracle

The Oracle Connector module for for loopback-datasource-juggler.

For full documentation, see the official Documentation.

NOTE: This connector is compatible with Node v.0.10.x, v.12.x, and iojs v1.6.2.

Installation

To simplify the installation of node-oracledb module and Oracle instant clients, we introduce loopback-oracle-installer as a dependency which installs and configures node-oracledb (oracledb) upon npm install.

Please note config.oracleUrl is the property to define the base URL to download the corresponding node-oracle (oracledb) bundle for the local environment.

The bundle file name is loopback-oracle-<platform>-<arch>-<version>.tar.gz. The version is the same as the version in package.json.

"dependencies": {
    "loopback-oracle-installer": "git+ssh://[email protected]:strongloop/loopback-oracle-installer.git",
         ...
},
"config": {
    "oracleUrl": "http://7e9918db41dd01dbf98e-ec15952f71452bc0809d79c86f5751b6.r22.cf1.rackcdn.com"
},

The oracleUrl can be overridden via LOOPBACK_ORACLE_URL environment variable.

For example, the full URL for v1.5.0 for MacOSX is:

http://7e9918db41dd01dbf98e-ec15952f71452bc0809d79c86f5751b6.r22.cf1.rackcdn.com/loopback-oracle-MacOSX-x64-1.5.0.tar.gz

libaio library is required on Linux systems:

  • On Ubuntu/Debian

      sudo apt-get install libaio1
    
  • On Fedora/CentOS/RHEL

      sudo yum install libaio
    

Please make sure c:\instantclient_12_1\vc10 comes before c:\instantclient_12_1

Examples

  • example/app.js: Demonstrate the asynchronous discovery
  • example/app-sync.js: Demonstrate the synchronous discovery

Running tests

The tests in this repository are mainly integration tests, meaning you will need to run them using our preconfigured test server.

  1. Ask a core developer for instructions on how to set up test server credentials on your machine
  2. npm test

Troubleshooting

ORA-24408

Error: ORA-24408: could not generate unique server group name

The Oracle 11g client requires an entry with your hostname pointing to 127.0.0.1.

###1. Get your hostname

Check your hostname by running:

$ hostname
earth # assuming your machine's name is `earth`

###2. Update /etc/hosts

Map 127.0.0.1 to your hostname in/etc/hosts:

...
127.0.0.1 localhost earth # change `earth` to match your hostname
...

###3. Verify the fix

Run the example in examples/app.js:

$ node examples/app.js

References

  • http://stackoverflow.com/questions/10484231/ora-24408-could-not-generate-unique-server-group-name