Oracle9i Network Administration

This 3-day course uncovers the mystery of the Oracle database middleware contained within Oracle Net / SQL*Net. All of the configuration files are considered along with their contents and how these can be customized. The Oracle Net assistant is also covered and this tool is used for multi-threaded server configuration of the database, activating the Oracle Names Server and the Oracle Connection Manager. On course completion, students will be able to:

• Configure a distributed Oracle Net and SQL*Net environment
• Use the Oracle Net Assistant for simple and complex configurations
• Place the database in multi-threaded server mode
• Incorporate the Oracle Names Server and Connection Manager into the environment

Target audience

This course has been developed for Oracle database administrators. Students should have attended the following courses or have equivalent knowledge and experience:

• Introduction To Oracle9i: SQL
• Introduction To Oracle9i: PL/SQL Language
• Introduction To Oracle9i: Advanced SQL
• Oracle9i Database Administration (DBA I)
• Oracle9i Database Backup & Recovery (DBA II)
• Oracle9i Database Performance Tuning

Course content

Understanding Oracle Net

Oracle Net environment What is a distributed database?

Oracle Net Server-Side administration The Listener

Oracle Net Client-Side administration Configuring client parameters

Oracle names server Configuration, file system registration • Configuration, database registration • Names server administration

Oracle intelligent agent

Shared server connections Configuration of shared server mode • Oracle 9i version information

Oracle connection manager

Directory Configuration requirements • Oracle Net services

Troubleshooting the network Isolating the problem • Network troubleshooting utilities

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today