Oracle client + PLSQL Developer remote login to Oracle database, oracle client plsql

Oracle client + PLSQL Developer remote login to Oracle database, oracle client plsql

Oracle databases have powerful functions and excellent performance. These advantages also result in a large amount of memory occupied by Oracle. To address this problem, how can we extract the essence of this problem to its dregs?

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

Procedure:

1. We can download the Oracle client software from the Oracle official website or from Baidu online storage. Recommended online storage: http://pan.baidu.com/s/1ktyzdsz. After installation, download the software;

2. Install PLSQL Developer;

3. In the installation directory of the Oracle client (my installation path is C: \ Program Files (x86) \ Oracle \ odac_client), create the tnsnames. ora file. The file content is as follows:

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 connected PORT number.

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 to add the system environment variable named NLS_LANG. The value is the execution result of the preceding command.

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

I hope my explanation will help you.

How can plsql developer connect to a remote oracle? Method 1: Modify the tnsnames. ora file in the oracle Installation Directory
Method 2: Use the oraclenet manager tool to configure a remote database
Method 3: Enter the username and password in the logon window of plsql developer. Enter the database IP/SID.
Plsql Route 8 how to connect to a remote database 1. Oracle downloads the Package software named Instant Client. You need to install and unzip the directory. In this example, the local machine decompress E: \ OracleClient. In fact, the Oracle Client path E: \ OracleClient \ instantclient_10_2
2. Configure Operating System Environment Variables
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN = C: \ oracleclient
3. Go to the instantclient_10_2 folder and create a network folder. Under the network folder, create an admin folder and create a file named tnsnames. ora under the file content: databasename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = ip address) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = database name)
)
)
Note that the database name and ip address must be filled in according to the actual situation.
4. Install PL/SQL Developer
5. log on to PL/SQL Developer)
Select Tools> PreferencesOracle Home and OCI Library, and fill in the Oracle client path and OCI file path. E: \ OracleClient \ instantclient_10_2 and E: \ OracleClient \ instantclient_10_2 \ oci. dll
6. Restart PL/SQL Logon