Oracle12c Instant Client Config: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== Oracle Instant Client == === Download === See the [http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Instant Client Home Page] for more i...") |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
# instantclient-basic-linux.x64-12.2.0.1.0.zip | # instantclient-basic-linux.x64-12.2.0.1.0.zip | ||
# instantclient-odbc-linux.x64-12.2.0.1.0-2.zip | # instantclient-odbc-linux.x64-12.2.0.1.0-2.zip | ||
# instantclient-sqlplus-linux.x64-12.2.0.1.0.zip | # instantclient-sqlplus-linux.x64-12.2.0.1.0.zip | ||
# instantclient-tools-linux.x64-12.2.0.1.0.zip | # instantclient-tools-linux.x64-12.2.0.1.0.zip | ||
# instantclient-sdk-linux.x64-12.2.0.1.0.zip | |||
=== Upload to Droplet === | === Upload to Droplet === | ||
| Line 26: | Line 26: | ||
ln -s libocci.so.12.1 libocci.so | ln -s libocci.so.12.1 libocci.so | ||
ln -s libclntsh.so.12.1 libclntsh.so | ln -s libclntsh.so.12.1 libclntsh.so | ||
=== Installation libaio === | === Installation libaio === | ||
| Line 33: | Line 32: | ||
ldconfig | ldconfig | ||
=== | === Environment Variable === | ||
# export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2:$LD_LIBRARY_PATH" | # export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2:$LD_LIBRARY_PATH" | ||
export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2" | export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2" | ||
export ORACLE_HOME="/opt/cli/oracle/oracle12c/instantclient_12_2" | export ORACLE_HOME="/opt/cli/oracle/oracle12c/instantclient_12_2" | ||
export PATH="$ORACLE_HOME:$PATH" | export PATH="$ORACLE_HOME:$PATH" | ||
== Network Configuration == | |||
mkdir -p $ORACLE_HOME/network/admin | |||
cd $ORACLE_HOME/network/admin | |||
=== sqlnet.ora === | |||
# $ORACLE_HOME/network/admin/sqlnet.ora | |||
SQLNET.AUTHENTICATION_SERVICES= (NTS) | |||
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME) | |||
=== tnsnames.ora === | |||
# $ORACLE_HOME/network/admin/tnsnames.ora | |||
CKI = | |||
(DESCRIPTION = | |||
(ADDRESS_LIST = | |||
(ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521)) | |||
) | |||
(CONNECT_DATA = | |||
(SERVICE_NAME = CKI) | |||
) | |||
) | |||
CKO = | |||
(DESCRIPTION = | |||
(ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521)) | |||
(CONNECT_DATA = | |||
(SERVER = DEDICATED) | |||
(SERVICE_NAME = CKO) | |||
) | |||
) | |||
EXTPROC_CONNECTION_DATA = | |||
(DESCRIPTION = | |||
(ADDRESS_LIST = | |||
(ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521)) | |||
) | |||
(CONNECT_DATA = | |||
(SERVICE_NAME = PLSExtProc) | |||
) | |||
) | |||
== References == | |||
* [http://www.oracle.com/technetwork/articles/dsl/technote-php-instant-12c-2088811.html Installing PHP and the Oracle Instant Client for Linux] | |||
* [https://www.oracle.com/database/technologies/instant-client/linux-arm-aarch64-downloads.html Oracle Instant Client for Linux ARM] | |||
* [https://github.com/oracle/docker-images/tree/main/OracleLinuxDevelopers Oracle Linux Developer Images] | |||
Latest revision as of 08:35, 27 May 2022
Oracle Instant Client
Download
See the Instant Client Home Page for more information about Instant Client. Find installation instructions here to download following files from Instant Client for Linux x86-64
- instantclient-basic-linux.x64-12.2.0.1.0.zip
- instantclient-odbc-linux.x64-12.2.0.1.0-2.zip
- instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
- instantclient-tools-linux.x64-12.2.0.1.0.zip
- instantclient-sdk-linux.x64-12.2.0.1.0.zip
Upload to Droplet
scp ~/Downloads/instantclient-*.zip dev.chorke.org:/opt/cli/oracle/oracle12c/ ssh dev.chorke.org
Unzip libraries
cd /opt/cli/oracle/oracle12c/ unzip instantclient-basic-linux.x64-12.2.0.1.0.zip unzip instantclient-odbc-linux.x64-12.2.0.1.0-2.zip unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip unzip instantclient-tools-linux.x64-12.2.0.1.0.zip rm -rf instantclient-*.zip
Soft link creation
cd instantclient_12_2/ ln -s libocci.so.12.1 libocci.so ln -s libclntsh.so.12.1 libclntsh.so
Installation libaio
yum install libaio sh -c "echo /opt/cli/oracle/oracle12c/instantclient_12_2 > /etc/ld.so.conf.d/oracle-instantclient.conf" ldconfig
Environment Variable
# export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2:$LD_LIBRARY_PATH" export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2" export ORACLE_HOME="/opt/cli/oracle/oracle12c/instantclient_12_2" export PATH="$ORACLE_HOME:$PATH"
Network Configuration
mkdir -p $ORACLE_HOME/network/admin cd $ORACLE_HOME/network/admin
sqlnet.ora
# $ORACLE_HOME/network/admin/sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
tnsnames.ora
# $ORACLE_HOME/network/admin/tnsnames.ora
CKI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CKI)
)
)
CKO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CKO)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.chorke.org)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)