This section describes Oracle Net Services, as well as how to start up the database.
Communication protocols define the way that data is transmitted and received on a network. Oracle Net Services supports communications on all major network protocols, including TCP/IP, HTTP, FTP, and WebDAV.
Using Oracle Net Services, application developers do not need to be concerned with supporting network communications in a database application. If a new protocol is used, then the database administrator makes some minor changes, while the application requires no modifications and continues to function.
Oracle Net, a component of Oracle Net Services, enables a network session from a client application to an Oracle database server. Once a network session is established, Oracle Net acts as the data courier for both the client application and the database server. It establishes and maintains the connection between the client application and database server, as well as exchanges messages between them. Oracle Net can perform these jobs because it is located on each computer in the network.
Network Connections
Oracle Net Services is Oracle's mechanism for interfacing with the communication protocols used by the networks that facilitate distributed processing and distributed databases.Communication protocols define the way that data is transmitted and received on a network. Oracle Net Services supports communications on all major network protocols, including TCP/IP, HTTP, FTP, and WebDAV.
Using Oracle Net Services, application developers do not need to be concerned with supporting network communications in a database application. If a new protocol is used, then the database administrator makes some minor changes, while the application requires no modifications and continues to function.
Oracle Net, a component of Oracle Net Services, enables a network session from a client application to an Oracle database server. Once a network session is established, Oracle Net acts as the data courier for both the client application and the database server. It establishes and maintains the connection between the client application and database server, as well as exchanges messages between them. Oracle Net can perform these jobs because it is located on each computer in the network.
Starting Up the Database
The three steps to starting an Oracle database and making it available for systemwide use are:-
Start an instance.
-
Mount the database.
-
Open the database.
STARTUP
statement or Enterprise Manager. When
Oracle starts an instance, it reads the server parameter file (SPFILE)
or initialization parameter file to determine the values of
initialization parameters. Then, it allocates an SGA and creates
background processes.How Oracle Works
The following example describes the most basic level of operations that Oracle performs. This illustrates an Oracle configuration where the user and associated server process are on separate computers (connected through a network).-
An instance has started on the computer running Oracle (often called the host or database server).
-
A computer running an application (a local computer or client workstation) runs the application in a user process. The client application attempts to establish a connection to the server using the proper Oracle Net Services driver.
-
The server is running the proper Oracle Net Services driver. The
server detects the connection request from the application and creates a
dedicated server process on behalf of the user process.
-
The user runs a SQL statement and commits the transaction. For example, the user changes a name in a row of a table.
-
The server process receives the statement and checks the shared pool
for any shared SQL area that contains a similar SQL statement. If a
shared SQL area is found, then the server process checks the user's
access privileges to the requested data, and the previously existing
shared SQL area is used to process the statement. If not, then a new
shared SQL area is allocated for the statement, so it can be parsed and
processed.
-
The server process retrieves any necessary data values from the actual datafile (table) or those stored in the SGA.
-
The server process modifies data in the system global area. The DBWn
process writes modified blocks permanently to disk when doing so is
efficient. Because the transaction is committed, the LGWR process
immediately records the transaction in the redo log file.
-
If the transaction is successful, then the server process sends a
message across the network to the application. If it is not successful,
then an error message is transmitted.
-
Throughout this entire procedure, the other background processes run,
watching for conditions that require intervention. In addition, the
database server manages other users' transactions and prevents
contention between transactions that request the same data.
No comments:
Post a Comment