Manual Network Configuration
by Brian Laskey, David C. Kreines
Oracle Database Administration: The Essential Refe
- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
Manual Network Configuration
While Network Manager provides a relatively easy way to create and modify Oracle network parameter files, many DBAs find it useful to occasionally (and some more than occasionally) make manual modifications to one or more of these files. Such a practice, while not approved by Oracle, is acceptable as long as:
The DBA is knowledgeable about the parameters being modified.
The structure of the file is maintained.
The change is made with an appropriate editor that saves plain text (ASCII in most cases). Avoid word processors, which usually store other control characters with the text.
Backup copies are made of the files being changed—just in case!
Warning
Oracle Corporation states in their documentation that they will not support any Oracle network that has not been configured using Network Manager or Net8 Assistant. To our knowledge, Oracle has never withheld support. However, be cautious when making manual changes, and be aware that Oracle Support may take exception to the practice.
-
No Comment