Book description
Net8 is the fundamental Oracle technology that allows Oracle services and clients to communicate with each other over a network. Net8 is most often used to connect client software to Oracle database servers. It may also be used to connect database servers to one another, allowing communication between distributed databases. This practical guide provides the information that readers, especially database administrators, need to know in order to install configure, tune, and troubleshoot Net8. It discusses how Oracle's network architecture, products, and name resolution methods work, and it provides the details of client and server configuration using a variety of Oracle protocols and networking products, including:
The Oracle Internet Directory (OID), Oracle's implementation of the standard Lightweight Directory Access Protocol (LDAP). This directory can be used to maintain a central repository of net service names that can be referenced by all clients.
Oracle Names, a networking component used mainly in earlier versions of Oracle, that allows net service names to be defined centrally.
Multi-Threaded Server (MTS), an environment in which the client connections share access to a pool of shared server processes.
Oracle Connection Manager, a Net8 component that acts much like a router and provides protocol conversion, connection concentration, and access control.
The book also describes the utilities Oracle provides to help manage a Net8 environment; these include the Listener Control Utility (lsnrctl), the Oracle Names Control Utility (namesctl), the Oracle Connection Manager Control Utility (cmctl), tnsping, and Net8 Assistant. In addition, it provides a variety of networking troubleshooting techniques and commonly encountered Net8 configuration problems, and provides complete syntax for all networking files and commands.
Table of contents
-
Oracle Net8 Configuration and Troubleshooting
- Preface
- I. How Net8 Works
-
II. Net8 Configuration
- 3. Client Configuration
-
4. Basic Server Configuration
- The Overall Process
- Software to Install
- Configuring a Listener
- The Listener Control Utility
- Securing a Listener
- Modifying and Deleting a Listener
- Detecting Dead Connections
- 5. Multi-Threaded Server
- 6. Net8 and LDAP
-
7. Oracle Names
- Configuring a Names Server
- Managing a Names Server
- Discovery and Client Configuration
- Domains and Regions
- 8. Net8 Failover and Load Balancing
- 9. Connection Manager
-
III. Net8 Troubleshooting
- 10. Net8 Troubleshooting Techniques
-
11. Solutions to Common Problems
-
Net8 General Problems
- Net8 Cannot Resolve a Service Name
- Windows Prompts to Make a Dial-up Connection
- Your Firewall Blocks Redirects
- Net8 Assistant Can’t Find Your Configuration Files
- You Get an ORA-12545 Error While Trying to Connect
- You Don’t Get a Trace File When You Ask for One
- You Want to Change the Session Data Unit Size
- You Get an ORA-12538 Error When Trying to Connect
- Instance Registers with Wrong Listener
- Net Service Name Doesn’t Work with Enterprise Manager
- Net8 Easy Config Complains About Corrupt Files
- You Have an Unwanted Listener Service in Windows NT
- Developer 2000 Won’t Connect to Personal Oracle
- Connection Manager Problems
- Multi-Threaded Server Problems
- Oracle Names Problems
-
Net8 General Problems
-
IV. Appendixes
-
A. The sqlnet.ora File
- BEQUEATH_DETACH
- DAEMON.TRACE_DIRECTORY
- DAEMON.TRACE_LEVEL
- DAEMON.TRACE_MASK
- DISABLE_OOB
- LOG_DIRECTORY_CLIENT
- LOG_DIRECTORY_SERVER
- LOG_FILE_CLIENT
- LOG_FILE_SERVER
- NAMES.DCE.PREFIX
- NAMES.DEFAULT_DOMAIN
- NAMES.DIRECTORY_PATH
- NAMES.INITIAL_RETRY_TIMEOUT
- NAMES.MAX_OPEN_CONNECTIONS
- NAMES.MESSAGE_POOL_START_SIZE
- NAMES.NIS.META_MAP
- NAMES.PREFERRED_SERVERS
- NAMES.REQUEST_RETRIES
- NAMESCTL.INTERNAL_ENCRYPT_PASSWORD
- NAMESCTL.INTERNAL_USE
- NAMESCTL.NO_INITIAL_SERVER
- NAMESCTL.NOCONFIRM
- NAMESCTL.SERVER_PASSWORD
- NAMESCTL.TRACE_DIRECTORY
- NAMESCTL.TRACE_FILE
- NAMESCTL.TRACE_LEVEL
- NAMESCTL.TRACE_UNIQUE
- OSS.SOURCE.LOCATION
- OSS.SOURCE.MY_WALLET
- SQLNET.AUTHENTICATION_KERBEROS5_SERVICE
- SQLNET.AUTHENTICATION_SERVICES
- SQLNET.AUTHENTICATION_GSSAPI_SERVICE
- SQLNET.CLIENT_REGISTRATION
- SQLNET.CRYPTO_CHECKSUM_CLIENT
- SQLNET.CRYPTO_CHECKSUM_SERVER
- SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT
- SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER
- SQLNET.CRYPTO_SEED
- SQLNET.ENCRYPTION_CLIENT
- SQLNET.ENCRYPTION_SERVER
- SQLNET.ENCRYPTION_TYPES_CLIENT
- SQLNET.ENCRYPTION_TYPES_SERVER
- SQLNET.EXPIRE_TIME
- SQLNET.INDENTIX_FINGERPRINT_DATABASE
- SQLNET.IDENTIX_FINGERPRINT_DATABASE_PASSWORD
- SQLNET.INDENTIX_FINGERPRINT_DATABASE_USER
- SQLNET.IDENTIX_FINGERPRINT_METHOD
- SQLNET.KERBEROS5_CC_NAME
- SQLNET.KERBEROS5_CLOCKSKEW
- SQLNET.KERBEROS5_CONF
- SQLNET.KERBEROS5_KEYTAB
- SQLNET.KERBEROS5_REALMS
- SQLNET.RADIUS_ALTERNATE
- SQLNET.RADIUS_ALTERNATE_PORT
- SQLNET.RADIUS_ALTERNATE_RETRIES
- SQLNET.RADIUS_ALTERNATE_TIMEOUT
- SQLNET.RADIUS_AUTHENTICATION
- SQLNET.RADIUS_AUTHENTICATION_INTERFACE
- SQLNET.RADIUS_AUTHENTICATION_PORT
- SQLNET.RADIUS_AUTHENTICATION_RETRIES
- SQLNET.RADIUS_AUTHENTICATION_TIMEOUT
- SQLNET.RADIUS_CHALLENGE_KEYWORD
- SQLNET.RADIUS_CHALLENGE_RESPONSE
- SQLNET.RADIUS_CLASSPATH
- SQLNET.RADIUS_SECRET
- SQLNET.RADIUS_SEND_ACCOUNTING
- SSL_CIPHER_SUITES
- SSL_CLIENT_AUTHENTICATION
- SSL_VERSION
- TNSPING.TRACE_DIRECTORY
- TNSPING.TRACE_LEVEL
- TRACE_DIRECTORY_CLIENT
- TRACE_DIRECTORY_SERVER
- TRACE_FILE_CLIENT
- TRACE_FILE_SERVER
- TRACE_LEVEL_CLIENT
- TRACE_LEVEL_SERVER
- TRACE_UNIQUE_CLIENT
- USE_CMAN
- USE_DEDICATED_SERVER
- B. The tnsnames.ora File
-
C. The listener.ora File
- Listener Addresses
- Static Services
-
Control Parameters
- CONNECT_TIMEOUT_listener_name
- LOG_DIRECTORY_listener_name
- LOG_FILE_listener_name
- LOGGING_listener_name
- PASSWORDS_listener_name
- SAVE_CONFIG_ON_STOP_listener_name
- STARTUP_WAIT_TIME_listener_name
- TRACE_DIRECTORY_listener_name
- TRACE_FILE_listener_name
- TRACE_FILELEN_listener_name (new in Oracle8i )
- TRACE_FILENO_listener_name (new in Oracle8i )
- TRACE_LEVEL_listener_name
- TRACE_TIMESTAMP_listener_name (new in Oracle8i )
- USE_PLUG_AND_PLAY_listener_name
-
D. The names.ora File
- NAMES.ADDRESSES
- NAMES.ADMIN_REGION
- NAMES.AUTHORITY_REQUIRED
- NAMES.AUTO_REFRESH_EXPIRE
- NAMES.AUTO_REFRESH_RETRY
- NAMES.CACHE_CHECKPOINT_FILE
- NAMES.CACHE_CHECKPOINT_INTERVAL
- NAMES.CONFIG_CHECKPOINT_FILE
- NAMES.CONNECT_TIMEOUT
- NAMES.DEFAULT_FORWARDERS
- NAMES.DEFAULT_FORWARDERS_ONLY
- NAMES.DOMAIN_HINTS
- NAMES.DOMAINS
- NAMES.FORWARDING_AVAILABLE
- NAMES.FORWARDING_DESIRED
- NAMES.KEEP_DB_OPEN
- NAMES.LOG_DIRECTORY
- NAMES.LOG_FILE
- NAMES.LOG_STATS_INTERVAL
- NAMES.LOG_UNIQUE
- NAMES.MAX_OPEN_CONNECTIONS
- NAMES.MAX_REFORWARDS
- NAMES.MESSAGE_POOL_START_SIZE
- NAMES.NO_MODIFY_REQUESTS
- NAMES.NO_REGION_DATABASE
- NAMES.PASSWORD
- NAMES.REGION_CHECKPOINT_FILE
- NAMES.RESET_STATS_INTERVAL
- NAMES.SAVE_CONFIG_ON_STOP
- NAMES.SERVER_NAME
- NAMES.TRACE_DIRECTORY
- NAMES.TRACE_FILE
- NAMES.TRACE_FUNC
- NAMES.TRACE_LEVEL
- NAMES.TRACE_UNIQUE
- E. Environment and Registry Variables
- F. MTS Initialization Parameters
- G. MTS Performance Views
-
A. The sqlnet.ora File
- Index
- Colophon
Product information
- Title: Oracle Net8 Configuration and Troubleshooting
- Author(s):
- Release date: December 2000
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565927537
You might also like
book
Pro Oracle Database 11g RAC on Linux
Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters …
book
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition
The second edition of O'Reilly's bestselling Oracle Essentials has been updated to include the latest Oracle …
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control
This practical Oracle Press guide teaches cutting-edge techniques for building, configuring, and managing a secure private …