Configure Oracle Database Client remote connection database server under Mac

Download Mac Database client:

Address: http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html

Download these two: (Source: http://www.cnblogs.com/xiaobo-Linux/p/7821402.html)

12.12.0.1.0 version of:

Unzip Instantclient package to CD ~

Create a directory Lib and then make a file connection:

  mkdir ~/lib  ln-s ~/instantclient_12_2/libclntsh.dylib ~/lib/  ln-s ~/instantclient_12_2/ libclntsh.dylib.12.1 ~/lib/

Do a listening: Tnsnames.ora file

If you intend to co-locate optional the Oracle configuration files such as tnsnames.ora ,, sqlnet.ora or with ldap.ora oraaccess.xml Instant Client, Then create a network/admin subdirectory. For example:

  Mkdir-p ~/instantclient_12_2/network/admin

Vim Tnsnames.ora

Below, configure IP address, IP address is server address, port default 1521;

Oralocal =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = 10.211.55.14) (PORT = 1521))

(Connect_data = (SERVER = dedicated) (service_name = ORCL)))

Connecting Windows oraclez11g

You can look at the IP address:

You need to close the firewall when you connect, or configure the port to allow connections.

Configure the Environment variables:

~ Vim. Profile

Append the following:

Orcl_library_path= "Instantclient_12_2"

Export Orcl_library_path

Export Oracle_home= $ORCL _library_path

Export path= $ORACLE _home: $PATH

Take effect:

~ Source. Profile

Login:

~ Sqlplus Sys/[email PROTECTED]:1521/ORCL as Sysdba

Configure Oracle Database Client remote connection database server under Mac