RelationalDBDesign
SiteMap
Network Config
Network Admin
Network Topology
Logging | Tracing
« Prev
Next »
Intro Network Configuration
Internet Directory
Directory Naming
Oracle Name Resolution
Storing Network Configuration
Configure Intelligent Agent
Overview Enterprise Manager
OEM Console Screens
Oracle Agents Overview
Communicating Event Manager
OEM Agents Remote Servers
Start Stop Agents
Configuring OEM Agent
OEM Intelligent Agent
Customizing Oracle Alerts
OEM Conclusion
Shared Server
Shared Server Listener
Listener Manage SS Connections
Configure init.ora Parameters
Incoming Connections
Shared Architecture Elements
Configure Server
init.ora Parameter Initialization
Configuring Oracle Dispatchers
Remaining Dispatcher Parameters
Configure Load Balancing
Connection Pools
Oracle Connection Pooling
Monitor Server Connections
Identify Contention V$DISPATCHER View
Identify Contention Using V$QUEUE View
Server Configuration Conclusion
Connection Manager
Connection Manager Programs
Connection Manager Features
Function cman.ora file
Connection Concentration cman
Network Access Control
CMCTL Control Utility
Start/Stop Connection Manager
SQL multi Protocol Functionality
CMan Conclusion
Logging Tracing
Oracle Tracing Parameters
Log Location Trace Files - Exercise
Log and trace parameters
Objective:
Describe the use of log and trace parameters. Identify the location of log and trace files on any Oracle server results.
Exercise scoring
This exercise is worth a total of 10 points. To receive full credit, you must identify each of the steps required to diagnose this problem outlined below, and describe what you are looking for in each step.
Background
You have received a call from a disgruntled user who claims he cannot connect to his Oracle database. As the DBA, you know that you have enabled logging on both the client and the server, but you have forgotten the files names and locations. You check the server log file and discover that there is no evidence that the client ever established a connection to the Oracle listener on the server. There are no other complaints about connections, and there are new connections being established each minute. After visiting the Oracle client PC, you see only a generic
failure to connect
message.
Instructions
In the text box below, describe the actions that you would take to obtain the information you need to fix this problem. Then click the
Submit
button to submit your response and view a results page.