Saturday, October 12, 2019 admin Comments(0)

Related Documentation xiv. Conventions xv. Changes in This Release for Oracle Database 2 Day DBA. Changes in Oracle Database Release 18c, Version Oracle Database Express Edition 2 Day DBA, 11g Release 2 (). E . Starting Up the Database Using the SQL Command Line. This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual.

Language:English, Spanish, French
Genre:Health & Fitness
Published (Last):04.10.2015
ePub File Size:26.62 MB
PDF File Size:12.82 MB
Distribution:Free* [*Sign up for free]
Uploaded by: VANITA

Oracle Database 2 Day DBA 11g Release 2 (). E . 2 Installing Oracle Database and Creating a Database. Overview of Installing. Oracle Database 2 Day DBA 11g Release 1 (). B . 2 Installing Oracle Database and Creating a Database. Overview of Installing. Oracle Documentation. Sign In Icon Sign In · Home / Oracle Database Online Documentation Library, 11g Release 2 (). Database 2 Day DBA. Contents.

The control file is read when a database is mounted. The control file has 2 sections: 1 reusable 2 Non reusable. Reusable section is written to in a circular manner similar to that for redo-logs. Must recreate the control file to increase its size based upon new settings for parameters that affect it's size. To add a control file: 2.

Configure them to be ASM disks. Practice adding and removing disks within ASM. Define failure groups. Practice disaster recovery using ASM. Many of these topics are described in the ASM Oracle documentation here. If you've done the groundwork mentioned previously, it should go really well. If you've rushed to this point, it will probably be a painful process.

Don't assume one successful installation means you are ready to move on. Try installing different versions of RAC on different operating system versions. You will hit problems, but treat these as learning experiences. Here are some things, in no particular order, you should probably try out. Clean shutdown of a node.

Dba 11g pdf 2 day oracle

Check what happens in the remaining nodes log files. Power off a node. Turn off the network adapter for the interconnect on one node. To download free release notes, installation documentation, updated Oracle documentation, white papers, or other collateral, visit the Oracle Technology Network OTN. You must register online before using OTN; registration is free and can be done at index.

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter. This introductory chapter is intended to help orient you to many common DBA tasks, to the tools available to you, and to this guide.

The goal of this guide is to help you understand the concepts behind Oracle Database, and to help you learn how to perform all common administrative tasks needed to keep the database operational. These tasks include configuring the database, managing memory and storage, managing users, managing database objects such as tables, performing basic troubleshooting, creating backups for your database, performance monitoring activities, and more.

The primary administrative interface used in this guide is Oracle Enterprise Manager Database Control, featuring all the self-management capabilities introduced in Oracle Database.

The objective is to describe why and when administrative tasks must be performed. Where appropriate, it describes the concepts necessary to understand and complete a task, assuming the reader has no prior knowledge of the database.

This guide is not an exhaustive discussion of all Oracle Database concepts. For this type of information, see Oracle Database Concepts. Additionally, for a complete discussion of administrative tasks, see Oracle Database Administrator's Guide.

The OBE steps through all tasks in the chapter and includes annotated screenshots.

Oracle Database 2 Day DBA - Oracle Documentation by Oracle Corporation - PDF Drive

In some cases, the OBE provides additional information to help you complete the task. At the end of each chapter, you can find the link to its associated OBE lesson. Contact Oracle University for more information. In a relational database, all data is stored in two-dimensional tables that are composed of rows and columns. Oracle Database enables you to store data, update it, and efficiently retrieve it, with a high degree of performance, reliability, and scalability.

Oracle Database is composed of the following elements: The Oracle software that you install on your host computer The database, which is a collection of physical files on one or more disks The database contains user data, metadata, and control structures.

Metadata, or data about the data, is the collection of information on disk that permits Oracle software to manage user data. An example of metadata is the data dictionary. Control structures such as the control file and online redo log files ensure the integrity, availability, and recoverability of user data.

The Oracle instance, which is composed of the following: The background processes, which 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.

2 pdf oracle 11g day dba

Oracle Net, which is a software layer that enables client applications and Oracle Database to communicate over a network, and the Oracle Net listener, which is a process that listens for connection requests from the network. In large, enterprise environments, the job is often divided among several DBAs, each of whom has a specialty, such as database security or database tuning. Tools for Administering the Database The goal of this guide is to enable you to quickly and efficiently create an Oracle database, and to provide guidance in basic database administration.

The following are some products, tools, and utilities you can use to achieve your goals as a database administrator: Chapter 4, "Configuring the Network Environment" Chapter 5, "Managing the Oracle Instance" Chapter 6, "Managing Database Storage Structures" Oracle Database Concepts for more information about background processes Oracle Database Reference for more information about background processes Oracle Database Concepts for more information about the duties of database administrators Oracle Universal Installer Oracle Universal Installer OUI is a utility that installs your Oracle software and options.

It can automatically start Oracle Database Configuration Assistant to install a database.

Day oracle dba 11g pdf 2

