Configure PL/SQL Developer to connect to the server database, pldeveloper

Configure PL/SQL Developer to connect to the server database, pldeveloper
Configure PL/SQL Developer to connect to the server database

Install client software on the Remote Application Server, which can be downloaded from the official oracle 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 10 GB
Database 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

Follow these steps in win7:

Download the client software and install it, for example, 10201_client_win32 \ setup.exe.

After the installation is complete, you will be directed to the Oracle Net Configuration Assistant Interface, as shown below:

Enter the SID Name. In this article, the name is GAME (based on the actual SID)

Select TCP as the Protocol.

Next, enter the IP address 192.168.56.5.

If the test fails, it may be caused by incorrect login information. You can click "Change login" to reset the settings and test again. The test is successful as follows:

The service name configuration page is displayed as follows:

So far, the client software configuration is complete, and you can click exit on the interface.

2. Connect to PL/SQL Developer Software

Download, install, and run the PL/SQL Developer software.

After entering, you can enter the user field on the left sidebar to operate the table or object, as shown in:

3. Connect to the SQL Developer Software

In my habits, oracle recommends installing SQL Developer software. After installing the client, the following section describes how to run the SQL Developer software:

Download and install SQL Developer on the official website, and run the following:

Enter the connection and login information and test. The following shows "test successful ". You can click "Connect" to the database, as shown below:

So far, the SQL Developer test connection is successful.

**************************************** *******Statement************************************************ 

Original works, from "Deep Blue blog" blog, welcome to reprint, reprint please be sure to indicate the source (http://blog.csdn.net/huangyanlong ).

Please leave a message if the statement is incorrect. Thank you very much.

Reminder: Click the directory to view the directory.

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

How to configure pl/SQL to connect to a remote oracle Server

(1) solution for not installing the client.
Method 1:
1. Search for the following files on the machine where the ORACLE server is installed,
Oci. dll
Ocijdbc10.dll
Ociw32.dll
Orannzsbb10.dll
Oraocci10.dll
Oraociei10.dll (the server may not exist. If not, you can log on to pl SQL with the username and password)
Sqlnet. ora
Tnsnames. ora
Classes12.jar
Ojdbc14.jar
Put it in a folder, such as your lient
2. Configure tnsnames. ora. If oracle is not installed on the local machine, copy one (tnsnames. the ora file is under % ORACLE_HOME % \ network \ admin) in the Directory D: \ clientlient above.
Oracledata =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = oracledata)
)
)
3. Add an environment variable named TNS_ADMIN with the value tnsnames. the path of the ora file (for example, D: \ your lient, especially after reinstallation or other operations, if you forget the TNS_ADMIN variable, the connection identifier cannot be parsed when you log on to plsql ), this is to find the tnsnames mentioned above. ora. If ORACLE is installed on the local machine and the ORACLE_HOME environment variable is set, the tnsnames. ora file is automatically located in % ORACLE_HOME %/network/admin.
4. Set the ORACLE language and add environment variables:
"NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK)
(This step is currently correct. If the encoding is incorrect, garbled characters will be generated)
5. download and install the PL. SQL. Developer configuration application
Configure tools> preferences> connection
Oracle Home = D: \ oracleclient
OCI library = D: \ oracleclient \ oci. dll
6. If you enable plsql again, you can log on to the database by entering the username and password with the oracledata option.

Method 2:
1. First, go to the oracle official download client compressed package, address: www.oracle.com/..0.html, select the operating system of the machine and then select the corresponding oracle basecompressed package download.
2. Decompress the downloaded package to the corresponding directory, such as D: \ worksoftware \ instantclient_10_2;
3. Create the NETWORD directory under this directory, and then create the ADMIN directory under the NETWORK directory, such as D ...... the remaining full text>

Connect to Oracle using PL/SQL Developer

If oracle does not want to change anything, you can use:

Environment variable settings

Configure the environment variables, right-click "my computer"-> "properties"-> "advanced"-> "environment variables"-> "system variables", and add the following content:

1) variable name: ORACLE_HOME
Variable value: C: \ Program Files \ instantclient_10_2
2) variable name: TNS_ADMIN
Variable value: C: \ Program Files \ instantclient_10_2
3) variable name: NLS_LANG
Variable value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
4) modify the Path variable and add C: \ Program Files \ instantclient_10_2.

(3) Add a network configuration file

Add the network configuration file in C: \ Program Files \ instantclient_10_2, create a text file, name it tnsnames. ora (note that the extension is. ora, not txt), and write the following content:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.1) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

The red part is my personal settings, the IP address of the ORACLE database server is 192.168.1.1, and the database instance name is orcl.

(4) Inspection

If the configuration is correct, open PL/SQL Developer.