RelationalDBDesign
SiteMap
Network Config
Network Admin
Network Topology
Network Topology
«Prev
Next»
Network Topology
Oracle Certification
Networking Overview
History Oracle Networking
Distributed Database History
Evolution Network Protocols
Oracle Networked Computers
DB Evolution
Distributed Data
Distributed DB Features
Local Autonomy
Fragmentation Independence
Oracle Topology Overview
DB Links Connectivity
Join Tables Remote Sites
TNS
Inter Communication
SQL App Connection
SQL Handles Connections
SQL Net Version 1
SQL Net Enhancements
Distributed DB Connectivity
Networking Conclusion
Net Services Architecture
Net Parameter Files
Network Component Tools
Components Functions tnsnames.ora
protocol.ora File
TCP.NODELAY option
sqlnet.ora File Location
Sqlnet ora File Characteristics
sqlnet.ora-log
Net Communications Process Level
Create Oracle DBlink
Database Link Connection
SQLnet Architecture Conclusion
ServerSide Configuration
sqlnet Client/Server Components
Listener Manages Oracle Connection
Configuring Oracle Listener
Oracle Net Assistant
Net Assistant Naming Methods
Route Client connection Requests
Set TNS Timeout Value
Setting Listener Password
lsnrctl Listener control Utility
Start listener using lsnrctl
Stop Listener via lsnrctl
Setting Up Protocol Listeners
Client side Configuration
Windows Client Architecture
NET Configuration Assistant
Running Oracle Installer
Managing tnsnames.ora File - Exercise
Managing the tnsnames.ora file on a network
Managing Large Installations
Objective:
Describe the importance of a centralized tnsnames.ora file.
Exercise scoring
This exercise is worth a total of 10 points. To receive full credit, you will need to outline in a short paragraph the solution to the problem presented below.
Background
Your CIO has just purchased Oracle Net Services and Oracle for a site that will include1,000+ PCs that will connect remotely to an Oracle database. Part of the rollout will be the installation and configuration of the 1,000 PCs, and the CIO wants you to tell the PC technician what components should be installed and how they will be maintained.
Instructions
Prepare a short paragraph detailing which Oracle Net Services components should be installed (and which components should not be installed), and describe how the PCs will be maintained as the Oracle server environment changes.
Submitting your exercise
Enter your answer into the text box below. Then click the
Submit
button to submit the answer and view a results page.
Submit