Shulou(Shulou.com)06/01 Report--

1. download

Download from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

Instant Client Package-Basic package (marked: All files required to run OCI, OCCI, and JDBC-OCI applications) what is downloaded here is Version 11.1.0.7

two。 Save Oracle Client Package locally:

Create a folder, such as oracle_client, and compress the downloaded files into this folder. (author directory: d:\ oracle_client\ instantclient_10_2)

3. In the current directory, create two new files, sqlnet.ora and tnsnames.ora, and then manually configure sqlnet.ora and tnsnames.ora

For example, here is:

Contents of sqlnet.ora file:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

The contents of the tnsnames.ora file (italics indicate what needs to be replaced):

Orcl=

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

4. Configure environment variables

Variable name: TNS_ADMIN

Variable value: d:\ oracle_client\ instantclient_10_2

Otherwise, a: ORA-12154: TNS:could not resolve the connect identifier specified error occurs

5. Install pl/sql software (brief process)

6. Configure Oracle connection parameters for pl/sql:

Select the connection in pl/sql 's tools / preferences (too/ preference/) and set the Oracle main directory name (that is, the installation directory) and the OCI library on the right.

Oracle main directory name: d:\ oracle_client\ instantclient_10_2

OCI library: d:\ oracle_client\ instantclient_10_2\ oci.dll

7. Log in to pl/sql and test successfully

Software download link: http://pan.baidu.com/s/1o6mD4ZC

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.