1, install Oracle-instantclient: (default installation can be)
oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-devel-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
2, the configuration environment variable, modifies the/etc/profile, the file finally joins the following content:
Export Oracle_home=/usr/lib/oracle/12.1/client64
Export Ld_library_path=/usr/lib/oracle/12.1/client64/lib
Export path= $ORACLE _home/bin: $PATH
3, Configuration Monitoring
[Email protected] admin]# pwd
/usr/lib/oracle/12.1/client64/network/admin
[[email protected] admin]# ls----------These two files need to be created manually or copied from the server, then modify the parameters.
Listener.ora Tnsnames.ora
==============================
Listener.ora:
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.111) (PORT = 1521))
)
)
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Global_dbname = ORCL)
(Oracle_home =/usr/lib/oracle/12.1/client64)
(Sid_name = ORCL)
)
)
Adr_base_listener =/usr/lib/oracle/12.1/client64/network/admin
===================================
Tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.111) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)
4. Connect to Oracle Database
[Email protected] admin]# Sqlplus/nolog;
Sql*plus:release 12.1.0.1.0 Production on Sun Sep 28 15:08:03 2014
Copyright (c) 1982, Oracle. All rights reserved.
sql> Conn [email protected];
Enter Password:
Connected.
Sql>
Install oracle12.1 client separately under Linux