working. Chapter 9: Creating and Operating Oracle Database 12c

These flashcards cover the key concepts and terminology from Chapter 9 on creating and operating Oracle Database 12c.

Oracle Database 12c

A version of Oracle's database management system known for its multi-tenant architecture and improved scalability.

DBCA

Database Configuration Assistant, a tool used to create and manage Oracle databases.

OUI

Oracle Universal Installer, a Java-based tool used to install Oracle software.

Initialization Parameter Files

Files that contain the configuration parameters used by an Oracle instance upon startup.

PFILE

A plaintext initialization parameter file in Oracle that can be edited using a text editor.

SPFILE

A binary initialization parameter file in Oracle that cannot be edited directly but stores parameter values.

Optimal Flexible Architecture (OFA)

A best-practice methodology recommended by Oracle for managing installations in Unix environments.

Operating System DBA (OSDBA)

A group that allows user access to the Oracle database with elevated privileges, commonly granting SYSDBA access.

Enterprise Manager (EM) Database Express

A web-based interface to manage Oracle databases, which allows users to perform various administrative tasks.

Dynamic Performance Views

Views in Oracle that provide information about the current state and performance of the database.

Data Dictionary Views

A set of views in Oracle that provide information about database objects, users, and other components.

Kernel Parameters

System settings in Unix that control various aspects of the operating system, which can affect Oracle operations.

Memory Management

The allocation and management of memory within the Oracle database instance using SGA and PGA.

Backup and Recovery

Processes involved in preserving the database data and restoring it to a previous state in case of failure.

Alert Log

A chronological log file that records significant events and errors during the operation of the Oracle database.

CREATE DATABASE Statement

An SQL statement used to create a new database in Oracle, defining its structure and initial parameters.

Database Options

Configuration settings specified during database creation or modification, including enabling features like JVM or Oracle Text.

Multi-tenant Architecture

An architecture feature in Oracle Database 12c that allows multiple pluggable databases to share a single container database.

Data Files

Files where an Oracle database stores data, consisting of various tablespaces.

Control Files

Files that hold metadata about the structure of an Oracle database, including the names of data files and redo logs.

Concurrency Control

Mechanisms that ensure multiple transactions can occur simultaneously without conflicting.

SQL*Plus

A command-line interface for Oracle Database used for querying and managing databases.