Differences

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

--- instantclient [2025/03/27 15:48] – z0hpvk
+++ instantclient [2025/06/03 08:11] (current) – z0hpvk
@@ Line 2: / Line 2: @@
 ==== Installation ====
-<code shell>
+<code>
 sudo apt install -y libaio1
 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-sqlplus-linux.x64-23.7.0.25.01.zip
-unzip instantclient-basic-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
-unzip instantclient-sqlplus-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*linux.x64-23.7.0.25.01.zip
 export LD_LIBRARY_PATH=$PWD/instantclient_23_7:$LD_LIBRARY_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>
@@ Line 26: / Line 36: @@
 <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>