Oracle9i Database Administration: Set Up Oracle Net Services

This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

The intended audience for this course are Database administrators. Required prerequisites are Oracle SQL Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311) and Oracle9i Database Administration: Create a Database (64312).

Objective

• Sequence the steps required for a client to establish a connection to an Oracle server.
• Match the client and server network components required to perform specific tasks on a Web application client implementation.
• Identify the features of automatic instance registration.
• Configure a local net service name by using the Oracle Net Configuration Assistant.
• Identify the tasks performed to implement an LDAP Proxy naming method.
• Identify the benefits of using the Oracle Shared Server configuration.

Topics Include

Unit 1: Oracle Net Services Overview

• Identify the features of a two-tier network.
• Identify the services provided by the middle tier in an n-tier network.
• Identify the connectivity issues that must be addressed in an enterprise network environment.
• Identify the connectivity features of Oracle Net Services.
• Identify the directory services features of Oracle Net Services.
• Identify the scalability features of Oracle Net Services.
• Identify the security features of Oracle Net Services.
• Identify the accessibility features of Oracle Net Services.
• Sequence the steps required for a client to establish a connection to an Oracle server.
• Match the client and server network components required to perform specific tasks on a Web application client implementation.

Unit 2: Oracle Net Services Configuration

• Identify the characteristics of a listener.
• Sequence the events that occur in a Bequeath session.
• Sequence the events that occur in a Redirect session to a dispatcher.
• Sequence the steps performed in a direct hand-off of a connection request.
• Create a listener.
• Configure a listener for database services.
• Configure the listener logging and tracing options.
• Control a listener.
• Identify the features of automatic instance registration.
• Identify the benefits of the methods used for client-server connections.
• Identify the requirements for making a connection by using the host-naming method.
• Configure local naming.
• Match key parameters with the client-side files generated by Oracle Net Manager.
• Match the client-side connection errors with their probable solutions.
• Configure a local net service name.

Unit 3: Oracle Names Server

• Match the service name resolution method with its definition.
• Match the Oracle Names directory object with the appropriate definition.
• Identify the features of two domain naming models.
• Sequence the steps involved in discovering a Names server on the network by an Oracle Names client.
• Sequence the events that occur when an Oracle Names client uses its cache to retrieve Names server information.
• Identify two approaches to configuring an Oracle Names server.
• Create a Names server by using the No Region Database option in Oracle Net Manager.
• Start a Names server by using Oracle Net Manager.
• Configure a region database for a Names server by using Oracle Net Manager.
• Add a service name to a Names server by using Oracle Net Manager.
• Delete a Names server by using Oracle Net Manager.
• Identify the functions of the primary NAMESCTL commands.
• Match the additional NAMESCTL commands with their functions.
• Match the NAMESCTL SET modifier commands with their functions.
• Configure the Oracle Names client profile by using Oracle Net Manager.
• Specify the preferred Names server on the Oracle Names client by using Oracle Net Manager.
• Test a Names server by using Oracle Net Manager.
• Identify the features of Oracle Names as an LDAP Proxy server.
• Identify the tasks performed to implement an LDAP Proxy naming method.
• Identify the advanced features of an LDAP Proxy implementation.

Unit 4: Oracle Shared Server

• Match the server configuration method with its description.
• Identify the benefits of using a MultiThreaded server configuration.
• Sequence the steps by which a user process communicates with a dispatcher in a MultiThreaded server environment.
• Sequence the steps by which a dispatcher interacts with a shared server in a MultiThreaded server environment.
• Match the OSS configuration parameter with the appropriate function.
• Match the data dictionary view used to verify OSS setup with the appropriate description.
• Sequence the steps involved in the connection pooling process.
• Identify the MTS_DISPATCHERS parameter that contains the correct attributes to enable connection pooling.

Duration

6

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Oracle9i Database Administration: Create a Database
• Oracle9i Database Administration: Manage an Instance
• Oracle9i Database Administration: Manage Data Storage
• Oracle9i Database Administration: Manage Security
• Oracle9i Database Administration: Manage Storage Structures
• Oracle9i Database Administration: Recover Databases
• Oracle9i Database Administration: Strategies and Backups