Oracleclient + PLSQL Developer remote login to Oracle Database

Oracleclient + PLSQL Developer remote login to Oracle Database

Oracle databases have powerful functions and excellent performance. When these advantages are created, Oracle accounts for more memory than memory. To address this problem, how can we extract the essence of the problem to its dregs?

Solution: we can install a large Oracle database on the server in the LAN, install Oracleclient on the developer's PC, and remotely log on to the Oracle database through Oracleclient.

Procedure:

1. We can download Oracleclient software from the Oracle official website or from Baidu online storage. Recommended online storage: http://pan.baidu.com/s/1jg272hg. after downloading the software, install it;

2. Install PLSQL Developer;

3. In the installation folder of the Oracle client (my installation path is C: \ Program Files (x86) \ Oracle \ odac_client), create a file named tnsnames. ora with the following content:

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

HOST is the IP address of the remote Oracle database, and PORT is the port number of the connection.

4. Add the system environment variable named TNS_ADMIN and the value is the path of the tnsnames. ora file;

5. open PLSQL Developer, Tool --> Prefrence, and set Oracle Home as the Client installation path (my Files are C: \ Program Files (x86) \ Oracle \ odac_client ), OCI Library is the Client installation path + oci. dll (my Files are C: \ Program Files (x86) \ Oracle \ odac_client \ oci. dll );

6. Restart PLSQL Developer after the configuration is complete;

7. Run the select userenv ('language') from dual; command in PLSQL Developer and add the system environment variable named NLS_LANG. The value is the running result of the preceding command.

At this point, we can remotely log on to the Oracle database on 192.168.24.248server through the local PLSQL Developer.

I hope my explanation will help you.