SQL*Net( Oracle's networking software)简介
来源:互联网 发布:市场调查公司数据分析 编辑:程序博客网 时间:2024/05/04 09:15
SQL*Net
SQL*Net (or Net8) isOracle's networking softwarethat allows remote data-access between programs and the Oracle Database, or among multiple Oracle Databases. Applications and databases can be distributed physically to different machines and continue to communicate as if they were local.
SQL*Net is based on Oracle's Transparent Network Substrate, a foundation network technology that provides a generic interface to all popular network protocols for connectivity throughout a network of applications.
SQL*Net is used by both client and server to communicate with one another. Without the SQL*Net layer acting as the interpreter, the client process and the server process are unable to interconnect.
Contents
- 1Client configuration
- 2Server configuration
- 3Benefits provided by SQL*Net
- 4Configuration Files
- 5Also see
- 6External links
Client configuration
The Oracle Client software is required on workstations and servers that need to connect to remoteOracle Databases.
Server configuration
The cornerstone of SQL*Net is a process called thelistener.This process, as its name signifies, listens on the network for request from clients requesting data. As soon as a connect request is detected, one of the two things may happen:
- In dedicated server configuration the user process (client end) that the listener has heard is routed to a server process (server side, every user process has a dedicated server process in dedicated configuration).
- In multi threaded configuration the user process that the listener heard is routed to another process called dispatcher (server end), which interacts with shared server process to carry on the activities.
Benefits provided by SQL*Net
- Network Transparency - SQL*Net provides support for a broad range of network transport protocols includingTCP/IP, SPX/IPX, IBM LU6.2, Novell, and DECnet. It does so in a manner that is invisible to the application user. This enables SQL*Net to inter-operate across different types of computers, operating systems, and networks to transparently connect any combination of PC, Unix, legacy, and other system without changes to the existing infrastructure.
- Protocol Independence - SQL*Net enables Oracle applications to run over any supported network protocol by using the appropriate Oracle Protocol Adapter. Applications can be moved to another protocol stack by installing the necessary Oracle Protocol Adapter and the industry protocol stack. Oracle Protocol Adapters provide SQL*Net access to connections over specific protocols or networks. On some platforms, a single Oracle Protocol Adapter will operate on several different network interface boards, allowing you to deploy applications in any networking environment.
- Media/Topology Independence - When SQL*Net passes control of a connection to the underlying protocol, it inherits all media and/or topologies supported by that network protocol stack. This allows the network protocol to use any means of data transmission, such as Ethernet, Token Ring, or other, to accomplish low level data link transmissions between two machines.
- Heterogeneous Networking - Oracle's client-server and server-server models provide connectivity between multiple network protocols using Oracle Connection Manager.
- Large Scale Scalability - By enabling you to use advanced connection concentration and connection pooling features, SQL*Net makes it possible for thousands of concurrent users to connect to a database.
Configuration Files
The following configuration files can be altered to configure SQL*Net:
- sqlnet.ora
- tnsnames.ora
- ldap.ora
- protocol.ora (not used anymore)
- listener.ora
- cman.ora - Connection Manager settings
Also see
- SQL*Net FAQ - Frequently asked questions
External links
- Download SQL*Net V2 Light for DOS
- Network services
参考:sql*net connection 百度
- SQL*Net( Oracle's networking software)简介
- Software-Defined Networking
- PL/SQL;Oracle Net Manager简介
- RTXC Quark™ Networking Software
- PLsql登陆错误:初始化错误 SQL*NET没有完全安装OracleHomekey:software oracle
- oracle SQL简介(一)
- oracle SQL简介(二)
- oracle SQL简介(三)
- oracle SQL简介(四)
- oracle SQL简介(五)
- oracle“SQL Trace”简介
- oracle “SQL Trace”简介
- oracle PL/SQL简介
- Oracle PL/SQL简介
- 同步光网络(SONET,Synchronous Optical Networking)简介
- Oracle扩展PL/SQL简介
- 十九、oracle pl/sql简介
- sql语法值ORACLE简介
- gtk tutorial
- 新开餐饮店如何市场定位,都应该注意些什么?
- Linux源地址路由
- Java多线程几个例子学习
- Mysql数据库复制及备份
- SQL*Net( Oracle's networking software)简介
- javascript错误 Expected identifier, string, or number
- onInterceptTouchEvent和onTouchEvent调用时序
- 字节流、字符流有何区别、转换流的作用
- Apache安装过程及下载功能配置方法
- 6.8 Performing Tasks After a Delay with GCD
- 使用支持SPDY协议的Wireshark截包(含spdyshark插件)
- MySQL、Oracle中版本号的比较
- Eclipse Console 窗口没有显示