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):||12 October 2005|
|PDF File Size:||18.91 Mb|
|ePub File Size:||19.23 Mb|
|Price:||Free* [*Free Regsitration Required]|
To get a more accurate, long-term picture of database performance, you can use blackouts to exclude these special-case situations from data analysis. Create the necessary schema objects, including tables, views, and indexes.
Database 2 Day DBA – Contents
To avoid oracle 2 day dba 11g this information every time you create or run a job or task, Database Control enables you to save this information oraclf preferred credentials. Install Oracle Database 11g software and create a database Use Enterprise Manager Database Control to manage the database Manage database storage structures and schema objects Administer users and security Back up and recover the Oracle database Monitor the database and use the Advisors A Live Virtual Class LVC is exclusively for registered students; unregistered individuals may not view an LVC at any time.
Government, the following notice is applicable: Oracle also offers separately licensed Oracle Enterprise Manager management packs, iracle plug-ins, and other products you can purchase to enhance the capabilities of Oracle Enterprise Manager in specific environments. Currently this course is not scheduled.
The fully qualified name for your database instance appears in the Available Targets list. The dbconsole process is automatically started after installation. Government, the following notice is applicable:. Nonadministrative users may also want to log in to Database Control. See Chapter 8, “Managing Schema Objects”. Double-click the Administrative Tools oracle 2 day dba 11g, and then double-click the Services icon. The OBE steps through all tasks in the chapter and includes annotated screenshots.
Oracle Database 2 Day DBA 11g Release 2 ()
A Roadmap This section provides an overview of the tasks involved in managing an Oracle database instance. Create or review the backup strategy for the database and back up the database.
It contains the following topics: Oracle Net, oracle 2 day dba 11g is a software layer that enables client applications and Oracle Database to communicate over a network, and the Oracle Net listenerwhich is a process that listens for connection requests from the network.
The Administrators page appears. At the prompt, enter the password that you set up during installation. 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.
oracle 2 day dba 11g
See Chapter 10, “Monitoring and Tuning the Database”. Open a command window.
Examples of Database Control administration tasks include the following: You can also run commands to stop the dbconsole process or view its status. This section provides an overview of the tasks involved in managing an Oracle oracle 2 day dba 11g instance. Start the database instance. Click Create to start the Create Blackout wizard.
SQL is a powerful language that can also be used to perform a oracle 2 day dba 11g of database administration tasks. From any Database Control page, at the top oracle 2 day dba 11g the page, click Preferences. The background processeswhich are the operating system processes or threads that perform the work of accessing, storing, monitoring, and recovering user data, metadata, and control files associated with the database The shared memory areas used by the background processes Server processes that perform work on behalf of connected users and applications, and the memory and temporary storage used by these processes Server processes parse and execute SQL statements, and retrieve and return results to the user or application.
Each chapter in this guide describes a different task in detail.
D59770GC20, Oracle Database 11g: 2 Day DBA – Release 2
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. Registered students must view the class from the country listed in the registration form.
To access the Database Home page: