Title:
Oracle9i for windows handbook
Personal Author:
Publication Information:
New York, NY : McGraw-Hill /Osborne , 2002
ISBN:
9780072190922
General Note:
"Run Oracle9i on Windows NT, Windows 2000, and Windows XP Professional"--Cover
Added Author:
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010020254 | QA76.9.D3 A339 2002 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
Oracle 8i is a database for the Windows NT/2000 platform. This book begins with looking at the fundamentals of the operating system and installation of Oracle 8i products on Windows NT/2000 and then goes on to cover intermediate and advanced topics such as: architecture: migration; clustering; parallel server; performance monitoring and troubleshooting; and using Oracle Enterprise Manager.
Table of Contents
| Acknowledgments | p. xvii |
| Introduction | p. xviii |
| 1 Oracle9i Installation | p. 1 |
| Introducing Oracle9i for Windows NT/2000 | p. 3 |
| The Environment Used in This Book | p. 4 |
| Preinstallation Checks and Tasks | p. 5 |
| Oracle9i System Requirements | p. 5 |
| File Organization | p. 6 |
| Understanding Oracle Home | p. 7 |
| FAT Versus NT File System | p. 7 |
| Understanding OUI | p. 9 |
| Understanding Product Options | p. 10 |
| Step-by-Step Guide to Installing Oracle Components | p. 11 |
| Post-Installation Tasks | p. 16 |
| Windows Registry | p. 17 |
| Post-Installation for Individual Components | p. 18 |
| Deinstallation of Oracle Products | p. 20 |
| Deinstallation Using OUI | p. 21 |
| Manual Deinstallation | p. 21 |
| 2 Oracle9i Advanced Installation | p. 25 |
| Noninteractive Installation | p. 26 |
| Editing Response Files | p. 26 |
| Structure of a Response File | p. 27 |
| Using OEM Configuration Assistant for Silent Installation | p. 36 |
| Error-Handling in Silent Installations | p. 36 |
| Web-Based Installations | p. 37 |
| Oracle RAC Installation Tasks | p. 39 |
| System Requirements for RAC | p. 39 |
| New RAC Terminology | p. 40 |
| 3 Upgrades, Migration, and Downgrades | p. 41 |
| Migration versus Upgrades | p. 42 |
| Understand Version Numbers | p. 43 |
| When to Upgrade? | p. 43 |
| Detect Version Numbers | p. 44 |
| Tools and Methods for Migration and Upgrades | p. 45 |
| Oracle Data Migration Assistant | p. 46 |
| Oracle Migration Utility | p. 46 |
| Export and Import Utilities | p. 46 |
| Backup and Recovery Methods | p. 46 |
| SQL Commands | p. 47 |
| Choose a Tool | p. 47 |
| Tasks Before an Upgrade or Migration | p. 48 |
| Understand Available Features | p. 48 |
| Choose Your Tools and Methodology | p. 48 |
| Estimate Resources | p. 49 |
| System Tablespace | p. 49 |
| Select an Oracle Home | p. 49 |
| Prepare and Confirm Backup Strategy | p. 50 |
| Prepare Test Plan | p. 50 |
| Check Dependencies | p. 50 |
| Downtime and User Notifications | p. 52 |
| Upgrade Path | p. 52 |
| Perform a Database Upgrade | p. 53 |
| Upgrade with DMA | p. 53 |
| Upgrade Using Migration Utility | p. 60 |
| Upgrade Using Export and Import Utilities | p. 63 |
| Post-Upgrade Tasks | p. 64 |
| Back Up Database | p. 64 |
| Change Passwords | p. 64 |
| Upgrade NCHAR Columns | p. 65 |
| Install Java Component Classes | p. 65 |
| Considerations for Replication and OPS | p. 66 |
| Upgrade Components | p. 66 |
| Compatibility Between Releases | p. 70 |
| Compatibility Settings for Oracle Features | p. 71 |
| Parameter File Considerations | p. 73 |
| DB_BLOCK_CHECKSUM | p. 73 |
| JOB QUEUE_PROCESS | p. 73 |
| LOG_CHECKPOINT_TIMEOUT | p. 73 |
| 07_DICTIONARY_ACCESSIBILITY | p. 74 |
| DB_DOMAIN | p. 74 |
| Parallel Execution | p. 74 |
| Archive Log Destination | p. 74 |
| Coexistence of Oracle8/8i and 9i | p. 75 |
| Database Migration | p. 75 |
| Migration to Another Machine Using the Same Operating System | p. 75 |
| Migration to Windows NT/2000 from Another Operating System | p. 76 |
| Downgrading to Oracle8i | p. 77 |
| Back Up the Database | p. 78 |
| Remove Incompatibilities | p. 78 |
| Reset the Compatibility Level | p. 81 |
| Downgrade the Database | p. 82 |
| 4 Creating Oracle9i Databases | p. 85 |
| Planning a Database | p. 86 |
| Initialization Parameters | p. 88 |
| Static versus Dynamic Parameters | p. 88 |
| Server Parameter File | p. 89 |
| Viewing Initialization Parameter Settings | p. 93 |
| Initialization Parameters to Consider Prior to Database Creation | p. 94 |
| Global Database Name | p. 94 |
| Control Files | p. 94 |
| Database Block Size | p. 95 |
| Buffer Cache | p. 95 |
| Shared Pool and Large Pool | p. 96 |
| Limiting the SGA Size | p. 96 |
| Number of Processes | p. 96 |
| Undo Space Management | p. 97 |
| License Management | p. 97 |
| Optimal Flexible Architecture | p. 98 |
| Characteristics of an OFA-Compliant Database | p. 99 |
| Simple Algorithm for Fragmentation Elimination (SAFE) | p. 100 |
| Oracle Database Configuration Assistant | p. 100 |
| Creating an Oracle9i Database | p. 100 |
| Creating a Database with DCA | p. 101 |
| Deleting a Database Using DCA | p. 104 |
| Managing Templates with DCA | p. 104 |
| Manual Creation of a Database | p. 105 |
| New Oracle9i Features | p. 115 |
| Undo Tablespaces | p. 115 |
| Default Temporary Tablespace | p. 115 |
| Oracle-Managed Files | p. 116 |
| Setting Time Zone | p. 116 |
| 5 Oracle9i Database Administration | p. 117 |
| Theory of Databases | p. 118 |
| Overview of Oracle9i Architecture | p. 120 |
| Database versus Instance | p. 120 |
| Physical Database Structure | p. 121 |
| Logical Database Structure | p. 126 |
| Data Dictionary | p. 129 |
| Database Instance | p. 131 |
| Database Administration | p. 138 |
| Common DBA Tasks | p. 139 |
| Starting Up and Shutting Down Oracle Databases | p. 140 |
| The SQL*Plus Utility | p. 140 |
| The SQL*Plus Worksheet | p. 141 |
| OEM | p. 142 |
| Recovery Manager | p. 143 |
| ORADIM Utility | p. 144 |
| Windows NT/2000 Administration Tools | p. 145 |
| Managing Control Files | p. 152 |
| Use of Control Files | p. 152 |
| Location of Control Files | p. 152 |
| Multiplexing Control Files | p. 152 |
| Backing Up a Control File | p. 153 |
| Dropping, Renaming, and Relocating Control Files | p. 154 |
| Managing Data Files | p. 154 |
| Creating Data Files | p. 154 |
| Location of Data Files | p. 156 |
| Changing Status of Data Files | p. 157 |
| Renaming and Relocating Data Files | p. 157 |
| Checking Data Files for Corruption | p. 158 |
| Viewing Data File Information | p. 159 |
| Managing Redo Log Files | p. 159 |
| Contents of Redo Log Files | p. 160 |
| Redo Log Groups and Redo Log Members | p. 160 |
| Creating Redo Log Files | p. 160 |
| Forcing Log Switches | p. 161 |
| Managing Checkpoints | p. 161 |
| Renaming and Relocating Redo Log Files | p. 162 |
| Verifying Redo Log Files | p. 162 |
| Dropping Redo Log Files | p. 163 |
| Clearing Log Files | p. 163 |
| Viewing Redo Log File Information | p. 164 |
| Managing Tablespaces | p. 164 |
| Locally Managed Tablespaces | p. 165 |
| Types of Tablespaces | p. 165 |
| Creating Tablespaces | p. 167 |
| Dropping Tablespaces | p. 168 |
| Coalescing Tablespaces | p. 168 |
| Modifying Tablespaces | p. 168 |
| Viewing Tablespace Information | p. 169 |
| Manage Database Archiving | p. 170 |
| Space Management | p. 172 |
| Extent Allocation Methods | p. 173 |
| Space Management for Locally Managed Tablespaces | p. 174 |
| User Management and Security | p. 175 |
| Creating and Managing Users | p. 175 |
| Managing Object Privileges | p. 176 |
| Database Roles | p. 178 |
| Database Profiles | p. 179 |
| Backing Up a Database | p. 179 |
| What Is a Database Backup? | p. 180 |
| Archiving versus Nonarchiving Mode | p. 180 |
| Backup Methods | p. 180 |
| Complete versus Partial Backups | p. 180 |
| Consistent versus Inconsistent Backups | p. 181 |
| Hot versus Cold Backups | p. 181 |
| Backup Using Recovery Manager | p. 181 |
| Backup Using Windows NT/2000 Operating System | p. 185 |
| Scheduling a Backup Using Windows Scheduler | p. 186 |
| Backup Using OEM | p. 187 |
| Logical Backup | p. 187 |
| Database Recovery | p. 188 |
| Case Study: Tablespace Recovery Using RMAN | p. 189 |
| Case Study: Database Recovery Using RMAN | p. 191 |
| Recovery Using OEM | p. 192 |
| Logical Database Recovery | p. 192 |
| Performance-Tuning | p. 194 |
| Performance Manager | p. 194 |
| Lock Monitor | p. 195 |
| Performance Overview | p. 195 |
| Analyzing Tablespaces | p. 195 |
| Oracle Expert | p. 196 |
| Managing Indexes | p. 200 |
| Creating Indexes | p. 201 |
| Dropping and Rebuilding Indexes | p. 201 |
| Monitoring Indexes | p. 201 |
| Index Fragmentation | p. 202 |
| Managing Undo | p. 202 |
| Choosing Undo Mode | p. 202 |
| Managing Undo Tablespaces | p. 203 |
| Managing Rollback Segments | p. 203 |
| Viewing Undo Information | p. 203 |
| Additional Topics | p. 203 |
| Log Miner | p. 204 |
| Authentication Using Password File | p. 206 |
| Adding New Users to Password File | p. 207 |
| Oracle Managed Files | p. 207 |
| Initialization Parameters for Oracle Managed Files | p. 208 |
| Advantages and Disadvantages of Oracle Managed Files | p. 209 |
| Using Oracle Managed Files | p. 209 |
| Naming Convention for Oracle Managed Files | p. 210 |
| Transportable Tablespaces | p. 210 |
| Using the Transportable Tablespaces Feature | p. 210 |
| Windows NT/2000 Topics | p. 212 |
| ORA_DBA Group | p. 212 |
| Monitoring a Database | p. 213 |
| HTTP Server | p. 213 |
| Starting and Shutting Down HTTP Server | p. 213 |
| Configuring HTTP Server | p. 213 |
| Windows NT/2000 Tuning | p. 214 |
| Initialization Parameters | p. 215 |
| Raw Partitions | p. 215 |
| Administrative Assistant for Windows NT | p. 216 |
| 6 Oracle Net Services | p. 219 |
| Oracle Solution and Services | p. 220 |
| Oracle Net | p. 220 |
| Listener | p. 221 |
| Connection Manager | p. 222 |
| Networking Tools | p. 223 |
| Oracle Advanced Security | p. 223 |
| Enhancements in Oracle Net Services | p. 223 |
| New Nomenclature | p. 224 |
| Changes in Multithreaded Server (MTS) | p. 224 |
| Load-Balancing | p. 224 |
| Multiple Oracle Contexts | p. 224 |
| Oracle Names LDAP Proxy Server | p. 225 |
| Virtual Interface Protocol Support | p. 225 |
| Obsolete Features | p. 225 |
| Oracle Net Connections | p. 226 |
| Connection Process | p. 228 |
| Naming | p. 229 |
| Oracle Net Services Architecture | p. 231 |
| Client/Server Architecture | p. 231 |
| Java-Client Application Architecture | p. 233 |
| Web Clients Architecture | p. 233 |
| Oracle Listener | p. 234 |
| Database Server Processes | p. 234 |
| Shared Servers | p. 234 |
| Dedicated Servers | p. 235 |
| Oracle Connection Manager | p. 236 |
| Oracle Net Tools | p. 237 |
| Oracle Net Manager | p. 237 |
| Oracle Net Configuration Assistant | p. 238 |
| Oracle Net Control Utilities | p. 239 |
| Planning for Oracle Net Services | p. 244 |
| Scalability | p. 244 |
| Availability | p. 244 |
| Naming Methods | p. 244 |
| Security | p. 244 |
| Performance Tuning for Oracle Net Services | p. 245 |
| VI Protocol | p. 245 |
| Managing Session Data Unit Size | p. 245 |
| Listener Queue Size and Number of Listeners | p. 245 |
| Protocol Conversion | p. 246 |
| Setting Up Oracle Directory Server | p. 246 |
| Configuring Directory Usage During Installation | p. 246 |
| Configuring Directory Usage After Installation | p. 248 |
| Adding Users to and Removing Users from the OracleNetAdmins Group | p. 249 |
| Configuring Oracle Naming Methods | p. 250 |
| Configuring the Order of Search for Naming Method | p. 251 |
| Configuring Local Naming Method | p. 251 |
| Configuring Directory Naming Method | p. 253 |
| Configuring Oracle Names LDAP Proxy Servers | p. 253 |
| Configuring the Host Naming Method | p. 255 |
| Exporting Naming Data | p. 256 |
| Exporting Service Names from Local Names to Directory Server | p. 256 |
| Exporting Names from Oracle Names Server to Directory Server | p. 256 |
| Configuring Profiles | p. 257 |
| Setting a Default Domain for a Client | p. 258 |
| Prioritizing Naming Methods | p. 258 |
| Configuring and Administering Listener | p. 258 |
| Configuring Listening Protocol Addresses | p. 259 |
| Protocol Addresses for Oracle9i JVM | p. 261 |
| Handling Large Volumes of Concurrent Connection Requests | p. 261 |
| Configuring Static Service Information | p. 261 |
| Configuring Password Authentication for the Listener | p. 261 |
| Configuring Service Registration | p. 262 |
| Registering Information with the Default Local Listener | p. 262 |
| Registering Information with a Nondefault Listener | p. 262 |
| Registering Information with a Remote Listener | p. 262 |
| Configuring a Naming Method | p. 263 |
| Listener Administration | p. 263 |
| Configuring Oracle Connection Manager | p. 264 |
| Listening End Point Lists | p. 265 |
| Access Control Rule List | p. 265 |
| Parameter List | p. 265 |
| Configuring Clients for Oracle Connection Manager | p. 265 |
| Enabling Oracle Connection Manager Features | p. 267 |
| Oracle Shared Server | p. 269 |
| Configuring Shared Server | p. 269 |
| Testing Oracle Net Services | p. 271 |
| TNSPING Utility | p. 271 |
| TRACERT Utility | p. 272 |
| Net Manager | p. 272 |
| LSNRCTL and NAMESCTL | p. 272 |
| 7 Oracle Enterprise Manager Basics | p. 273 |
| Benefits of Using Oracle Enterprise Manager | p. 274 |
| Services Offered by Oracle Enterprise Manager | p. 275 |
| Why Use Oracle Enterprise Manager? | p. 275 |
| Oracle Enterprise Manager Architecture | p. 276 |
| Two-Tier Architecture of Oracle Enterprise Manager | p. 276 |
| Three-Tier Architecture of Oracle Enterprise Manager | p. 277 |
| Installation and Configuration of Oracle Enterprise Manager | p. 278 |
| Requirements for OEM Console | p. 278 |
| Installation of OEM Console | p. 279 |
| Oracle Enterprise Manager Repositories | p. 283 |
| Oracle Enterprise Manager Console | p. 288 |
| Console User Interface | p. 290 |
| Adding Objects and Services to Oracle Enterprise Manager | p. 292 |
| Managing Nodes | p. 296 |
| Managing Groups | p. 297 |
| Oracle Management Servers | p. 299 |
| Installation of Oracle Management Servers | p. 299 |
| Managing Oracle Management Servers | p. 300 |
| Managing Administrators | p. 300 |
| Setting Preferred Credentials | p. 305 |
| Changing Database Password for Repository Owner | p. 306 |
| Management Regions | p. 306 |
| Tuning Oracle Management Servers | p. 309 |
| Diagnosing Issues with Oracle Management Servers | p. 310 |
| Oracle Managed Nodes | p. 311 |
| Installation of Oracle Intelligent Agents | p. 311 |
| Managing Oracle Intelligent Agents | p. 311 |
| Auto Discovery | p. 313 |
| Blackouts | p. 313 |
| Troubleshooting Oracle Intelligent Agent | p. 314 |
| Simple Network Management Protocol Support | p. 314 |
| Overview of SNMP Components | p. 315 |
| SNMP Support on Oracle9i Server | p. 315 |
| Scheduling Jobs | p. 319 |
| Setting Credentials | p. 319 |
| Creating Jobs | p. 319 |
| Built-In Jobs | p. 320 |
| Jobs Task List | p. 323 |
| Job Libraries | p. 323 |
| Monitoring Events | p. 324 |
| Scope of Events | p. 324 |
| Creating Events | p. 325 |
| Event Types | p. 325 |
| Registering Events | p. 326 |
| Notifications | p. 326 |
| Event Handling | p. 327 |
| Obtaining System Reports | p. 327 |
| Configuration of Reports System | p. 327 |
| Viewing and Modifying Existing Reports | p. 328 |
| Creating Reports | p. 329 |
| Making Events, Jobs, and Reports Work for You | p. 330 |
| 8 Oracle Enterprise Manager for Database Administration | p. 335 |
| Enterprise Manager Console for Database Administration | p. 336 |
| Managing Database Security | p. 339 |
| Managing Users | p. 339 |
| Managing Roles | p. 340 |
| Auditing Users | p. 345 |
| Schema Management | p. 348 |
| Viewing Schema Objects | p. 349 |
| Schema Management Features of OEM | p. 349 |
| Storage Management | p. 353 |
| Tablespace Management | p. 353 |
| Control File Information | p. 353 |
| Data File Information | p. 353 |
| Rollback Segments | p. 354 |
| Redo Log Groups | p. 354 |
| Archive Logs | p. 354 |
| Managing Instances | p. 354 |
| Starting Up and Shutting Down a Database | p. 354 |
| Managing User Sessions | p. 356 |
| Managing In-Doubt Transactions | p. 357 |
| Locks | p. 357 |
| Stored Configuration | p. 357 |
| Managing Resources with Resource Plans | p. 357 |
| Backup and Recovery | p. 358 |
| Full versus Incremental Backups | p. 362 |
| Logical Backups | p. 362 |
| Performing Database Recovery | p. 362 |
| Viewing Listener Information | p. 363 |
| Managing HTTP Server | p. 364 |
| Exporting and Importing Databases | p. 364 |
| Exporting Data | p. 364 |
| Importing Data | p. 364 |
| Loading Data | p. 365 |
| Other Features | p. 368 |
| System Management Packs | p. 368 |
| Oracle Diagnostics Pack | p. 368 |
| Oracle Tuning Pack | p. 371 |
| Oracle Change Management Pack | p. 375 |
| Oracle Standard Management Pack | p. 377 |
| 9 Oracle9i Application Server Basics | p. 379 |
| Introduction to Oracle9i Application Server | p. 380 |
| Oracle9i Application Server Services | p. 382 |
| Communication Services | p. 382 |
| Content Management Services | p. 382 |
| Presentation Services | p. 384 |
| Application Development and Deployment | p. 384 |
| Portal Services | p. 386 |
| Caching Services | p. 387 |
| Business Logic Services | p. 387 |
| Content Creation | p. 387 |
| Oracle9i Application Server Editions | p. 389 |
| Installation of Oracle9i Application Server | p. 391 |
| Product Versions and Availability | p. 391 |
| System Requirements | p. 392 |
| Overview of the Istallation | p. 393 |
| Step-by-Step Installation of Oracle9i Application Server | p. 395 |
| Known Issues with Oracle9i Application Server | p. 405 |
| 10 Oracle9i Application Server Additional Topics | p. 407 |
| Oracle Database Cache | p. 408 |
| How Database Cache Works | p. 409 |
| Installation of Database Cache | p. 410 |
| Configuration of Database Cache | p. 413 |
| Enabling and Disabling Cache | p. 418 |
| Troubleshooting Database Cache | p. 418 |
| Oracle Web Cache | p. 419 |
| How Oracle Web Cache Works | p. 420 |
| Installation and Configuration of Oracle Web Cache | p. 420 |
| Troubleshooting Oracle Web Cache | p. 423 |
| Oracle Internet File System | p. 423 |
| Internet File System Architecture | p. 423 |
| Istallation of Oracle Internet File System | p. 424 |
| Starting and Stopping iFS | p. 428 |
| Using iFS | p. 430 |
| Oracle Plug-In for Microsoft Internet Information Server | p. 437 |
| Configuring Oracle Plug-In for Microsoft IIS | p. 437 |
| 11 Oracle9i Security Features | p. 443 |
| Security Basics | p. 444 |
| Security Issues | p. 444 |
| What Can Go Wrong with Security? | p. 446 |
| Oracle Software and Security | p. 446 |
| Oracle9i Server Security Features | p. 447 |
| Authentication | p. 447 |
| Roles | p. 448 |
| Profiles | p. 449 |
| Auditing | p. 449 |
| Views | p. 449 |
| Stored Program Units | p. 450 |
| Encrypting Data | p. 451 |
| Fine-Grained Access Control | p. 452 |
| Oracle Net Services Security Features | p. 458 |
| Oracle9i Application Server Security Features | p. 458 |
| Oracle Advanced Security | p. 459 |
| Oracle Advanced Security Architecture | p. 459 |
| Oracle Advanced Security Solutions | p. 459 |
| Support for Public Key Infrastructure | p. 469 |
| Oracle Internet Directory | p. 470 |
| 12 Case Studies | p. 471 |
| The Test Installation | p. 472 |
| Case Study 1 Browser-Based SQL Queries | p. 473 |
| Step-by-Step Instructions | p. 474 |
| Additional Remarks | p. 475 |
| Case Study 2 Migration from MS SQL Server 7.0 to Oracle9i | p. 476 |
| Step-by-Step Instructions | p. 476 |
| Additional Remarks | p. 479 |
| Case Study 3 PHP-Based Applications Against Oracle9i | p. 479 |
| Step-by-Step Instructions | p. 479 |
| Additional Remarks | p. 484 |
| Case Study 4 Use of Oracle Internet Directory for Enterprise User Security | p. 484 |
| Step-by-Step Instructions | p. 485 |
| Additional Remarks | p. 497 |
| Case Study 5 Backup Strategy for Small- to Medium-Sized Sites | p. 497 |
| Step-by-Step Instructions | p. 498 |
| Additional Remarks | p. 500 |
| Case Study 6 Tablespace Point-in-Time Recovery | p. 500 |
| Step-by-Step Instructions | p. 501 |
| A Additional Resources on the Web | p. 505 |
| B Oracle9i New Features for Windows | p. 509 |
| Index | p. 511 |
