Chapter02Oracle Net Architecture

Concepts & Terminology

View Code
Database Services
Service Name
    A logical representation of a database
    The way a database is presented to clients
Connect Descriptor
    Location of the database
    Name of the database service
Listener
    Receives client connection requests
    Hands requests to the database server

 Overview of Naming Methods

Naming methods are used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service.

Oracle Net provides five naming methods:

  • Host naming
    • sqlplus HR/HR@192.168.1.200:1521/poli   //这种方法已经过时了 
  • Local naming
    • sqlplus HR/HR@DB200
  • Directory naming    //大规模数据的使用
  • Oracle Names //过时
  • External naming //第三方使用

 Configuration Files

  • ldap.ora
  • names.ora
  • tnsnames.ora
  • listener.ora
  • sqlnet.ora

 Three Key Parameters

  • Connect Descriptor
    • Location of the database
    • Name of the databse service
原文地址:https://www.cnblogs.com/arcer/p/2955683.html