PL SQL Developer Client Connection server

After you install Oracle,plsql , open the listener in the server.

Computer right-management-services and applications-services-open the service that begins with Oracle , especially the listener, which is the most important. See in detail.

(1) Configuring the monitoring location

Start-All Programs-oracle_oradb11g_home1-Configuration and porting tools-Net Manager, specifically for example so. In this page, you can configure not only the listener but also the server address. Select the Listener. Ability to participate in monitoring configuration monitoring. This is more common and more familiar is not specifically written.

(2) Select the service name and be able to make the corresponding server configuration.

There is no special requirement for the network server name, the purpose of filling in is to Select the connection server when landing plsql.

(3) Click Next, enter such as the following page, the direct default selection will be able to directly point to the next step.

(4) Click Next to enter a page such as the following. The host name is the serverIP address of the connection .

(5) The default port number, click Next. Enter the page.

The service name is the instance name of the connected database.

After filling out the next step directly.

(6) Enter this page. The ability to click the test button for database connection testing.

(7) The current login username and password will be displayed after entering. The results of the test and the reasons.

Click Change Login button after entering. Change username and password. Username starts with an LC , the middle is The instance name in the GS suite (m572), and finally 9999 . Password is the password when connecting to a database. When you click OK, the corresponding message appears, and the test succeeds or fails.

(8) This basically completes the configuration of the server.

PL SQL Developer Client Connection server