Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.

Related Content you might be interested in

Current Title:

Small book image
Oracle 10g/11g Data and Database Management Utilities
Jun, 2009 | 432 pages
No titles found
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Oracle 10g/11g Data and Database Management Utilities
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
Data Pump
Data Pump
Data Pump features
Data Pump architecture
Setting up the practical scenarios
Data Pump export
Data Pump restart capability
Getting information about the export job
Data Pump import
Improving performance with Data Pump
Working with the Data Pump API
Data Pump 11g new features
Summary
2
SQL*Loader
SQL*Loader
SQL*Loader basics
Preparing the demo environment
Specifying a particular character set
Load on the fly
Direct path versus Conventional path load
Loading Large Objects (LOBs)
Loading multimedia files
Resumable load
Parallel load
General performance booster tips
Summary
3
External Tables
External Tables
The External Table basics
Let's setup the environment
Inter-version compatibility
Data transformation with External Tables
Mapping XML files as External Tables
Dynamically changing the external reference
Oracle 11g External Table enhancements
Summary
4
Recovery Manager Advanced Techniques
Recovery Manager Advanced Techniques
Recovery Manager basics
Backup compression
Faster backups through intra-file parallel backup and restore operations (11g only)
Block media recovery
Backup duration and throttling
Database cloning
Inter-platform database migration
Migrate to and from an ASM environment
General backup advices
Summary
5
Recovery Manager Restore and Recovery Techniques
Recovery Manager Restore and Recovery Techniques
Oracle database recovery
Loss of data files
Loss of redo log files
Test restore
Crosscheck command
Nologging considerations
Summary
6
Session Management
Session Management
User sessions in a dedicated server architecture
Blocking sessions
Services
Resource Manager
Active Session History (ASH)
Session monitoring, the traditional way
Summary
7
Oracle Scheduler
Oracle Scheduler
Oracle Scheduler concepts
Getting started with the Oracle Scheduler
Time expression syntax
Programs
Schedules
Jobs and Job Classes
Managing the Scheduler
Data dictionary related views
Summary
8
Oracle Wallet Manager
Oracle Wallet Manager
The Oracle Wallet Manager
Oracle Wallet Manager CSR generation
Storing the Oracle Wallet in the Windows registry
Storing the Wallet in an LDAP server
Using certificates for authentication
Using the Oracle Wallet to store database credentials
Summary
9
Security Management
Security Management
Using the Oracle Wallet to encrypt backups
The enterprise user
Summary
10
Database Configuration Assistant
Database Configuration Assistant
DBCA
Database creation
Database edition
Database template management
Automatic Storage Management configuration
DBCA, Batch mode
Summary
11
Oracle Universal Installer
Oracle Universal Installer
OUI basics
OUI basic and advanced installation modes
Modes of installation
OUI command line parameters
Silent installation mode
The oraparam.ini file
OUI return codes
Installing Oracle from the Web
Recovering a lost Inventory
Cloning Oracle Home using OUI
Summary
12
Enterprise Manager Configuration Assistant
Enterprise Manager Configuration Assistant
Enterprise Manager Components
Enterprise Manager configuration
EMCA Command Line Interface
EMCA 10g Release 1
EM directory structure
Environment changes
Securing Enterprise Manager
Summary
13
OPatch
OPatch
OPatch
Downloading the latest OPatch version
OPatch requirements
OPatch syntax
Oracle maintenance using OPatch
Applying a single patch using OPatch
Querying the Oracle inventory
Rolling back a failed OPatch session
Considerations after applying a patch
OPatch in Oracle 11g
Oracle Configuration Manager Registration
Critical Patch Updates
Hot patching (11g only)
Troubleshooting OPatch
Using Enterprise Manager for software maintenance
Managing Patches in EM 11g
Summary

Storing the Oracle Wallet in the Windows registry

On Windows operating systems the Wallet can either be stored in the file system or in the Windows registry. Storing the Wallet in the registry has several advantages. It creates an additional security layer, allowing transparency for all other users. When a user profile is removed, the Wallet in the profile is also removed. The Wallet is transparent to all other users and when the user logs out, access to the Wallet is automatically precluded.

The supported operations are:

  • Save a Wallet to the registry

  • Open a Wallet from the registry

  • Save as to a different registry location

  • Open Wallet from the file system, save it to the registry, and vice versa

  • Delete a Wallet from the registry

Save Wallet to the registry

In order for you to save a Wallet to the Windows registry, make sure the Use Windows Registry check box is marked; when you command the Wallet to be saved, it will use the Windows registry.

The Wallet will only be available to the user who saved...

Previous Section
End of Section 4
Next Section