Shulou(Shulou.com)05/31 Report--

This article shows you how to configure the remote connection database in Oracle, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

File style of tnsnames.ora:

ORA817 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = sun62) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = ora817.huawei.com) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (PROTOCOL = TCP) (HOST = sun62) (PORT = 1521) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = ora817.huawei.com) (PRESENTATION = Http://admin) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO)

The field has the following meanings:

ADDRESS_LIST indicates that the client connects to one or more servers through a variety of protocols. In this style file, it is indicated that the client will use the TCP/IP protocol to connect to the server.

PROTOCOL indicates the protocol to be used for the connection.

SERVICE_NAME "SERVICE_NAME" is "Global Database Name", and the ORACLE8i database uses "Global Database Name" to uniquely identify itself, usually in "name.domain" format, where the value is "ora817.huawei.com".

HOST is the server IP address used by the TCP/IP protocol.

PORT is the port address used by TCP/IP.

SID specifies the ORACLE_SID of the ORACLE database on the server to which you want to connect.

SERVER=DEDICATED means to connect to an ORACLE database with a dedicated server.

Here is an example of the contents of a tnsnames.ora file:

Ora = connection descriptor name: ora (description = description (address = one of the network addresses (protocol = tcp) network protocol (tcp represents TCP/IP protocol) (host = 129.114.22) server IP address: 129.114.22 (port = 1251) server port number: 1251) (connect_data = connection data (sid = ora7) database ID name: ora7 ) TestORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.11.39) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RLIMS) LISTENER_TestORCL = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.11.39) (PORT = 1521))

Supplement: how to configure plsql to connect to oracle database

1. First download the instantclient_11_2 tool (http://download.csdn.net/detail/u013804636/9746431)

2. Add and configure the file tnsnames.ora in the directory instantclient_11_2\ NETWORK\ ADMIN\ in the downloaded tool.

3. Add the following variables to the windows environment variable

TNS_ADMIN:E:\ instantclient_11_2\ NETWORK\ ADMIN

NLS_LANG:SIMPLIFIED CHINESE_CHINA.AL32UTF8 (modified according to the database code, 16GBK)

4. Download and install plsql tools

5. Open the plsql selection tool-> Oracle- > Connect.

Modify the Oracle home directory to: e:\ instantclient_11_2

The OCI library is: e:\ instantclient_11_2\ oci.dll

6. Apply, save, and restart the plsql client

The above is how to configure remote connection to the database in Oracle. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.