Oracle12c Instant Client Config: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 38: | Line 38: | ||
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 == | |||
=== 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) | |||
) | |||
) | |||
Revision as of 11:06, 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 mkdir -p /opt/cli/oracle/oracle12c/instantclient_12_2/network/admin
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
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)
)
)