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

Editor to share with you oracle client and pl/sql how to achieve remote connection configuration, I hope you will learn something after reading this article, let's discuss it together!

I. Preface

PL/SQL is a database language formed by Oracle company by extending the standard SQL language. It is pinned on the traditional SQL sentence, at the same time, it has made a lot of expansion in the function. PL/SQL has so many advantages that it even eclipses SQL. PL/SQL Developer is an integrated development environment designed to develop, test, debug, and optimize Oracle PL/SQL storage program units, such as triggers.

PL/SQL Developer, a database development environment, has very comprehensive functions, which greatly shortens the development cycle of programmers. Powerful PL/SQL editor, perfect Debugger debugger. Although PL/SQL Developer is not as functional as SQL Developer at present, it is an ORACLE database management tool developed with pure JAVA, so it can be easily used across operating system platforms and can be used on non-windows OS. Because PL/SQL Developer is not well used in Linux WINE, you can't call LINUX's OCI library directly, so if you are a user of Linux, you can only choose to use SQL Developer.

Hope that this fully functional PL/SQL Developer can bring convenience to the majority of developers.

II. Environment

Local:

System: win7 64 bit

Software and version:

10201_client_win32.zip

PlsqlV8.0.0.1480.rar

Remote:

AIX+oracle 11g

III. Oracle client installation

1. Select "next"

two。 Pay attention to selecting an administrator during installation and then complete the next step

3. Make a name that is a directory

4. All checks passed.

5. Preview the summary and start the installation

6. Installing

7. The default is as follows

8. If there are no special requirements, select "perform typical configuration"

9, select "next"

10. Just finish it.

11. The installation is complete.

IV. Oracle client configuration

1. Find the installed oracle client program in all the programs on the computer

two。 Select Local Net Service name configuration

3. Select add

Port numbers vary from oracle server to port.

Run a connection test.

If the test fails, change the login and change the password (the password is the password you set when you installed oracle).

Retest, successful.

Default is fine.

Configuration completed

Just finish it.

View the configuration file (depending on the installation directory):

# tnsnames.ora Network Configuration File: C:\ oracle\ network\ admin\ tnsnames.ora# Generated by Oracle configuration tools.ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.246.147.3) (PORT = 1522) (CONNECT_DATA = (SERVICE_NAME = orcl)

5. Pl/sql connection

Randomly find a table, select "Query data", you can execute the sql statement, you can also create tables and other operations in it.

Execute query statement

Select and "View" in the figure above to query the statement when the table was created.

After reading this article, I believe you have a certain understanding of "oracle client and pl/sql how to achieve remote connection configuration". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.