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

This article introduces you to use PLSQL to remotely connect to Oracle database, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1. Download oracle's official client connection basic components

Extract instantclient-basic-windows.x64-11.2.0.4.0.zip to a file directory

two。 Configure remote oracle database connection information file

Under the instantclient extract directory, create the tnsnames.ora file.

Enter the configuration content. Each configuration represents a remote database address ip, and the Oracle port number defaults to 1521.

Xxxxxx = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = xxxxxx) (PORT = 1521) ) (CONNECT_DATA = (SERVER = xxxxxx) (SERVICE_NAME = xxxxxx) )

3. Download and install PL/SQL developer 11.0

4. Install the direct startup software, cancel the login and go directly to the main interface

Select tools- > preferences to configure the following, and paste the decompressed directory of the basic components of the oracle official client connection directly:

5. The configured database connection information can be read when you restart, and you can successfully access it by entering the correct account secret.

Different versions of instantclient have been configured, and the directories extracted from different versions may be different. The above is only applicable to version 11.2, and other versions have not been tested.

* split line * *

Deciphering correlation

Log in to the main screen, Help- > Register in the menu bar to open the registration page, fill in the following parameters (provide cracking registration code available for personal testing) and click Register.

Product code:4t46t6vydkvsxekkvf3fjnpzy5wbuhphqz

Serial number:601769

Password:xs374ca

Common account secrets and database settings

In the Tools- > preferences in the menu bar, enter the string (account name / password @ database name) according to the rules in the Fixed Users input area. If there are more than one, enter a new line. Click OK after typing.

Reopen it to select the configured account password database login information

On the use of PLSQL remote connection to the Oracle database to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.