Windows-Free Oracle Client PLSQL configuration

Source: Internet
Author: User

1. Download the Oracle Client package.

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

Instant Client Package–basic Package (callout: All files required to run OCI, OCCI, and jdbc-oci applications) Download Version 11.1 here .0.7

2. Save the Oracle Client package locally:

Create folders, such as Oracle_client, to 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 configuring Sqlnet.ora and Tnsnames.ora

For example, here are:

Sqlnet.ora File Contents  :

Sqlnet. Authentication_services= (NTS)

NAMES. Directory_path= (TNSNames, Ezconnect)

Tnsnames.ora File Contents ( italic indicates 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: oracle_home

Variable Value: D:\oracle_client\instantclient_10_2

Otherwise appears: Ora-12154:tns:could not resolve the connect identifier specified error

If you have previously installed Oracle and uninstalled, you will be left with the Nls_lang=na key value. Enter regedit to open the registry hkey_local_machine/software/oracle. Find Nls_lang=na on the right and delete it.

Otherwise it will be reported ora-12705:cannot access NLS data files or invalid error.

5. Install PL/SQL software ( process slightly )

6. Configure the Oracle Connection Parameters for PL /sql:

Select the connection in the PL/SQL Tools/Preferences (too/preference/) and set the Oracle home directory name (i.e. the installation directory) and the OCI library on the right.

Oracle Home directory Name: D:\oracle_client\instantclient_10_2

OCI Library: D:\oracle_client\instantclient_10_2\oci.dll

7. landed PL/SQL test succeeded

Windows-Free Oracle Client PLSQL configuration

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.