Pl/SQL is configured to connect to the remote database oracle. The local oracle database is not installed.

Source: Internet
Author: User
First download instantclient. You can download it from the oracle official website. To register an account, you must download the corresponding version. Otherwise, it will fail. For 10G and 11G versions, I have already uploaded it. Free Download: uploading... please wait for the configuration file tnsnames. ora is usually stored in one place (networkADMIN), only in plsql ----- tools -- proferences

First download instantclient. You can download it from the oracle official website. To register an account, you must download the corresponding version. Otherwise, it will fail. For 10G and 11G versions, I have already uploaded it. Free Download: uploading... please wait for the configuration file tnsnames. ora is usually stored in one place (network/ADMIN), only in pl/SQL ----- tools -- proferences

First, you can download the instantclient from the oracle official website. To register an account, you must download the corresponding version. Otherwise, it will fail,

I have uploaded the 10G and 11G versions. It is free to download: Uploading. Please wait.

Configuration File tnsnames. ora is usually put in this place (network/ADMIN), only in pl/SQL -----> tools --> proferences... ------> connection ----> oracle home (empty is autodetect) Write tnsnames. ora path (change the relevant path to your own)

ORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.100.183) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

Export lr_connection_data =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


Set the environment variable (change the directory to your own)

TNS_ADMIN = D: \ soft \ oarcleclient \ instantclient_11_2
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Path = D: \ soft \ oarcleclient \ instantclient_11_2

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.