In our fast-paced, digital, and information-driven world, an Organization’s data can be even more valuable than it’s tangible assets. It’s no surprise then that corporations tend to spare no expense when it comes to the preservation and day-to-day maintenance of their digital assets. In this course, Managing Database Instances with Oracle, you’ll build upon what you’ve mastered in Understanding Database Architecture with Oracle. First, you’ll start by reviewing what it means to STARTUP or SHUTDOWN an Oracle instance. Next, you’ll use the Automatic Diagnostic Repository (ADR) to access diagnostic information. After that, you’ll learn how to configure aspects of our Oracle system by setting and changing initialization parameters. Finally, you’l learn to mine the data dictionary for useful information. When you’re finished with this course, you’ll have the skills and knowledge necessary to work on the Oracle Instance.
Author Name: Agaba Philip
Author Description:
I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I’ve come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I’m currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas… more

Table of Contents

• Course Overview
  1min
• Starting and Stopping the Oracle Instance
  8mins
• Using the Automatic Diagnostic Repository
  7mins
• Managing Initialization Parameters
  16mins
• Understanding the Data Dictionary
  4mins