Oracle Remote Connection Database solution

Background: Oracle services are installed on the server and others use PL/SQL remote connections.

It is well known that because the Oracle database is too large to be installed on this machine will cause the computer very card, very affect the daily use. So what we do is to install an Oracle server on the servers, and then someone else installs the Oracle client to connect to the database remotely.

Please see the following specific configuration:

First step: Unzip the client

Unzip the 32-bit Oracle Instant client: instantclient-basic-win32-11.2.0.1.0 to a directory.
Example: D:\app\NiuNiu\product\instantclient_11_2
Then create a new text file under this directory: Tnsnames.ora
File contents:

drp =      (DESCRIPTION =        (ADDRESS_LIST =          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.26.206)(PORT = 1521))        )        (CONNECT_DATA =          (SERVICE_NAME = orcl)        )      )

Step Two: Configure environment variables

1. Right-click "My Computer"-"Properties"-"advanced"-"Environment variables"-"System environment variables"

2. Select "Path"-click "Edit" to add the client's decompression directory;
For example: "D:\Oracle\app\YM\product\instantclient_11_2;"

3. Click ' New ', the variable name is "Tns_admin", the variable value is the client's decompression directory:
For example: "D:\Oracle\app\YM\product\instantclient_11_2;"

4. Click ' New ' and the variable name is ' Nls_lang ' and the variable value is:
"Simplified Chinese_china. ZHS16GBK; "

Step Three: Install the configuration PL/SQL

After the installation is complete, on the login page, click the "Cancel" button:

Select Tools--Preferences to set up

Oracle Home Value: The directory is still unzipped for the client.
Example: D:\app\NiuNiu\product\instantclient_11_2
Value of OCI Library: Extract directory +oci.dll
Example: D:\app\NiuNiu\product\instantclient_11_2\oci.dll

Such as:

Click the "OK" button to close the Plsql and turn it back on.

Fourth Step: Verify Login

Enter login information

Login Successful Interface:

It is possible to enter information in the seventh step, the Database drop-down box is empty. The premise is that the environment variables are already configured.
If that's the case, it will only be a big trick:

Create a new BAT file below the Plsql Developer directory, replace its shortcut, and start Plsql Developer:
File contents:

@echo offset path=D:\app\NiuNiu\product\instantclient_11_2set ORACLE_HOME=D:\app\NiuNiu\product\instantclient_11_2set TNS_ADMIN=D:\app\NiuNiu\product\instantclient_11_2set NLS_LANG=AMERICAN_AMERICA.ZHS16GBKstart plsqldev.exe

You can start Plsql by double-clicking the script file.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Oracle Remote Connection Database solution