Configure Oracle Instant Client 21.12 in Ubuntu connect to Oracle Database 21c Express on Windows 10
Configure Oracle Instant Client 21.12 to connect to Oracle Database 21c Express.
01:03 Download Oracle Database Client for Windows
02:03 Check whether glibc library is greater than equal 2.14 if not fix it with description given below
0!:05 Downloading and Configuring Oracle instant client step by step.
04:09 Set environment variable
05:30 Configure tnsnames by adding connection string totnsnames.ora file
06:28 Test the connection to the database
Steps to install glibc
wget http://ftp.gnu.org/gnu/glibc/glibc-2....
tar zxvf glibc-2.14.tar.gz
sudo mkdir ~/glibc_install
cd ~/glibc_install
cd glibc-2.14
mkdir build
cd build
../configure --prefix=/opt/glibc-2.14
make -j4
sudo make install
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/glibc-2.14/lib
TNSNAMES.ORA connection string format
service name will be used by oracle client =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress or hostname)(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME=database service name)
)
)
Some important software download links related to this video
Oracle Database Express Edition - https://www.oracle.com/in/database/te...
https://www.oracle.com/in/database/te...
Oracle Database Express Edition for Windows -
https://download.oracle.com/otn-pub/o...
