Install and configure the Oracle instance Client

Environment Description:

The oracle11gr2 database is installed on the Virtual Machine (centos5.5 64bit). The database name is orcl and the user is test. Virtual Machine IP Address
192.168.128.101

No database is installed on the Physical Machine (64-bit in Windows 7). The physical machine can ping the virtual machine, and PL/SQL has been installed.
Developer 9.0 (32bit)

Medium: instantclient-basic-win32-11.2.0.1.0.zip.

Objectives:

PL/SQL connects to the database orcl on the virtual machine through the instance Client

 

 

Implementation steps:

Decompress the instance client to disk D and go to its main directory to create the Directory D: \ instantclient_11_2 \ Network \ admin \ tnsnames. ora and files.

Tnsnames. enter the content of the ora file as tnsnames obtained from Oracle Data. ora file (this file is placed in $ oracle_hoem \ Network \ ADMIN). You need to change the host name to the IP address of the host.

Tnsname content example:

Orcl =

(Description =

(Address = (Protocol = TCP) (host = 192.168.128.101) (Port = 1521 ))

(CONNECT_DATA =

(Server = dedicated)

(SERVICE_NAME = orcl.101)

)

)

Do not log on to start PLSQL, and fill in the content in the tool's preference connection.

Save the changes and exit.

To ensure that the database and listener on the virtual machine are enabled, You can restart PLSQL.