国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Table of Contents
Contents
Also see
External links
Home Database Mysql Tutorial SQL*Net( Oracle's networking software)簡(jiǎn)介

SQL*Net( Oracle's networking software)簡(jiǎn)介

Jun 07, 2016 pm 03:45 PM
amp net network oracle sql

SQL*Net (or Net8) isOracle's networking software that 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 an

SQL*Net (or Net8) is Oracle's networking software that 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

  • 1 Client configuration
  • 2 Server configuration
  • 3 Benefits provided by SQL*Net
  • 4 Configuration Files
  • 5 Also see
  • 6 External links

Client configuration

The Oracle Client software is required on workstations and servers that need to connect to remote Oracle Databases.

Server configuration

The cornerstone of SQL*Net is a process called the listener. 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 including TCP/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
  • Download SQL*Net V2 Light for DOS
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

PHP Tutorial
1502
276
What is Impossible Cloud Network (ICNT)? How? A comprehensive introduction to the ICN project that Binance will launch soon What is Impossible Cloud Network (ICNT)? How? A comprehensive introduction to the ICN project that Binance will launch soon Jul 07, 2025 pm 07:06 PM

Contents 1. What is ICN? 2. ICNT latest updates 3. Comparison and economic model between ICN and other DePIN projects and economic models 4. Conclusion of the next stage of the DePIN track At the end of May, ICN (ImpossibleCloudNetwork) @ICN_Protocol announced that it had received strategic investment in NGPCapital with a valuation of US$470 million. Many people's first reaction was: "Has Xiaomi invested in Web3?" Although this was not Lei Jun's direct move, the one who had bet on Xiaomi, Helium, and WorkFusion

How does Oracle manage transaction commits and rollbacks using redo and undo mechanisms? How does Oracle manage transaction commits and rollbacks using redo and undo mechanisms? Jul 08, 2025 am 12:16 AM

Oracleensurestransactiondurabilityandconsistencyusingredoforcommitsandundoforrollbacks.Duringacommit,Oraclegeneratesacommitrecordintheredologbuffer,markschangesaspermanentinredologs,andupdatestheSCNtoreflectthecurrentdatabasestate.Forrollbacks,Oracle

JavaScript time object, someone builds an eactexe, faster website on Google Chrome, etc. JavaScript time object, someone builds an eactexe, faster website on Google Chrome, etc. Jul 08, 2025 pm 02:27 PM

Hello, JavaScript developers! Welcome to this week's JavaScript news! This week we will focus on: Oracle's trademark dispute with Deno, new JavaScript time objects are supported by browsers, Google Chrome updates, and some powerful developer tools. Let's get started! Oracle's trademark dispute with Deno Oracle's attempt to register a "JavaScript" trademark has caused controversy. Ryan Dahl, the creator of Node.js and Deno, has filed a petition to cancel the trademark, and he believes that JavaScript is an open standard and should not be used by Oracle

How does Oracle handle character set conversions, and what are potential issues? How does Oracle handle character set conversions, and what are potential issues? Jul 13, 2025 am 12:52 AM

Oracle automatically handles conversions between different character sets, but if the target character set cannot represent characters in the source character set, data loss or replacement may occur. Its core mechanism is to use the built-in conversion engine for character mapping, which is often when the client and the database NLS_LANG settings are inconsistent, cross-database transmission, or use the CONVERT() function. Key considerations include: 1. Use AL32UTF8 as the database character set to support Unicode; 2. Properly configure the client NLS_LANG; 3. Use NVARCHAR2 and NCLOB to store multilingual data; 4. Use CSSCAN tools to detect potential problems before migration; 5. Beware of LENGTH(), SUBSTR() and other functions

How do roles simplify user privilege management in an Oracle database? How do roles simplify user privilege management in an Oracle database? Jul 05, 2025 am 01:22 AM

The role of roles in Oracle database is to simplify user permission management by grouping relevant permissions, improving efficiency and accuracy. Specific advantages include: 1. Simplify permission allocation. DBAs do not need to grant the same permissions to users one by one, but create roles containing specific permissions and grant them to users in batches; 2. Implement centralized access control, and permission changes only require updating roles to synchronize to all relevant users, reducing the risk of duplicate operations and errors; 3. Support default roles and nested roles, and provide automatic permission activation, hierarchical permission structure and other functions to enhance flexibility and management elaboration. These features make roles a key tool for efficient and secure management of database access.

How to create empty tables with the same structure as another table? How to create empty tables with the same structure as another table? Jul 11, 2025 am 01:51 AM

You can use SQL's CREATETABLE statement and SELECT clause to create a table with the same structure as another table. The specific steps are as follows: 1. Create an empty table using CREATETABLEnew_tableASSELECT*FROMexisting_tableWHERE1=0;. 2. Manually add indexes, foreign keys, triggers, etc. when necessary to ensure that the new table is intact and consistent with the original table structure.

What is the difference between a clustered and a non-clustered index in SQL? What is the difference between a clustered and a non-clustered index in SQL? Jul 04, 2025 am 03:03 AM

Clusteredandnon-clusteredindexesdifferindataorganizationandusage.1.Clusteredindexesdefinethephysicalorderofdatastorage,allowingonlyonepertable,idealforrangequeries.2.Non-clusteredindexescreateaseparatestructurewithpointerstodatarows,enablingmultiplei

What is Fragmetric (FRAG)? How? Analysis of FRAG token economy and future prospects What is Fragmetric (FRAG)? How? Analysis of FRAG token economy and future prospects Jul 07, 2025 pm 07:27 PM

Directory What is Fragmetric(FRAG)? The difference between Fragmetric and FRAG tokens What problems does Fragmetric solve? 1. The financial efficiency of traditional staking 2. Cybersecurity fragmentation 3. Complex output optimization 4. Community governance limited in DeFi history and background of Fragmetric FRAG main functions 1. FRAG-22 asset management standard 2. Liquidity re-mortgage innovation 3. NCN exclusive partnership 4. Community-driven governance 5. Multi-asset integration Fr

See all articles