Install document of DBD::Oracle on Debian 12

perl-oracle-install-debian-12.sh

#!/bin/bash
## Install DBD::Oracle on Debian 12
## DBD::Oracle on Debian 12
## Link on http://www.oracle.com/technetwork/topics/linuxsoft-082809.html
## https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
## https://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/index.html
## 2024/04/18, version *19.23.0.0.0-1*


## Install require package
## for Oracle instant-client
apt update
apt-get -y install cpanminus libaio-dev alien build-essential wget curl
## Download oracle-instant-client-{basic,devel,sqlplus}

cat <<EOF >> ~/.bashrc
export PERL_CPANM_OPT="-l $HOME/.perl"
EOF

URL=https://download.oracle.com/otn_software/linux/instantclient/1923000
ENV_VER=19.23
APP=oracle-instantclient19.23
VERSION=19.23.0.0.0-1.x86_64
wget ${URL}/${APP}-{basic,sqlplus,devel}-${VERSION}.rpm


## make deb file
alien ${APP}-{basic,sqlplus,devel}-${VERSION}.rpm

# oracle-instantclient-{basic,sqlplus,devel}-*.x86_64.rpm
# oracle-instantclient*-basic_*_amd64.deb 
# oracle-instantclient*-devel_*_amd64.deb 
# oracle-instantclient*-sqlplus_*_amd64.deb

## Install oracle instant-client
dpkg -i ${APP}-{basic,sqlplus,devel}_*_amd64.deb

cat <<EOF >> ~/.bashrc
export ORACLE_HOME=/usr/lib/oracle/$ENV_VER/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
EOF

## Install Perl Module
cpanm RPC::EPC::Service DBI DBD::Oracle