Connect to the Oracle database with Plsql by using a thin client that does not require installation

Source: Internet
Author: User

Connect to the Oracle database with Plsql by using a thin client that does not require an installed client.

Download the installation package first
Download the Oracle Instantclient Basic package on the ORALCE official website.
The address is as follows: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Find the instant client in the middle of this page and select the appropriate version to download in Instant client downloads.

Step Two: Unzip the installation package
1> after the download is complete, unzip the compressed file to a local path, such as C:/instantclient.
2> the folder Network/admin under this path, the Tnsnames.ora file is created under the C:/instantclient/network/admin folder, and the file content is the TNS information for the database that you want to connect to. For example:

WORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.4) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

In fact, you can also directly copy the server's network files to the Instantclient folder
The Oracle database server IP is 192.168.1.4, and the database service is named ORCL. If you do not know the service name, you can use the following command to view:
Show Parameter Service_Name

Step three: Set environment variables
New in User variables:
Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk
Add C:\instantclient to the system variable path

Fourth Step: Configure PL/SQL developer
Start PL/SQL Developer, in the Login window interface, click the Cancel button can be the main interface, click Tools->preferences, in connection need to configure the following two parameters, select the path
Oracle home:c:\instantclient
OCI Library:c:\instantclient\oci.dll

Connect to the Oracle database with Plsql by using a thin client that does not require installation

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.