Client-Server Application Connection
Oracle Net enables a network connection between a client and an Oracle database server. Oracle Net is a software component that resides on both the client and on the Oracle database server. It is layered on top of the network protocol.
When a connection is initiated from a client to the Oracle database server, data is passed down a stack on the client, over the network, and up a similar stack to the Oracle database server.
Oracle Server Configuration Options
Oracle creates server processes to handle the requests of user processes connected to an instance. A server process can be either a dedicated server process, where one server process services only one user process, or it can be a shared server process, where a server process can service multiple user processes. Shared server processes are a part of Oracle Shared Server architecture.
This is a practical guide for developers working with the Oracle Data Provider for .NET (ODP.NET) using VB.NET. From introducing ODP.NET and programming with ODP.NET to application development using ODP.NET and on to discussing Oracle Developer Tools for Visual Studio 2005, this book covers the important aspects of ODP.NET. The book is written for professional .NET developers who need to work with and take full advantage of Oracle Database 10g using Visual Studio 2005. Developers are expected to be familiar with Visual Basic.NET 2005 and have minimum knowledge of Oracle SQL and PL/SQL....
In a two-tier network, a client communicates directly with a server. This is also known as a client-server architecture. A client-server network is an architecture that involves client processes that request services from server processes. The client and server communicate over a network using a given protocol, which must be installed on both the client and the server.
A common error in client-server network development is to prototype an application in a small, two-tier environment and then scale up by adding more users to the server.