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
Monitor Shared Server
Connection Manager
Connection Manager Programs
Connection Manager Features
Function cman.ora file
Connection Concentration cman
Network Access Control
Start/Stop Connection Manager
SQL multi Protocol Functionality
Logging Tracing
Oracle Tracing Parameters
Oracle Logging and Tracing - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
What is the first thing that you should do when an end-user cannot connect to a server?
Please select the best answer.
A.
Check the local tnsnames.ora file.
B.
Look up the error number provided to the end-user.
C.
Try to ping the server.
D.
Check the listener.
2.
Which of the following statements is true about ADMIN and SUPPORT level trace files?
Please select the best answer.
A.
Trace files are automatically generated and are very useful for diagnosing common connection problems.
B.
Trace files are relatively small and can be kept as a record of Net8 connections.
C.
Trace files are very useful ONLY if Oracle auditing is also used.
D.
Trace files are large and space consuming and should only be used in rare cases.
3.
You receive a report from dozens of end-users, all complaining that they cannot connect to the server. What log file should you check first?
Please select the best answer.
A.
sqlnet.log
B.
listener.log
C.
tnsnames.log
D.
alert.log
4.
Which of the following trace component can be started without re-starting the database or the listener?
Please select the best answer.
A.
listener trace
B.
server trace
C.
sqlnet trace
D.
names trace
5.
Which of the following level parameters for Oracle tracing will provide the highest level of detail about a connection?
Please select the best answer.
A.
USER
B.
ADMIN
C.
OFF
D.
TRACE
6.
You have forgotten the location of your listener log files. Which of the following commands represents the best way to determine their location?
Please select the best answer.
A.
Server manager show parameters dump
B.
Run tnsping
C.
Run the "lsnrctl stat" command
D.
Check tnsnames.ora