Package Exports

loopback-connector-oracle

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (loopback-connector-oracle) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

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://git@github.com: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.

Ask a core developer for instructions on how to set up test server credentials on your machine
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