Oracle Net Architecture
2
Copyright © Oracle Corporation, 2002. All rights reserved.
Objectives
After completing this lesson, you should be able to do the following: • Explain the key components of the Oracle Net stack
communication architecture
• Explain Oracle Net’s role in client-server
connections
• Describe how Web client connections are
established through Oracle networking products
2-2
Copyright © Oracle Corporation, 2002. All rights reserved.
Oracle Net Connections
• Oracle Net is used to establish connections
•
between applications on a network depending on the following: – The network configuration – The location of the nodes – The application – The network protocol The connections types can be: – Client-Server Application – Java Application – Web Client Application
2-3
Copyright © Oracle Corporation, 2002. All rights reserved.
Client-Server Application Connection
Client Oracle Database Server
Oracle RDBMS (uses OPI) Client Application (uses OCI)
Two Task Common Two Task Common
Oracle Net Foundation Layer Oracle Net Foundation Layer
Oracle Net Oracle Net
Oracle Protocol Support Oracle Protocol Support
2-4
Copyright © Oracle Corporation, 2002. All rights reserved.
Network Protocol Network Protocol
2-5
Copyright © Oracle Corporation, 2002. All rights reserved.
Web Client Application Connections
Web browsers can connect to an Oracle server in the following ways: • Using an application Web server as a middle tier that is configured with either of the following: – JDBC Oracle Call Interface (OCI) driver – Thin JDBC driver
• Connecting directly to an Oracle server by using
HTTP
2-6
Copyright © Oracle Corporation, 2002. All rights reserved.
Web Client Application Connection: Application Web Server Middle-Tier
Client Server
Java application or applet
HTTP Oracle Net
Web browser
2-7
Copyright © Oracle Corporation, 2002. All rights reserved.
Oracle server Application Web server
Web Client Application Connection: Java Application Client
Oracle Database Server Application Web Server (client)
Java application
Oracle RDBMS
JDBC OCI Driver
Two-Task Common Two-Task Common
Oracle Net Foundation Layer Oracle Net Foundation Layer
Oracle Protocol Support Oracle Protocol Support
2-8
Copyright © Oracle Corporation, 2002. All rights reserved.
Network Protocol Network Protocol
Web Client Application Connection: Java Applet Client
Oracle Database Server
Oracle RDBMS Application Web Server (client)
Java Applet Two-Task Common
JDBC Thin driver
JavaTTC Oracle Net Foundation Layer
JavaNet Oracle Protocol Support
2-9
Copyright © Oracle Corporation, 2002. All rights reserved.
TCP/IP Network Protocol TCP/IP Network Protocol
Web Connections Using HTTP
Client Server
HTTP
Web browser
2-10
Copyright © Oracle Corporation, 2002. All rights reserved.
Oracle server supporting HTTP
Web Browser Direct Connection
Oracle Database Server
Oracle
RDBMS Client
HTTP
Web browser
Oracle Protocol Support HTTP
2-11
Copyright © Oracle Corporation, 2002. All rights reserved.
TCP/IP TCP/IP
Connectivity Concepts and Terminology
• 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
2-12
Copyright © Oracle Corporation, 2002. All rights reserved.
Connectivity Concepts and Terminology
• Service Registration
– Database registers information with the listener – Service handlers available for each instance
• Service Handlers
– Connection points – Dispatcher or dedicated server
2-13
Copyright © Oracle Corporation, 2002. All rights reserved.
Oracle Net Configuration Models
•
Localized management – Local file on each computer in the network
• Centralized management
– LDAP-compliant directory server – Oracle Names server
2-14
Copyright © Oracle Corporation, 2002. All rights reserved.
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 – Local naming – Directory naming – Oracle Names – External naming
2-15
Copyright © Oracle Corporation, 2002. All rights reserved.
Oracle Net Configuration Files
ldap.ora names.ora tnsnames.ora
2-16
Copyright © Oracle Corporation, 2002. All rights reserved.
listener.ora sqlnet.ora
2-17
Copyright © Oracle Corporation, 2002. All rights reserved.
Summary
In this lesson, you should have learned how to: • Explain the key components of the Oracle Net stack
communication architecture
• Explain Oracle Net Services role in client-server
connections
• Describe how Web client connections are
established through Oracle networking products
2-18
Copyright © Oracle Corporation, 2002. All rights reserved.
