Oracle 12c

Oracle Administration Notes...

Installations

1. Install Oracle 11gr2 on Ubuntu 10.04
2. Install Oracle XE 10gr2 on Ubuntu 10.04
3. Install SQL Developer 3.0 on Ubuntu 10.04

Managing Oracle Memory

• Memory Management on Oracle 11g
• Oracle Memory Management Methods

Managing Oracle Security

• Oracle Database Security (overview)
• Oracle default Security Features
1. Managing User Accounts: Profiles, Resource Manager
2. Using Application Context
3. Using Virtual Private Database
4. Additional resources
• Oracle Advanced Security

Managing Data Storage

• Oracle data storage: ROWIDs
• Data Movement: Transporting Tablespaces
• Example: Transporting Partitions for Data Warehousing

Partitioning and Parallelism

• Q&As: Partitioning
• Q&As: Parallelism
• Q&As: Parallelism and Advanced Compression

Automatic Storage Management (ASM)

• Oracle Grid Infrastructure and Oracle ASM: Configuration changes in 11g R2
• Oracle Automatic Storage Management (ASM) - Concepts
• Configuring Oracle ASM on Oracle 11gR2
• Oracle ASM on 11g R2: Installing Grid Infrastructure on a standalone server

Oracle Flashback Technology

• Oracle Flashback Technology
• Flashback Transaction
• Flashback Data Archive
• Using Oracle Log Miner (I)
• Using Oracle Log Miner - examples (II)

Backup and Recovery

• (Q)uestions and (A)nswers page
• Oracle Backup and Recovery Solutions
• Oracle Scheduler: Use credentials for a detached job that performs cold backups

Oracle Data Guard

• Q&As: Data Guard, Role Transitions (I)
• DataGuard: Configuring a Physical Standby
• Snapshot Standby: Role Transition cycle
• Data Guard: Switchover to a Physical Standby Database
• Data Guard: Switchover to a Physical Standby (II)

Data Warehousing

• Data Warehouse: Basic Concepts
• Data Warehouse: Concepts on ETL Process
• Q&As: Data Warehosing and Partitioning (I)
• Q&As: Data Warehosing and Partitioning (II)
• Using External Tables

Unix and Linux

• TCP/IP Networking (I)
• Network File System (NFS) - Overview
• Configuring NFS on Ubuntu
• Mounting an NTFS filesystem on Oracle Enterprise Linux
• Resizing a logical volume on Oracle Enterprise Linux (OEL) 5.6

Tips

• Protect passwords in SQL*Plus
• Dealing with message "xterm-256color: Unknown terminal type"

A pint of history

• Oracle: company and database timeline