Chapter 6 Configuring the Oracle Network Environment

Configure and Manage the Oracle Network
Oracle Net (previously known as Sqlnet)

Establishing a Session
user process -> server process through Oracle Net

Launching a Server Process
Database Listener monitor incoming connection requests and launch new server process to service the user process. (dedicated server)

Database Registration
Static Registration in listener.ora
Dynamic Instance Registration by PMON
local_listener
instance_name
service_names
domain_db

alter system set local_listener=list2;
alter system set service_names=serv1;
alter system register;

Techniques for Name Resolution
Easy Connect: connect user/password@hostname:1521/instance_name or service_name
Local Naming: tnsnames.ora (protocol, host, port, service_name/sid)
Directory Naming and External Naming

Configuring Service Aliases
Profile: sqlnet.ora (define name resolution method: TNSNAMES,EZCONNECT(HOSTNAME))
Service Naming: tnsnames.ora (client/server file)
Listeners: listener.ora (server file)
TNSADMIN Environment Variable

Use the Oracle Shared Server Architecture (ideal for many sessions of short transactions)

dispatcher handle multiple user processes.

dispatchers (put SQL in common queue, fetch result in own response queue back to the user process)
shared_server (get SQL from common queue, put result in response queue)

Memory used by shared server session is user global area, UGA. (SGA's large pool)