Here's a demo showing the connection syntax for node-oracledb in various proxy and external authentication connection scenarios. The script mentions Oracle 12.2...
Here's a demo showing the connection syntax for node-oracledb in various proxy and external authentication connection scenarios. The script mentions Oracle 12.2 because that is what I was testing way back at the time I wrote the script. I was also checking an enhancement in 18.3. You may find that most syntaxes are usable with earlier Oracle versions. We also tweaked some behavior in node-oracleb 3.1, so if you have an older version you will see differences in cases 4 and 14,...
Here's a demo showing the connection syntax for node-oracledb in various proxy and external authentication connection scenarios. The script mentions Oracle 12.2 because that is what I was testing...
Instant Client 19.8 for macOS is now available on OTN. This release introduces notarized DMG packages, making installation on recent macOS versions smoother:...
Instant Client 19.8 for macOS is now available on OTN. This release introduces notarized DMG packages, making installation on recent macOS versions smoother: there is no need for manual approval of the shared libraries or running xattr commands. The ZIP files are still available, but I'm told that in some future version only DMGs will be released. Oracle Instant Client gives free, light-weight, and easily installed Oracle Database tools, libraries and SDKs. Update: Instant...
Instant Client 19.8 for macOS is now available on OTN. This release introduces notarized DMG packages, making installation on recent macOS versions smoother: there is no need for manual approval...
To connect your applications to an Oracle Autonomous Cloud Database - any of the Oracle Autonomous Database services like Autonomous Data Warehouse (ADW),...
To connect your applications to an Oracle Autonomous Cloud Database - any of the Oracle Autonomous Database services like Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), or the new Oracle Autonomous JSON Database (AJD) - then you will need to download and use a 'wallet'. This gives mutual TLS which provides enhanced security for authentication and encryption. This post shows how to download a wallet and use it to connect to your Autonomous database...
To connect your applications to an Oracle Autonomous Cloud Database - any of the Oracle Autonomous Database services like Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP),...
After installing the Node.js node-oracledb module, beginner users will often see a DPI-1047 error when running their first script. For example on macOS: $ node...
After installing the Node.js node-oracledb module, beginner users will often see a DPI-1047 error when running their first script. For example on macOS: $ node example.js Error: DPI-1047: Cannot locate a 64-bit Oracle Client library: "dlopen(libclntsh.dylib, 1): image not found". See https://oracle.github.io/node-oracledb/INSTALL.html for help Node-oracledb installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html This wouldn't happen if the installation...
After installing the Node.js node-oracledb module, beginner users will often see a DPI-1047 error when running their first script. For example on macOS: $ node example.js Error: DPI-1047:...
This is the second in a two part series on using Docker for Oracle Database applications. Part 1: Installing Docker and Creating Images with the Oracle Client...
This is the second in a two part series on using Docker for Oracle Database applications. Part 1: Installing Docker and Creating Images with the Oracle Client Part 2: Creating Docker Containers that Connect to Oracle Database The examples are for Node.js and Python, but the concepts are also useful for the many other languages whose database APIs are implemented on top of Oracle Call Interface; these other languages include C, PHP, Go, Ruby, Rust, Erlang, Julia, Nim, and...
This is the second in a two part series on using Docker for Oracle Database applications. Part 1: Installing Docker and Creating Images with the Oracle Client Part 2: Creating Docker Containers that...
Welcome to this two part series on using Docker for Oracle Database applications. Part 1: Installing Docker and Creating Images with the Oracle Client Part 2:...
Welcome to this two part series on using Docker for Oracle Database applications. Part 1: Installing Docker and Creating Images with the Oracle Client Part 2: Creating Docker containers that connect to Oracle Database The examples are for Node.js and Python, but the concepts are also useful for the many other languages whose database APIs are implemented on top of Oracle Call Interface; these other languages include C, PHP, Go, Ruby, Rust, Erlang, Julia, Nim, and Haskell....
Welcome to this two part series on using Docker for Oracle Database applications. Part 1: Installing Docker and Creating Images with the Oracle Client Part 2: Creating Docker containers that...
Permanent URLs that download the latest Oracle Instant Client packages are now live on OTN. Instant Client packages give you free, light-weight, and easily...
Permanent URLs that download the latest Oracle Instant Client packages are now live on OTN. Instant Client packages give you free, light-weight, and easily installed Oracle Database tools, libraries and SDKs. You can find the URLs at the top of each platform download page (e.g. the Linux x64 page). For quick reference, here are package links for the three top platforms: Package Windows x64 Linux x64 macOS Basic zip zip, RPM zip Basic Light zip zip, RPM zip SQL*Plus zip zip,...
Permanent URLs that download the latest Oracle Instant Client packages are now live on OTN. Instant Client packages give you free, light-weight, and easily installed Oracle Database tools, libraries...
Stop the presses! Downloads of Oracle Instant Client 19.3 packages for Linux and Windows no longer require login or a click-through. You can now automate...
Stop the presses! Downloads of Oracle Instant Client 19.3 packages for Linux and Windows no longer require login or a click-through. You can now automate downloads using your favorite tool such as wget or curl. URLs can be found on the platform pages: Windows x64 64-bit Windows 32-bit Linux x86-64 64-bit Linux x86 32-bit Update: 19c package for these platforms are now also accessible without click-through: Solaris SPARC 64-bit Solaris SPARC 32-bit Linux on Power Little Endian...
Stop the presses! Downloads of Oracle Instant Client 19.3 packages for Linux and Windows no longer require login or a click-through. You can now automate downloads using your favorite tool such...
Things change fast and it's time for an update on running Node.js in Docker. Let's dive right in. Here's a Dockerfile that pulls the lightweight Oracle Linux...
Things change fast and it's time for an update on running Node.js in Docker. Let's dive right in. Here's a Dockerfile that pulls the lightweight Oracle Linux "slim" image, installs the latest Node.js runtime, and installs the Oracle Client libraries needed for the node-oracledb module. Note no Docker store login or manual downloads are required: FROM oraclelinux:7-slim RUN yum -y install oracle-release-el7 oracle-nodejs-release-el7 && \ yum-config-manager --disable...
Things change fast and it's time for an update on running Node.js in Docker. Let's dive right in. Here's a Dockerfile that pulls the lightweight Oracle Linux "slim" image, installs the latest...
