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 number	Oracle Database 10g
DB Instance Name	GAME
Client software version number	10201_client_win32
PL/SQL Developer version number	7.0.1.1066
SQL Developer Version number	4.0.0.13

1. Client Software Installation

Win7 Complete operation:

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

After the installation is complete, direct access to the Oracle Net Configuration assistant interface, such as the following:

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

The protocol chooses TCP to do so.

Next, enter ip:192.168.56.5

If the test is unsuccessful, may be due to incorrect login information, can click "Change Login" again set again after testing, the following is the test success:

The next step is to enter the service name configuration interface, as seen in the following:

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

2. Connect PL/SQL developer software

Download PL/SQL developer software, install, execute.

After entering, you can enter the desired user under the left sidebar, and manipulate the detailed table or object, for example, as seen 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 execution of the SQL Developer Software Section:

Download the SQL developer and install it, perform the following example:

After entering the connection and landing information, test, such as the following shows "test success." can click "Connect" to the database, for example, 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: Clicking on a folder will help you to view it more.

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

Configuring the PL/SQL Developer Connection Server database