Oracle network server configuration

Oracle network perimeter Configuration

Supports three application connections
C/S application connection: sqlplus sys/x2145637 @ orcl
Java application connection
Web client application connection

Supported protocols
TCP/IP
TCP/IP with SSL
Named pipes
SDP

Oracle provides two java drivers
1. jdbc OCI Driver: encapsulate oracle OCI (oracle call interface)
2. JDBC Thin Driver: rewrite the underlying protocol using java

Concepts and terms
Service name: service name, which is equal to global_names = db_name + db_domain.
Connect descriptor: IP address and service name.
Listener: the server must enable the Listener. The Listener accepts the Service Registration Information (service name, Instance name, and service handlers) registered by the PMON process to start a Service handlers process to communicate with it.
Service Registry: register the Service, Service name, Instance name, and network address in listener.
Service handlers: A sub-process derived from a listener process.

PMON registers the service information (instance information) to the listener process (if the listener is not enabled, the pmon process attempts to connect to the listener every 60 s and can be modified through alter system register ), when a user requests a service, the listening process starts the service processor process to communicate with it.

Five naming methods
Host naming: Based on Operating System Analysis
Local naming: tnsnames. ora
Directory naming: Directory service, ldap. ora
Oracle Names
External naming

TNS: transparence Network Substrate Transparent Network bottom layer
To connect to a remote oracle Server, you must configure tnsnames. ora to provide IP addresses, ports, and service names.

Listener process connection method (lsnrctl start listener)
1. derive the child process and pass the TCP descriptor to the child process
2. Pass the TCP connector to the dispatch process configured for the oracle shared service.
3. relocate to a dispatch or service process through different ports

The connection pool has several persistent connections to the database. You can connect to the database immediately.

Two Methods for configuring listener
1. Dynamic Service Registration: pmon dynamically registers service information to listener. The default address is the IP address of PMON, and the port is 1521.
You do not want to use the default settings. You must set the initialization parameter local_listener or define the LISTENERS attribute of the dispatch of the oracle Shared Server.
You only need to configure initialization parameters
1.1 SERVICE_NAMES = global database name = db_name + db_domain
1.2 INSTANCE_NAME
2. Static Service Registration: Modify the information of listener. ora.
The IPC server and client are on the same machine, and the TCP/IP server and client are on different machines.
Graphical interface configuration
2.1. netca
2.2. netmgr

Lsnrctl Utility
Lsnrctl start listener_name
Lsnrctl stop listener_name
You can set some parameters after entering lsnrctl.
Set trc_level ADMIN; tracing level
Show trc_directory; trace file directory