第三讲 Oracle网络服务及管理工具.pptVIP

专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 专注、专业、创新、共赢 * 第三讲 Oracle网络服务及管理工具 本章目标 * Listener * Listener Continue * A listener process can listen for more than one database Multiple listeners can listen on behalf of a single database to perform load balancing The listener can listen for multiple protocols The default name of the listener in Oracle Net is LISTENER The name of the listener must be unique per listener.ora file Connection Methods * Spawn and Bequeath Connections * Spawn and Bequeath Connections * 1. The listener receives a client connection request. 2. The listener starts a dedicated server process, and the dedicated server inherits the connection request from the listener. 3. The client is now connected directly to the dedicated server. If, because of the operating system or protocol, a connection cannot be passed between two different processes on the same machine, a redirect must take place instead. Note: When a client disconnects, the clients’ dedicated server process closes. Direct Hand-Off Connections * Direct Hand-Off Connections * 1. The listener receives a client connection request. 2. The listener hands the connect request directly to the dispatcher. 3. The client is now connected to the dispatcher. Redirected Session * Redirected Session * 1. The client establishes a connection to the listener by using the configured protocol and sends the listener a connect packet. 2. The listener checks that the SID is defined. If it is, the listener will spawn a new thread or process to service the new connection. An IPC connection is then established between the listener and the new process or thread. 3. The new process or thread selects a new TCP/IP port from the list of free user-defined ports and passes this information back to the listener. 4. The listener inserts this new port into a redirect packet and sends it back to the clie