SQL*Net( Oracle's networking software)簡(jiǎn)介
Jun 07, 2016 pm 03:45 PMSQL*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
|
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
External links
- Download SQL*Net V2 Light for DOS

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

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

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

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

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

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.

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.

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

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
