Closed
Description
FSADT1-290 Connect to oracle db using nestjs backend framework
FSADT1-288 Check how to auto install required oracle tools in docker container
An example of oracle connection with nestjs
Install instruction for node-oracledb, it lists detail instruction for Windows and Linux and Mac
Installation:
- Install oracledb
npm i oracledb
For Mac users:
- Install the free Oracle Instant Client ‘Basic’ package:
cd $HOME/Downloads
curl -O https://download.oracle.com/otn_software/mac/instantclient/198000/instantclient-basic-macos.x64-19.8.0.0.0dbru.dmg
hdiutil mount instantclient-basic-macos.x64-19.8.0.0.0dbru.dmg
/Volumes/instantclient-basic-macos.x64-19.8.0.0.0dbru/install_ic.sh
hdiutil unmount /Volumes/instantclient-basic-macos.x64-19.8.0.0.0dbru - Create a symbolic link for the ‘client shared library’ in /usr/local/lib:
ln -s ~/Downloads/instantclient_19_8/libclntsh.dylib /usr/local/lib
For Windows users:
- Install the free Oracle Instant Client ‘Basic’ package:
https://download.oracle.com/otn_software/nt/instantclient/216000/instantclient-basic-windows.x64-21.6.0.0.0dbru.zip - Unzip the package (it is suggested to unzip it within the main drive, i.e. c:)
- Create an System variable in the environment variables for the ORACLE_HOME
- Add this variable in the PATH
Installation for Docker container: follow the instruction using option 2, our Docker file is here
Metadata
Assignees
Labels
No labels