Shulou(Shulou.com)06/01 Report--

Test environment description

Oracle database server operating system: windowsserver2008x64

Oracle database version: Oracle11.2.0.4x64

PLSQLDeveloper version: PLSQLDeveloper12x64

This article is for beginners to learn to use, relatively detailed description and screenshots. This article mainly introduces PLSQLDeveloper connecting to Oracle database in the following two situations.

First: install and use PLSQLDeveloper12x64 bit on Oracle server (usually encountered in implementation, accustomed to using PLSQLDeveloper directly on the server to facilitate future remote and direct environment. )

Second: install and use PLSQLDeveloper12x64 bit on your own computer (generally normal DBA, implementation, operation and maintenance, and development engineers will install it locally. )

Note: install PLSQLDeveloper with the same number of digits (32 or 64 bits) as when you install the Oracle client

To connect to the Oracle database using PLSQLDeveloper, the client software for Oracle needs to be installed on the client machine (the client software must be the same number as PLSQLDeveloper). If the machine on which PLSQLDeveloper is installed has the Oracle database (PLSQLDeveloper must have the same number of digits as the database), you do not need to install the Oracle client on that machine separately.

PLSQLDeveloper login database principle, the figure also lists two login methods, one is to use the network service name to log in, the other is to use the IP address: Port number / database name. If you log in using a network name, you need to configure the local network service name, which is the parameter in tnsnames.

Install PLSQLDeveloper12

Install the Oracle client (you can ignore this step if you have database software with the same number of digits as PLSQLDeveloper)

Because we are going to install the PLSQLDeveloper12x64 bit, I chose a 64-bit 11G Oracle client installation here.

Install database connection: https://blog.51cto.com/zhanky/2359027

Install PLSQLDeveloper

When using PLSQLDeveloper on the server, you only need to install the same number of PLSQLDeveloper as the Oracle database. If the most obvious difference is that the database information cannot be found in the Database drop-down when logging in, you will report an error even if you use the IP address: Port / database name (there are two ways for PLSQLDeveloper to log in to the database, one is to read the data in the tnsnames in the client network configuration, and the other is to directly use the IP address: Port / database name)

Double-click the downloaded PLSQLDeveloper to start the installation

Select the next step

Click to agree to the agreement and select the next step

Select trial installation

Select full version installation

Start installation

Complete the installation

Log in to the database using PLSQLDeveloper

Because in the server environment, the tnsnames is created automatically when the database instance is created, so you can directly select the database that needs to log in, enter the user name and password and select ok to log in to the database.

When you open it, you will be prompted to register the authentic copy, and you can enter it directly if you have a registration code. Here, test it first and eliminate it first.

Create a new sqlwindow window

Querying database information is our test library. Go to the server to install and use PLSQLDeveloper to complete the test.

PLSQLDeveloper Sinicization

It just so happens that there is a Sinicization package in the installation package. According to your personal preference, if you want to use the Chinese version, you can follow the following method.

Select the path where PLSQLDeveloper is installed

By default, you can only choose preferences, so let's just Sinicize preferences.

Then when this step is finished, the Sinicization is completed.

Try the Chinese version of plsql

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.