It enables you to copy a preconfigured seed database, thus saving the time and effort of generating and customizing a new database. Database Upgrade Assistant The Database Upgrade Assistant is a tool that guides you through the upgrade of your existing database to a new Oracle Database release. After you have installed the Oracle Database software, created or upgraded a database, and configured the network, you can use Database Control to manage your database.

Oracle also offers separately licensed Oracle Enterprise Manager management packs, management plug-ins, and other products you can purchase to enhance the capabilities of Oracle Enterprise Manager in specific environments.

If you are using an earlier release of Oracle Database and want to install a later release of the Oracle Database software, then you can upgrade your existing Oracle Database and use it with the new release of the database software. OUI is a graphical user interface utility that enables you to install new Oracle Database software. Online Help is available to guide you through the installation process. During the installation process, you are given the opportunity to create a database.

Before you start the installation process, see the following sections for information about prerequisites and installation choices: Checking Prerequisites Deciding on Installation Choices If you do not create a database during installation, then you must run DBCA at some point after installation to create a database. Installing Oracle Database and Creating a Database 24 Overview of Installing Oracle Database Software and Creating a Database Note: After you create a database, either during installation or as a standalone operation, you do not have to create another.

Oracle Database 11g: New Features for Administrators DBA Release 2

Each Oracle instance works with a single database only. Rather than requiring that you create multiple databases to accommodate different applications, Oracle Database uses a single database, and accommodates multiple applications by enabling you to separate data into different schemas within the single database. See "About User Accounts" on page for more information about schemas. Checking Prerequisites Before installing the software, OUI performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation.

If your computer does not meet a requirement, then an error message is displayed. The requirements may vary depending upon the type of computer and operating system you are using, but some prerequisites include: There is a minimum of 1 GB of physical memory. Sufficient paging space is available. The appropriate service packs or patches for your operating system are installed.

Top 40 oracle dba interview questions and answers

An appropriate file system format is being used. Oracle Database Installation Guide for your platform for more information about exact requirements Deciding on Installation Choices Oracle Universal Installer guides you through an interview phase where you specify your choices for installation and database creation. The exact sequence of steps depends on your operating system. As you progress through the installation, you are presented with choices on how to configure the database.

You can create a preconfigured database or a custom-configured database during installation. If you choose not to create a database during installation, then you must run DBCA after installation to create a database.

Preconfigured databases are based on templates that Oracle provides or that you create. Each Oracle-provided template is optimized for a particular workload type.

If you choose to use the Desktop Class installation method, then the general purpose database template is used. To create a custom database in which you configure your own database structure, see "About Advanced Installation". Note: If you must create a new database, then Oracle recommends that you install a preconfigured database, which is faster and easier. You can customize the database after it has been created. Installation Method The installation methods are divided into Desktop Class and Server Class: Desktop Class This installation class is most appropriate for laptop or desktop computers.

It includes a starter database and requires minimal configuration. Server Class This installation class is for servers, such as you would find in a data center, or used to support enterprise-level applications. Choose this installation class if you need access to advanced configuration options.

During a Desktop Class installation, you make only basic choices. For a Server Class installation, you choose either typical installation where you make only basic choices or advanced installation.

Oracle® Database

During a Desktop Class or a typical installation, Oracle Database automatically installs the sample schemas. Installation Type When you install Oracle Database during basic and advanced installations, you need answers for the questions listed in this section. OUI provides default values for every choice. What type of database edition installation do you want to perform? Your choices are: Enterprise Edition This installation type is the full-featured Oracle Database product that provides data management for enterprise-level applications.

It is intended for mission-critical, high-security online transaction processing OLTP and data warehousing environments. Standard Edition This installation type is suitable for workgroup or department-level applications, and for small to medium-sized enterprises. It provides core relational database management services and options and includes an integrated set of management tools, replication, Web features, and facilities for building business-critical applications.

Standard One Edition This installation type is suitable for workgroup, department, or web applications. It provides core relational database management services for single-server environments or highly distributed branch environments. Oracle Standard Edition One includes all the facilities necessary to build business-critical applications. Physically, data will get stored in Datafiles. Datafiles will be connected to tablespace.

A tablespace can have multiple datafiles. It contains read only data dictionary tables which contains the information about the database. Answer:The datafiles contain all the database data. The data of logical database structures, such as tables and indexes , is physically stored in the datafiles allocated for a database. Answer:Every Oracle database has a control file. A control file contains entries that specify the physical structure of the database such as Database name and the Names and locations of datafiles and redo log files.

Answer The primary function of the redo log is to record all changes made to data. If a failure prevents modified data from being permanently written to the datafiles, then the changes can be obtained from the redo log, so work is never lost.

This prevents oracle from overwriting the redo log files before they have been safely archived to another location. Answer:A user account and its associated data including tables, views , indexes, clusters, sequences ,procedures, functions, triggers,packages and database links is known as Oracle schema.

Answer:Data Blocks are the base unit of logical database space.