Oracle 10g/11g Data and Database Management Utilities: LITE


Oracle 10g/11g Data and Database Management Utilities: LITE
eBook: $9.99
Formats: PDF, PacktLib, ePub and Mobi formats
$8.49
save 15%!
Print + free eBook + free PacktLib access to the book: $29.98    Print cover: $19.99
$19.99
save 33%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Optimize time-consuming tasks efficiently using three Oracle database utilities
  • Get to grips with user session management issues
  • Boost database defences with Oracle Wallet Manager and Security
  • A focused handbook with practical content and real-life scenarios

Book Details

Language : English
Paperback : 96 pages [ mm x mm ]
Release Date : May 2011
ISBN : 1849683727
ISBN 13 : 9781849683722
Author(s) : Hector R. Madrid
Topics and Technologies : All Books, Enterprise Products and Platforms, Lite Editions

Table of Contents

Preface
Chapter 1: Session Management
Chapter 2: Oracle Wallet Manager
Chapter 3: Security Management
Index
  • Chapter 1: Session Management
    • User sessions in a dedicated server architecture
      • Instance self registration process
    • Blocking sessions
      • Optimistic versus pessimistic locking
      • Row lock contention monitoring
      • Killing sessions
      • Deadlock handling
      • Sniped sessions
      • Orakill
    • Services
    • Resource Manager
      • Resource Manager Elements
      • Configuring resources assigned to users
      • Configuring resources assigned to services
        • Creating the database user
        • Service names definition
        • Listener verification
        • TNS entry configuration
        • Resource consumer group creation
        • Service mapping
        • Resource plan definition
        • Resource manager plan activation
        • Testing and monitoring
    • Active Session History (ASH)
    • Session monitoring, the traditional way
    • Summary
    • Chapter 2: Oracle Wallet Manager
      • The Oracle Wallet Manager
        • Creating the Oracle Wallet
        • Enabling Auto Login
        • mkwallet, the CLI OWM version
        • Managing Wallets with orapki
      • Oracle Wallet Manager CSR generation
      • Storing the Oracle Wallet in the Windows registry
        • Save Wallet to the registry
        • Open the Wallet from the registry
        • Save as to a different registry location
        • Open the Wallet from the registry, save it to the file system and vice versa
        • Delete the Wallet from the registry
        • Configuring the Wallet location
      • Storing the Wallet in an LDAP server
        • Uploading the Wallet to an LDAP server
        • Downloading the Wallet from LDAP
      • Using certificates for authentication
        • Public Key Infrastructure tools
      • Using the Oracle Wallet to store database credentials
      • Summary
      • Chapter 3: Security Management
        • Using the Oracle Wallet to encrypt backups
          • Recovery Manager encryption
            • Using the transparent mode
            • Using the password mode
            • Using the dual mode
          • RMAN backup shredding (11g only)
          • Data pump encryption
        • The enterprise user
          • Configuring the environment
            • How Oracle SSO works
          • Configure access to the LDAP directory
          • Registering the database against the OID
          • Shared schema
        • Summary

        Hector R. Madrid

        Hector Madrid is currently working as a freelance consultant. He is an Oracle ACE, collaborates with Oracle University as a certified instructor for the DBA and Java curriculum tracks. He is a highly respected Oracle professional with 20 years of experience as a full time DBA. He works with a wide range of DBA requirements from the daily DBA routine duties to tasks related to mission-critical and high availability systems. He was the first Oracle Certified Master in Latin America and he holds the certificate for all Oracle Version starting with 7.0 and up to 11g.

        He obtained a Masters Degree in Computer Sciences from the Metropolitan Autonomous University (UAM) and he has presented different technical papers at several Oracle conferences.

        Sorry, we don't have any reviews for this title yet.

        Code Downloads

        Download the code and support files for this book.


        Submit Errata

        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

        Sorry, there are currently no downloads available for this title.

        Compare Books

        See which product is right for you

        Oracle 10g/11g Data and Database Management Utilities: LITE Oracle 10g/11g Data and Database Management Utilities

        Lite Edition

        Learn more

        Full Edition

        Learn more
        Optimize time-consuming tasks efficiently using three Oracle database utilities
        Get to grips with user session management issues
        Boost database defences with Oracle Wallet Manager and Security
        A focused handbook with practical content and real-life scenarios
        eBook available as PDF downloads
        eBook available as ePub downloads
        Available on PacktLib
        Perform data loads on the fly and replace the functionality of the old export and import utilities using Data Pump or SQL*Loader
        Price €14.99
        €38.99

        Frequently bought together

        Oracle 10g/11g Data and Database Management Utilities: LITE +    Fast Data Processing with Spark =
        50% Off
        the second eBook
        Price for both: $24.55

        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

        What you will learn from this book

        • Diagnose and solve row lock contention problems.
        • Learn about snipped sessions
        • Discover how to manage certificates and certificate requests
        • Gain step by step instructions in how to set up an environment with enterprise identity management using the Enterprise Security Manager

        In Detail

        Database administration is part of a daily routine for all database professionals. Using different Oracle Utilities, administrators can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security, and can in general do more with the same time and resources. 

        You don't have to reinvent the wheel, just learn how to use Oracle Utilities properly to achieve your goals. That is what this book is about; it covers three areas: Session Management, Oracle Wallet Manager, and Security Management.

        To find out more about upgrading to the full edition, visit www.packtpub.com/lite-editions and log into your account for offers and help. If you don’t have an account on PacktPub.com, visit today and set one up!

        Approach

        This practical, hands-on book is specifically designed to improve the way you use and work with Oracle database utilities. The material has been carefully selected from Packt’s fuller Oracle 10g/11g Data and Database Management Utilities title. The full edition of the book covers a number of additional utilities including Data Pump, SQL*Loader, Recover Manager, and more!

        Who this book is for

        This book is aimed at all Oracle professionals who interact with the database through the data and database utilities and are willing to optimize their interaction with it.

        Code Download and Errata
        Packt Anytime, Anywhere
        Register Books
        Print Upgrades
        eBook Downloads
        Video Support
        Contact Us
        Awards Voting Nominations Previous Winners
        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
        Resources
        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software