Role of TNS in Oracle, role of OracleTNS

Source: Internet
Author: User

Role of TNS in Oracle, role of OracleTNS

What is TNS?

TNS is a part of Oracle Net. It is a tool used to manage and configure the connection between the Oracle database and the client. In most cases, to communicate with the database, TNS must be configured, of course, in a few cases, you can connect to the Oracle database without configuring TNS, such as through JDBC. if you use TNS to connect to Oracle, the Oracle client must be installed on the client.

When to use TNS

As mentioned above, TNS is required for non-JDBC connection to ORACLE. In addition, when the local database client connects to data, the host string is the locally specified service name, not the database SID, note This. The client software of TNS must be specified, including PL/SQL and SQL * PLUS.

As mentioned above, TNS is used in non-JDBC and other connection modes. In other words, TNS does not need to be configured when data is directly connected using JDBC or other methods, such client tools include SQL Developer. These clients connect to the database using some Development Speech such as JAVA and other JDBC methods, so you do not need to configure TNS.


The instructor asked what TNS is, oracle

Tns is used to remotely connect to Oracle on other machines through the TCP/IP protocol, and basic is the Oracle in the local machine. Personal ignorance.

Where is the tns file stored in oracle?

$ ORACLE_HOME \ network \ admin \ tnsnames. ora
For example:
[Windows]
C: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora
[Unix]
/Oracle/product/10.2.0/db_1/network/admin/tnsnames. ora

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.