PL SQL Developer Client Connection server

After you install Oracle,plsql , turn on monitoring in the server.

Computer right-management-services and applications-services-Open the service that begins with Oracle, especially the listener, the most important and specific.

(1) Configuring the monitoring location

Start-All Programs-oracle_oradb11g_home1-config and porting tool-Net Manager, as a result, In this page, you can configure not only the listener but also the server address. Select Listener, you can add listening configuration monitoring. This is more common also more familiar with not detailed written.

(2) Select the service name, you can make the appropriate 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, go to the following page, directly by default Select can, direct point next.

(4) Click Next to enter the following page. The host name is the server IP address of the connection .

(5) Default port number, click Next to 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, you can click the Test button to test the database connection.

(7) The user name and password of the current login, the result of the test and the reason are displayed after entering. After entering, click the Change Login button to modify the user name and password. The user name starts with the LC , the middle is the instance name (m572)in the GS Suite, and finally the 9999. The password is the password that is connected to the database. When you click OK, the message appears and the test succeeds or fails.

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

PL SQL Developer Client Connection server