Connect to oracle using plsql without installing the oracle client

Connect to oracle using plsql without installing the oracle client
1.1. Download the Instant Client

Official Website:

Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html

Download the instantclient-basic Package and decompress it to the local device. In this test, the package is D: \ JavaEEServer \ instantclient_10_2.

1.2. Configure sqlnet. ora

Sqlnet. ora (located in instantclient-basic)

SQLNET. AUTHENTICATION_SERVICES = (CNT) NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

1.3. Configure tnsnames. ora

Tnsnames. ora (located in instantclient-basic)

# Neikong is the name of the oracle service instance. Set this parameter based on your actual situation. Neikong =   (DESCRIPTION =   (ADDRESS_LIST =   #172.16.3.153 fill in according to the actual situation, if you need to modify the port number, you can also modify (ADDRESS = (PROTOCOL = TCP) (HOST =172.16.3.153) (PORT = 1521 ))   )   (CONNECT_DATA =   (SERVICE_NAME = neikong)   )   )

1.4. Configure Environment Variables

Variable name	TNS_ADMIN
Variable value	D: \ JavaEEServer \ instantclient_10_2

 

1.5. Configure PL/SQLDeveloper

Install PL/SQL Developer and configure oracle Connection parameters: Open PL/SQL, Tools --> Preferences, and configure Oracle Home and OCI library for Connection, as shown in