DB Wiki

User Tools

Site Tools

Trace: • instantclient
instantclient

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
instantclient [2025/03/27 15:50] – z0hpvkinstantclient [2025/06/03 08:11] (current) – z0hpvk
Line 2: Line 2:
 ==== Installation ==== ==== Installation ====
  
-<code bash>+<code>
 sudo apt install -y libaio1 sudo apt install -y libaio1
 mkdir oracle && cd "$_" mkdir oracle && cd "$_"
Line 8: Line 8:
 wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-basic-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-basic-linux.x64-23.7.0.25.01.zip
 wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sqlplus-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sqlplus-linux.x64-23.7.0.25.01.zip
 +wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sdk-linux.x64-23.7.0.25.01.zip
 +wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-jdbc-linux.x64-23.7.0.25.01.zip
  
-unzip instantclient-basic-linux.x64-23.7.0.25.01.zip +unzip instantclient*linux.x64-23.7.0.25.01.zip
-unzip instantclient-sqlplus-linux.x64-23.7.0.25.01.zip+
  
 export LD_LIBRARY_PATH=$PWD/instantclient_23_7:$LD_LIBRARY_PATH export LD_LIBRARY_PATH=$PWD/instantclient_23_7:$LD_LIBRARY_PATH
 export PATH=$PWD/instantclient_23_7:$PATH export PATH=$PWD/instantclient_23_7:$PATH
 +</code>
 +
 +Newer versions of Ubuntu no longer have the libaio1 package.\\
 +Instead it is called libaio1t64. Install this package and create a symbolic link.
 +
 +<code>
 +sudo apt install -y libaio1t64
 +sudo ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/x86_64-linux-gnu/libaio.so.1
 </code> </code>
  
Line 19: Line 28:
 === With Password === === With Password ===
  
-<code bash>sqlplus user/password@host:port/db_service_name</code>+<code>sqlplus user/password@host:port/db_service_name</code>
 The port number does not need to be specified if it is 1521\\ The port number does not need to be specified if it is 1521\\
  
Line 26: Line 35:
 In this case you need to quote your connect string and escape the quotes with backslashes.\\ In this case you need to quote your connect string and escape the quotes with backslashes.\\
  
-<code bash>sqlplus user@\"host:port/db_service_name\"</code>+<code>sqlplus user@\"host:port/db_service_name\"</code> 
 + 
 +==== Oracle Sample Schemas ==== 
 +<code> 
 +wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-tools-linux.x64-23.7.0.25.01.zip 
 +perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat 
 +</code>
instantclient.1743090635.txt.gz · Last modified: 2025/03/27 15:50 by z0hpvk