Oracle12c Instant Client Config: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| 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 40: | Line 39: | ||
== Network Configuration == | == Network Configuration == | ||
mkdir -p $ORACLE_HOME/network/admin | |||
cd $ORACLE_HOME/network/admin | |||
=== sqlnet.ora === | === sqlnet.ora === | ||
# $ORACLE_HOME/network/admin/sqlnet.ora | # $ORACLE_HOME/network/admin/sqlnet.ora | ||
Revision as of 11:34, 13 December 2017
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)
)
)