DBAII_R1_1_Les19_E

Workshop : 

Workshop

Objectives : 

Objectives After completing this lesson, you should be able to do the following: Document a database configuration by using the Database Configuration Worksheet Configure an Oracle9i database to support stated business requirements Recover a failed database while minimizing down time and data loss

Objectives : 

Objectives Enable and use trace output for troubleshooting Identify and troubleshoot: Listener problems Client configuration issues

Workshop Methodology : 

Workshop Methodology Group-oriented and interactive Intensive hands-on diagnosis and problem resolution Variety of failure scenarios Recovery solutions Variety of configuration errors Develop troubleshooting skills

Workshop Approach : 

Workshop Approach Physical investigation: Use views and tools to derive information View trace files and log files View command output and log files Use views and tools to confirm proper database configuration Database configuration: Archiving is enabled Control files and log files are mirrored Control file is backed up

Business Requirements : 

Business Requirements Twenty-four hour availability Peak usage varies across all time zones Daily backups are required Complete database recovery is required

Resolving a Database Failure : 

Resolving a Database Failure Phase I: Diagnose the problem Phase II: Restore appropriate files Phase III: Recover the database Phase IV: Back up the database

Resolving a Network Failure : 

Resolving a Network Failure Use OS utilities like ping and telnet to test network connectivity Use Oracle Net utilities like tnsping to test service connectivity Check log files initially to diagnose problems Use trace files to get detailed information Use tracing sparingly and trim the trace files regularly because of their potential for rapid growth

Enable Tracing : 

Enable Tracing Oracle Net Manager Edit sqlnet.ora file TRACE_DIRECTORY_CLIENT = /u01/user01/NETWORK/LOG NAMES.DEFAULT_DOMAIN = us.oracle.com TRACE_UNIQUE_CLIENT = on TRACE_FILE_CLIENT = client.trc TRACE_LEVEL_CLIENT = SUPPORT NAMES.DIRECTORY_PATH= (TNSNAMES)

Using Trace Files : 

Using Trace Files Trace files will give you a better understanding of: The flow of packets between network nodes Which component of Oracle Net is failing Pertinent error codes

Summary : 

Summary Instructor-facilitated workshop Group-oriented Hands-on approach Simulated “real-world” environment Minimize down time and data loss Use tools and diagnostics to determine the type of failure

Practice 19 : 

Practice 19