Oracle FDW to AgensGraph 1 to 3

1. install

• Oracle DB
• AgensGraph (prepare installed)

• laurenz/oracle_fdw

• If Oracle is installed Remote OS, in AgensGraph Server i is installing instantclient-sdk(and basic).

1-1. Oracle install (In a AgensGraph Docker Server)

• Download oracle https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
  • I used Oracle11g (if you installed oracle, pass the oracle install step.)

• I was installed Oracle Server(Remote). How to install Oracle, Search and exercise.

• Oracle instantclient-basic, sdk install (for Oracle FDW install)
  • instantclient-basic-linux.x64-12.2.0.1.0.zip
  • instantclient-sdk-linux.x64-12.2.0.1.0.zip

link : https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

• unzip zip files

unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip

• symbolic link setting
• In instantclient_12_2 directory, libclntsh.so.12.1 file exists. libclntsh.so.12.1 -> libclntsh.so symbolic link

ln -s libclntsh.so.12.1 libclntsh.so

1-2. OracleFDW download

• laurenz oracle_fdw git clone

git clone https://github.com/laurenz/oracle_fdw.git

• environment variables setting vi editor : $HOME/.bashrc or $HOME/.bash_profile

  export ORACLE_HOME=$HOME/instantclient_12_2
  export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
  export PATH=$ORACLE_HOME:$PATH
  

  source ~/.bashrc

1-3. OracleFDW compile

• make and make install

make && make install

• If you failed MAKE and MAKE INSTALL,

• case 1 : OS package as build library not be installed.
• case 2 : after console ‘make clean’, re-make
• case 3 : log message reading.

2. AgensGraph oracle_fdw extension

• After AgensGraph ‘restarting server : ag_ctl restart’, CREATE EXTENSION oracle_fdw

CREATE EXTENSION oracle_fdw;