This Database 11g training teaches you how to perform all common administration tasks needed to keep the database operational, including how to perform. Oracle Database 2 Day DBA 11g Release 1 (). B Copyright © , , Oracle and/or its affiliates. All rights reserved. Primary Author: Steve . 5 May Oracle Database Express Edition 2 Day DBA, 11g Release 2 (). E . Starting Up the Database Using the SQL Command Line.
|Published (Last):||16 May 2007|
|PDF File Size:||12.73 Mb|
|ePub File Size:||12.40 Mb|
|Price:||Free* [*Free Regsitration Required]|
In the Available Targets list, select your instance, and oeacle click the Move icon. In the left-hand pane, click Blackouts. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. You must then decide which system privileges, object privileges, or roles to grant the user, if any, to oracle 2 day dba 11g database administration tasks.
On any help page, click Contents for links to all help topics. You must do the following to start the database: Click Preferred Credentials in the left-hand pane. These are the only accounts that are automatically granted the roles and privileges required to administer Database Control itself.
Defining Blackout Periods You can define one or more one-time or repeating blackout periods during which collection of database monitoring information and dau sending of alerts are suspended. This chapter contains the following sections: Registered oracle 2 day dba 11g must view the class from the country listed in the registration form.
The OBE steps through all tasks in the chapter and includes annotated screenshots. Except as oracle 2 day dba 11g permitted in your license agreement or allowed by law, you may oracle 2 day dba 11g use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or orcle any part, in any form, or by any means.
If you find any errors, please report them to us in writing. To keep your environment secure, setting up tasks for automatic execution in Enterprise Manager requires you to provide login information otacle the host computer and database. From any Database Control page, at the top of the page, click Preferences. This section pracle an overview of the tasks involved in managing an Oracle database instance. Click hereto request this course. Populate the tables with data.
Oracle Database 2 Day DBA 11g Release 1 ()
This software or hardware is developed for general use in a variety of information management applications. Oracle Database Licensing Information.
Defining blackoutswhich are time periods in which database monitoring is suspended so that maintenance operations do not skew monitoring data or generate needless alerts. Additionally, for a complete discussion of administrative tasks, see Oracle Database Administrator’s Guide. For example, clicking the link next to the label Host provides additional details about the oracle 2 day dba 11g on which the database runs. Getting Started with Oracle Enterprise Oracle 2 day dba 11g Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services.
You can also view performance and status information about your database.
The Administrators page appears, showing the new administrator in the list. In some cases, the OBE provides dbx information to help you complete the task.
SQL pronounced like sequel is an industry-standard English-like computer programming language for querying and updating databases. If you use this oracle 2 day dba 11g or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use.
Managing the Oracle Instance: For example, if you installed the database on a host computer named comp Configure the operating system environment variables, as described in “Configuring the Operating System Environment Variables”.
Emphasis is on the self-managing capabilities and automatic features of Oracle Database 11g. This is the page that loads when you log in to Database Control.
The Database Preferred Credentials page appears. Log in oracle 2 day dba 11g the database with a user account that is authorized to access Database Control. This software or hardware is developed for general use in a variety of information management applications. Setting alert thresholds for database metrics, such as tablespace ray usage oraclee exceeded or SQL response time exceeded.
Selecting database policies to apply, so that Database Control can show alerts if a oracle 2 day dba 11g is violated. Contact Oracle University for more information.