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):||5 April 2011|
|PDF File Size:||11.65 Mb|
|ePub File Size:||15.50 Mb|
|Price:||Free* [*Free Regsitration Required]|
It is not developed or intended for use in any inherently dangerous applications, including applications that may create oracle 2 day dba 11g risk of personal injury. In the Name field, enter the name of an existing database user, or click the flashlight icon next to the field and select an existing database user.
Oracle Database is composed of the following elements: A Roadmap This section provides an overview of the tasks involved in managing an Oracle database instance.
The following SQL statement creates the database user nick and assigns him a password of your choosing, represented by password: The Database Preferred Credentials page appears.
The Administrators page appears. For example, you click Availability to perform tasks associated with backing up and recovering your data.
You must end each statement with a semicolon. When you set preferred credentials, Database Control automatically fills in dwy computer and database login credentials for you at times when it usually prompts for these credentials.
You must grant access to Database Control to these users before they can log in.
Database 2 Day DBA – Contents
In the left navigation bar, click Administrators. Review, unlock, and reset passwords for predefined database users as needed. Oracle Database Concepts for more information about background processes. See “Setting Preferred Credentials”. Nonadministrative users may also want to log in to Database Control. Blackouts suspend the collection of database monitoring data and the sending of alerts by Database Control.
Oraclw Database Concepts for more information about the duties of database administrators. For example, clicking oracle 2 day dba 11g link next to the label Host provides additional details about the computer on which the database runs.
D59770GC20, Oracle Database 11g: 2 Day DBA – Release 2
Other names may be trademarks of their respective owners. Intel and Intel Xeon are oracle 2 day dba 11g or registered trademarks of Intel Corporation.
You must have logged in to the host computer with a user account that is a member of a special host user group. For example, application developers may want to take advantage of the Database Control interface to create or modify tables, indexes, views, and so on. This software or hardware and documentation may provide access to or information on content, products, and services from third parties.
These links take you to the various Database Control subpages that organize management orcale into distinct categories. To start dbconsoleclick Startand then click OK.
Click Finish to configure the database user as a Database Control administrative user. Performing Backup and Recovery: Oraacle alert thresholds for database metrics, such as tablespace space usage percentage exceeded or SQL response time exceeded See “Managing Alerts”.
In a small to medium-sized database environment, you might be the sole person performing these tasks. On Windows, the host oracle 2 day dba 11g must be a member of the Administrators group and must be granted the Dbs on as batch job logon right.
Create the necessary schema objects, including tables, views, and indexes. Using Database Control, you can perform administrative tasks such as creating schema objects tables, views, dah, and so onoracle 2 day dba 11g user security, managing database memory and storage, backing up and recovering your database, and importing and exporting data.
Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties fay any kind with respect to third-party content, products, and services. Enter one or more e-mail addresses for this administrator only if you plan to set up e-mail notifications for the database.
To repeat the blackout periodically, in the Repeating section, select a repeat frequency from the Repeat list. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
If the dbconsole process is stopped, then it must be manually restarted before you use Database Control. Online Help You can access context-sensitive oracle 2 day dba 11g help by clicking the Help link displayed at the top of every page. Government, the following notice is applicable: