Use Oracle Instant Client to remotely connect to the database without installing a client using PLSQL

Source: Internet
Author: User

First download the Instant Client Program: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

After downloading, compress the file to D: \ oracle \ instantclient_11_2

Configure the system environment variables and add the following content to the existing environment variables:

Path = D: \ oracle \ instantclient_11_1

Tns_admin = D: \ oracle \ instantclient_11_1
LD_LIBRARY_PATH = D: \ oracle \ instantclient_11_1
Sqlpath = D: \ oracle \ instantclient_11_1
Nls_lang = simplified chinese_china.zhs16gbk

After the environment variable is configured, copy the tnsnames. ora file to the D: \ oracle \ instantclient_11_2 directory.

 

Open plsqldev, select "preferences..." in the "Tools" menu, and set the parameters on the options page:
Oracle Home = D: \ oracle
OCI library = D: \ oracle \ OCI. dll

 

Note: If you encounter a ora-01460 error during operations, it may be that the character set settings are inconsistent with the server. You can open the SQL window in plsqldev and execute select userenv ('language') from dual to get the character set settings of the database to be connected, then set nls_lang = <server Character Set> in the local environment variable to solve the problem.

 

NOTE: Refer to the following two documents:

Http://www.cnblogs.com/dba001/archive/2011/02/27/1966188.html

Http://blog.chinaunix.net/uid-257761-id-2458150.html

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.