Use sqlplus and PLSQL developer to remotely connect to the Oracle database

The following figure shows two steps for installing the Oracle database server software and client software:

Through the above process, we know that the server and the client have a file to be configured, the server is the listener configuration file, and the client is the network service name configuration file. The descriptions are as follows:

The server listener file is stored in the listener. ora file, which includes the listener protocol, address, and other related information. However, this configuration has been automatically configured during the installation process and does not need to be configured in the following practices.

The network server name configuration file of the client is saved in tnsnames. the ora file contains the server address, listening port number, and database Sid (indicating the database instance, which has been determined during the installation process. For example, the Oracle instance in the data center is orcl)

After installing the Oracle database and starting the service response service, you can use tools such as sqlplus to connect to it locally. However, it is still difficult for the client to use the tool during this time. On the one hand, Oracle Database beginners do not know whether the client has sqlplus and where to download it; on the other hand, they do not know how to configure it to connect to remote ORACLE. The following is a brief explanation.

The following is a: http://www.oracle.com/technetwork/topics/winsoft-085727.html

The version selected in this experiment is v.10.2.0.4 restart.

Put the files in the preceding three packages into the same directory, for example, H:/program files/sqlplus. Then configure or create the following environment variables:

1. nls_lang = simplified chinese_china.zhs16gbk

2. tns_admin = H:/program files/sqlplus (Our extract directory !)

3. LD_LIBRARY_PATH = H:/program files/sqlplus (decompress the directory here !)

4. sqlpath = H:/program files/sqlplus (Our extract directory !)

5. Path = H:/program files/sqlplus (Our extract directory !)

One more step is required, that is, the tnsnames mentioned earlier. the configuration information of the ora file, which is easy to write by yourself, can be found in the Oracle Installation Directory (like our data center is D:/oral0instanceclient ), copy the file to the decompressed directory (H:/program files/sqlplus) and modify the file according to the preceding configuration. If this file is copied, you only need to change the IP address of the host to the server address!

Enter sqlplus username/password @ orcl in cmd, where orcl is the database instance when we install oracle! After completing these configurations, you will find that PLSQL developer can also use it!