Do not install Oracle client, connect Oracle with Plsql

1.1. Instant Client Download

Website:

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

Download Instantclient-basic Package and store the package locally, this test is D:\JavaEEServer\instantclient_10_2

1.2. Configure Sqlnet.ora

Sqlnet.ora (located under Instantclient-basic)

Sqlnet. Authentication_services= (NTS) NAMES. Directory_path= (TNSNames, Ezconnect)

1.3. Configure Tnsnames.ora

Tnsnames.ora (located under Instantclient-basic)

#neikong为oracle服务实例名, fill in according to your actual situation Neikong = (DESCRIPTION = (Address_list = #172.16.3.153 According to the actual situation, if you need to modify the port number can also be modified (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 connection parameters for Oracle: Open pl/sql,tools-->preferences, configure connection's Oracle home and OCI library as shown in

1.6. Reboot, enter user name and password test

Do not install Oracle client, connect Oracle with Plsql