Shulou(Shulou.com)05/31 Report--

This article mainly introduces PL/SQL Developer 11.0.4.1774 how to connect 64-bit Oracle 11Gr2, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

The following is the installation test step:

Install plsqldev1104.exe

The version is as follows: 11.0.4 unlimited cracked version of the system win7 64-bit:

1. Download oracle client or oci component http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

3. Decompress it without installation. There are two versions here that are inconsistent with the server 11gr2, but with little impact and are generally backward compatible.

Then create a two-tier folder\ NETWORK\ ADMIN under the instantclient_12_2 directory, and then copy network\ admin\ tnsnames.ora under the 11gr2 listener under the ADMIN folder, or write one as follows:

# Generated by Oracle configuration tools.

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = ORCL)

)

)

We must pay attention to the above three points. In addition, some windows versions of tnsnames.ora.txt have txt to be removed.

4. Double-click to open PLSQL point cancel

Enter no login mode and click Tools- "Preferences-" connection- > as shown in the figure:

Point OK Save

5. Restart to log in. You can log in remotely as a DBA user.

6. Verify the link and write a SQL statement to test

Test shows data, OK!

Thank you for reading this article carefully. I hope the article "how to connect PL/SQL Developer 11.0.4.1774 to 64-bit Oracle 11Gr2" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.