(Les06 Networking) [1, 20180210], les0620180210

(Les06 Networking) [1, 20180210], les0620180210
Objective: To learn how to use Enterprise Manager to perform operations-create other listeners-create an Oracle Net service alias-configure failover during connection-control the Oracle Net Listener using tnsping to test the connection of Oracle Net to determine when to use the sharing server and when to use the dedicated server Oracle Database Net Services Administrator's Guide Oracle Database Net Services Reference Oracle Net service client or the middle layer to create a connection between the two Oracle servers, and is responsible for information exchange. Client or intermediate layer (application <--> Oracle Net) --- TCP/IP --- (listener) --- database (RDBMS <--> Oracle Net) the most common usage of the Oracle Net service in the Oracle Net configuration file is to pass in database connections. By configuring other network services, you can access the external code library (EXTPROC) and connect Oracle instances to non-Oracle data sources (Sybase, Informix, DB2, and SQL Server) through Oracle heterogeneous services) the Oracle Net Listener connects all non-local users to the gateway of the Oracle instance. A single listener can be used to connect multiple database instances and thousands of clients. After installing Grid Infrastructure, the Oracle Net Listener starts from its software installation directory <Grid_home>. To establish a network connection to Oracle Net, consider the following: -host running the listener-listener listening port-protocol used by the listener-service name processed by the listener Oracle Net name resolution after the connection Oracle Net name is resolved, the connection request is sent to the listener. The listener receives a CONNECT packet and checks whether the Oracle Net service name of the request packet is valid. When a user requests a valid service name for session CONNECT packets, the listener derives a "server process ". The listener will connect to the process and pass the initialization information, user process address information. At this time, the listener no longer processes connections, and all work will be handled by the server process. The server process first checks the user's identity (password), and creates a user session if it is valid. Dedicated server process-performs syntax analysis on all SQL statements sent by applications, then run-search for the data blocks required to execute SQL statements in the database buffer cache-read the necessary data blocks from the data files on the disk to the system global zone (SGA) in the database buffer cache section (if the data blocks are not in SGA)-manage all sort activities. The sorting area is the memory area used to process sorting; it is included in the memory area associated with the program global area (PGA. -Return the structure to the user process, so that the application can process this information-read audit options and report the user process to the audit target configuration and manage the Oracle Network tool Enterprise Manager's "Net Services Administration Network Service Management" provides configuration and Oracle Net Manager, an integrated environment for managing Oracle Net Services, provides a graphical user interface (GUI ), you can configure the Oracle Net service for the Oracle Home directory on the local client or server host. Network component-command: defines simple names and connection identifiers, and maps them to the connection descriptor to determine the network location and service identifier. Oracle Net Manager supports native tnsnames. configure the connection descriptor in the ora file or centralized directory service-command method: Configure different methods for parsing the connection identifier to the connection descriptor-profile: configure the preference-listener used to enable and configure the Oracle Net function on the client or server: create and configure a listener to receive clients to connect to Oracle Net Configuration Assistant when installing Oracle software, start Oracle Net Configuration Assistant through Oracle Universal Installer. The command line listener uses the lsnrctl command line to control the Oracle Net Listener $ lsnrctl LSNRCTL> help lsnrctl to do the following: -Start the listener-stop the listener-check the listener status-initialize the listener Based on the configuration file parameters-dynamically configure multiple listeners-change the basic command syntax of the listener password LSNRCTL> command [listener_name] command line Syntax: $ lsnrctl <command name> $ lsnrctl start $ lsnrctl stop $ lsnrctl status prompt Syntax: LSNRCTL> <command name> LSNRCTL> start LSNRCTL> THE status command Line syntax is usually used to execute a single command or script command. If you plan to execute several consecutive lsnrctl commands, the prompt syntax is more efficient. If the listener is protected by a password, you must use the prompt syntax. Use SRVCTL to start and stop any listener managed by Oracle restart. You can use srvctl to start/stop the listener and view its status. -Srvctl-h-srvctl start listener-srvctl stop listener-srvctl start listener-l mylistener-srvctl status listener homepage-listener status and availability-listener in the last 24 hours version and Oracle main directory-the first listening address of the listener-location of the configuration file used to start the listener-listener startup time and host information-Oracle restart status Net Services Administratrion (Network service Management) page-listeners: add, delete, start, and stop listeners, and modify their tracking and event record features. You can also query the monitoring program's control status report. -Directory name: You can define simple names and connection identifiers, and map the defined content to the connection descriptor to determine the network location and Service Identity. Store database services, Oracle Net Services, and Oracle Net service aliases in a centralized directory service. -Local name: store the Oracle Net service name in tnsnames. in the ora file-profile: Configure sqlnet. ora parameter-File Location: change the location of the Oracle Net service configuration file database service registration-dynamic service registration: oracle8i and later instances automatically register with the default listener when starting the database. -Static Service Registration: earlier versions of Oracle DB are not automatically registered with the listener. Therefore, the Listener Configuration File must contain a list, it contains all the database services that the listener provides services. Static service registration. Application Scenario:-The Listener port is not the default port 1521.-static service registration is required for the application.-service name: the SERVICE_NAMES initialization parameter specifies one or more names that the client can use to connect to the instance. The instance registers its service name with the listener. SERVICE_NAMES = sales.example.com, eurosales.example.com naming method Oracle Net supports multiple methods for parsing connection information:-simple connection name: CONNECT username/password @ host using a TCP/CP connection string [: port] [/service_name]-This mode is enabled by default-no client configuration is required-only TCP/IP (no SSL) is supported-advanced connection options are not supported (for example: -Local name: Use the local configuration file to connect the descriptor stored in the client tnsnames. ora local configuration file-client name resolution file required-support for all Oracle Net protocols-Support for advanced connection options (such as failover during connection, source routing, and load balancing) -directory naming: Use the LDAP-compliant centralized directory server-the LDAP-Oracle I Nternet Directory-Microsoft Active Directory Services-support for all Oracle Net protocols-Support for advanced connection options-External naming: Use the supported non-Oracle Naming Service. In concept, external naming is similar to directory naming. -Use the supported non-Oracle Naming Service-including-Network Information Service (NIS) External naming-distributed computing environment (DCE) unit Directory Service (CDS) advanced connection option local name and directory name, advanced connection options supported by Oracle Net-failover Upon Connection-source routing-Server Load balancer test Oracle Net connection-Ensure the connection between the client and the Oracle Net Listener-do not verify the requested service available or not-Support Simple connection name parsing tnsping host01.example.com: 1521/orcl-supports local naming and directory naming tnsping orcl user sessions: dedicated server processes. The ratio of server processes to users is one to one. Each server process uses system resources, including CPU and memory. The data requirements of the dedicated server architecture have a negative impact on the system. You need to:-use the Oracle Shared Server process architecture to share server processes by adding more memory and additional CPUs, each service that participates in the Shared Server process architecture has at least one (usually multiple) distributed program process. Unlike dedicated server processes, a single dispatcher can manage hundreds of user sessions. The sharing server process takes over most of the work of the dedicated server process, but transmits user requests to the public queue located in the SGA sharing pool. Some memory structures of user sessions stored in PGA are also migrated to the shared memory location (the Shared Pool is used by default. If a large pool is configured, it is in a large pool) when SGA and PGA use dedicated servers or shared servers, the memory of SGA and PGA is different:-text and syntax analysis of all SQL statements is stored in SGA. -The cursor status contains the runtime memory value of the SQL statement, for example, the retrieved row-user session database contains security and resource usage information. -The stack space contains the local variable SGA of the process to allocate data space for each session. You can use the PRIVATE_SGA resource limit parameter to limit the amount of space that can be allocated for each session. Shared servers cannot be used-Database Management-backup and recovery operations-batch processing and batch loading operations-data warehouse operations