Workshop doc
Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (94.34 KB, 11 trang )
19
Copyright © Oracle Corporation, 2002. All rights reserved.
Workshop
19-2
Copyright © Oracle Corporation, 2002. All rights reserved.
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
19-3
Copyright © Oracle Corporation, 2002. All rights reserved.
Objectives
•
Enable and use trace output for troubleshooting
•
Identify and troubleshoot:
–
Listener problems
–
Client configuration issues
19-4
Copyright © Oracle Corporation, 2002. All rights reserved.
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
19-6
Copyright © Oracle Corporation, 2002. All rights reserved.
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
19-7
Copyright © Oracle Corporation, 2002. All rights reserved.
Business Requirements
•
Twenty-four hour availability
•
Peak usage varies across all time zones
•
Daily backups are required
•
Complete database recovery is required
19-8
Copyright © Oracle Corporation, 2002. All rights reserved.
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
19-10
Copyright © Oracle Corporation, 2002. All rights reserved.
Resolving a Network Failure
•
Use OS utilities like ping and telnet to test network
connectivity.
•
Use Oracle Net utilities to test service
connectivity.
•
Check log files initially to diagnose problems.
•
Use tracing only when needed.
•
Trim the trace files regularly because of their
potential growth.
19-11
Copyright © Oracle Corporation, 2002. All rights reserved.
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)
19-12
Copyright © Oracle Corporation, 2002. All rights reserved.
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
19-14
Copyright © Oracle Corporation, 2002. All rights reserved.
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
