1 / 19

Chapter 14 Client-Side Configuration

Chapter 14 Client-Side Configuration. Chapter Objectives. List the different name resolution methods available Identify the purpose of the Sqlnet.ora and Tnsnames.ora files Modify the contents of the Sqlnet.ora file Modify the contents of the Tnsnames.ora file

della
Download Presentation

Chapter 14 Client-Side Configuration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 14Client-Side Configuration Oracle9i DBA II: Backup/Recovery and Network Administration

  2. Chapter Objectives • List the different name resolution methods available • Identify the purpose of the Sqlnet.ora and Tnsnames.ora files • Modify the contents of the Sqlnet.ora file • Modify the contents of the Tnsnames.ora file • Perform basic troubleshooting operations Oracle9i DBA II: Backup/Recovery and Network Administration

  3. Name Resolution Methods • Resolves net service name with connect descriptor • Three popular resolution methods: • Host naming: simplest • Directory naming: uses LPAD-compliant server • Local naming: requires TNSNAMES.ORA file on client machine Oracle9i DBA II: Backup/Recovery and Network Administration

  4. Name Resolution Procedure Oracle9i DBA II: Backup/Recovery and Network Administration

  5. Host Naming • Accesses network HOSTS file • Requirements: • TCP/IP network protocol • No advanced networking features • GLOBAL_DBNAME must be the host name • HOSTS file or external naming service Oracle9i DBA II: Backup/Recovery and Network Administration

  6. Directory Naming • Uses centralized directory server to store name resolution information • Similar to use of a DNS • Requires directory server to be LDAP complaint Oracle9i DBA II: Backup/Recovery and Network Administration

  7. Local Naming • Easy to implement • Reduces network traffic • Requires copy of TNSNAMES.ORA file on each client • File can be created through Net Manager, Net Configuration Assistant or manually with text editor Oracle9i DBA II: Backup/Recovery and Network Administration

  8. Naming Method Advantages and Disadvantages Oracle9i DBA II: Backup/Recovery and Network Administration

  9. Name Resolution Order • Specified by NAMES.DIRECTORY_PATH parameter in SQLNET.ORA file • Default resolution order: • Local naming • Oracle Name Server • Host naming Oracle9i DBA II: Backup/Recovery and Network Administration

  10. Example SQLNET.ORA File Oracle9i DBA II: Backup/Recovery and Network Administration

  11. Changing SQLNET.ORA Contents Through Oracle Net Manager Oracle9i DBA II: Backup/Recovery and Network Administration

  12. Contents of the TNSNAMES.ORA File Oracle9i DBA II: Backup/Recovery and Network Administration

  13. Troubleshooting Network Connections • Use to determine location of error • Methods include a variety of utilities and approaches • Oracle Net Configuration Assistant: tests configuration of TNSNAMES.ORA file • TNSPING utility: determines if listener is reachable • PING utility: tests network connection Oracle9i DBA II: Backup/Recovery and Network Administration

  14. Oracle Net Configuration Assistant Example Oracle9i DBA II: Backup/Recovery and Network Administration

  15. TNSPING Utility Example Oracle9i DBA II: Backup/Recovery and Network Administration

  16. PING Utility Example Oracle9i DBA II: Backup/Recovery and Network Administration

  17. Chapter Summary • Client needs listener contact information • Common name resolution methods include host naming, directory naming, and local naming • Host naming uses a HOSTS file or a Domain Name Server (DNS) Oracle9i DBA II: Backup/Recovery and Network Administration

  18. Chapter Summary (Cont.) • Directory naming references an LDAP-compliant directory server. • Local naming requires Tnsnames.ora file • Tnsnames.ors file can be created (and edited) manually by the DBA, through Net Manager, or Net Configuration Assistant • Advantage of local naming – no network traffic generated during name resolution Oracle9i DBA II: Backup/Recovery and Network Administration

  19. Chapter Summary (Cont.) • Advantage of host or directory naming methods – centralized location • Name resolution order specified by Sqlnet.ora file • TNSPING utility used to locate listener • PING utility verifies database machine can be reached Oracle9i DBA II: Backup/Recovery and Network Administration

More Related