PLSQL developer remotely connects to Oracle Xe database (similar to other Oracle databases)

1. Download from www.oracle.comInstant Client package-Basic: All files required to run OCI, occi, and JDBC-OCI applications,instantclient-basic-nt-11.2.0.3.0.zip(51,149,941 bytes)

2. Install the downloaded client package to D: \ oracleclient, for example, and the client's main directory is D: \ oracleclient \ instantclient_11_2.

3. Create a network subdirectory under D: \ oracleclient \ instantclient_11_2, create an admin subdirectory under the network, and create a tnsnames under D: \ oracleclient \ instantclient_11_2 \ Network \ admin. ora file, the specific content of the file is as follows:

XE=
(Description =
(Address_list =
(Address = (Protocol = TCP) (host =192.168.1.100) (Port =1521))
)
(CONNECT_DATA =
(SERVICE_NAME =XE)
)
)

The red content is the content to be modified. 192.168.1.100 is the Server IP address, and Xe is the server database instance.

4. Open PL/SQL developer, select cancel in the logon window, and enter the following content in menu tool-Preferences:

Oracle main directory name: D: \ oracleclient \ instantclient_11_2

OCI Library: D: \ oracleclient \ instantclient_11_2 \ OCI. dll

5. Disable the server-side firewall (set the firewall's permit policy according to your own needs). This step is very important. Many tests last found that it was a firewall problem.

6. Restart the client PL/SQL developer, and then use the username: HR password: Oracle Database: Xe. The connection is normal.

You can connect to the remote server.

Note:

If the query data contains Chinese characters, garbled characters may occur. The solution is as follows:

Character sets are divided into server-side character sets and client-side character sets.

1. The server-side character set generally selects the Chinese character set when installing the Oracle database. If not, it can only be modified in other ways.

In this case, if the server-side character set is a Chinese character set, use SQL> select userenv ('language') from dual;

The result is as follows: Simplified chinese_china.zhs16gbk

2. Client Character Set

On Windows, set the system environment variable nls_lang = simplified chinese_china.zhs16gbk in the system environment variables.

You can also set it in the DOS window, for example, set nls_lang = simplified chinese_china.zhs16gbk. 

In this way, only the environment variables in this window are affected. 

You can view and insert Chinese characters through settings.