Configuring the PL/SQL Developer Connection Server database

Configuring the PL/SQL Developer Connection Server database

The client software is installed on the remote application server and can be downloaded on the Oracle official website.

Example:

Environment

Application Server operating system	WIN 7
Local address	192.168.56.117
Production server operating system	Enterprise Linux Server Release 5.4
Host Name	Org54
Host Address	192.168.56.5
Database version	Oracle Database 10g
DB Instance Name	GAME
Client software version	10201_client_win32
PL/SQL Developer version	7.0.1.1066
SQL Developer Version	4.0.0.13

1. Client Software Installation

Complete the operation under Win7:

After downloading the client software, perform the installation, such as: 10201_client_win32\setup.exe.

After the installation is complete, direct access to the Oracle Net Configuration Assistant interface, as follows:

Enter the SID name, which is the game (depending on the actual SID)

Protocol select TCP.

Next, enter ip:192.168.56.5

If the test is not successful, may be due to incorrect login information, you can click "Change Login" reset after re-test, the following is the test success:

The next step is to enter the service name configuration interface as follows:

At this point, the client software configuration is complete, the interface click Exit.

2. Connect PL/SQL developer software

Download PL/SQL developer software, install, run.

After entering, you can go to the desired user under the left sidebar, and manipulate the specific table or object as shown in:

3. Connecting SQL developer Software

Due to personal habits, Oracle recommends installing SQL Developer software, after installing the client software, the following is the part of running the SQL developer software:

Download the SQL developer and install it, run as follows:

Enter the connection and login information after the test, shown as "Test success." You can click "Connect" to the database, refer to the following:

At this point, the SQL Developer Test connection was successful.

*********************************************** declaration ***************************************** *******

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source (Http://blog.csdn.net/huangyanlong).

There is an error in the statement, please leave a message, greatly appreciated.

Reminder: Click on the table of contents, more helpful to your view.

*************************************************************************************************** **