1 / 20

Basic Oracle Net Server-Side Configuration

Basic Oracle Net Server-Side Configuration. 3. Supinfo Oracle Lab. Objectives. After completing this lesson, you should be able to do the following: Identify how the listener responds to incoming connections Configure the listener using Oracle Net Manager

zandra
Download Presentation

Basic Oracle Net Server-Side Configuration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Basic Oracle Net Server-Side Configuration 3 Supinfo Oracle Lab.

  2. Objectives After completing this lesson, you should be able to do the following: • Identify how the listener responds to incoming connections • Configure the listener using Oracle Net Manager • Control the listener using the Listener Control Utility (lsnrctl)Describe Dynamic Service Registration • Configure the listener for IIOP and HTTP connections

  3. Overview: The Listener Process Client Server Listener tnsnames.ora sqlnet.ora listener.ora

  4. The Listener Responses When a connection request is made by a client to a server, the listener performs one of the following: • Spawns a server process and passes the connection to it • Hands off the connection to a dispatcher or server process in an Oracle Shared Server configuration • Redirects the connection to a dispatcher or server process

  5. Configuring the Listener The listener can be configured in two ways: • Static service configuration • Used for Oracle8 and earlier releases • Requires LISTENER.ORA configuration • Required for Oracle Enterprise Manager and other services • Dynamic service registration • Does not require a LISTENER.ORA file • The listener relies on the PMON process • Oracle9i uses service registration

  6. Client Spawned server process Server 5 4 3 2 1 listener Bequeath Session

  7. Client Server Server or dispatcher process 6 5 3 port 4 2 port 1 Listener Redirect Session

  8. Static Service Registration:The listener.ora File When the Oracle software is installed, the listener.ora file is created for the starter database with the following default settings: • Listener name LISTENER • Port 1521 • Protocols TCP/IP and IPC • SID name Default instance • Host name Default host name

  9. Static Service Registration: The listener.ora File • 1. LISTENER = • 2. (ADDRESS_LIST = • 3. (ADDRESS= (PROTOCOL= TCP)(Host= stc-sun02)(Port= 1521)) • ) • 4. SID_LIST_LISTENER = • 5. (SID_LIST = • 6. (SID_DESC = • 7. (ORACLE_HOME= /home/oracle) • (GLOBAL_DBNAME = ORCL.us.oracle.com) • 9. (SID_NAME = ORCL) • ) • 10. ...sample additional SID description ... • )

  10. Static Service Registration: Create a Listener

  11. Configure Services

  12. Logging and Tracing

  13. Dynamic Service Registration:Configure Registration To ensure that service registration is functional, the following INIT.ORA parameters must be configured: • SERVICE_NAMES • INSTANCE_NAME

  14. Dynamic Service Registration:Configure PMON • By default, PMON registers with a local listener on the server with the following settings: • Listener name LISTENER • Port 1521 • Protocols TCP/IP • SID name Default instance • Host name Default host name • PMON can register with a non default listener if: • LOCAL_LISTENER parameter is defined in INIT.ORA • DISPATCHERS parameter (For Shared Server) is defined in INIT.ORA

  15. Configure the Listener for Oracle9i JVM: IIOP and HTTP The listener can be configured to accept connections from clients using IIOP and HTTP under the following conditions: • Use Static Listener Registration if Oracle8i or earlier database is used, even if Oracle9i listener is used • If both the listener and the database are release 9.0, configuration occurs dynamically during service registration

  16. Listener Control Utility (LSNRCTL) Commands from the Listener Control utility can be issued from the command-line or from the LSNRCTL prompt. • UNIX command-line syntax: • Prompt syntax: • Control a non-default listener $ lsnrctl <command name> LSNRCTL> <command name> LSNRCTL> set current_listener listener02

  17. LSNRCTL Commands Use the following commands to control the listener: • START [listener_name] • STOP [listener_name]

  18. LSNRCTL SET and SHOW Modifiers The SET modifier is used to change listener parameters in the Listener Control utility environment. The SHOW modifier is used to display the values of the parameters set for the listener. LSNRCTL> SET trc_level ADMIN LSNRCTL> SHOW connect_timeout

  19. Summary In this lesson, you should have learned how to: • Describe how the listener handles client connection requests • What role the listener.ora file plays in configuring the listener • Use the lsnrctl utility to control the functions of the listener • Configure the listener for IIOP and HTTP connections

  20. Practice 3 Overview This practice covers the following topics: • Configuring a non-default LISTENER • Starting and stopping your listener • Viewing the LISTENER log file

More Related