Oracle DB Knowledge Base

*** WORK IN PROGRESS ***

The process of including documentation here is very slow.

I need to remove or change all sensitive data (IP addresses, names, etc).

INSTALL

PREPARE example Oracle DB installation on Virtualbox Linux instance.

Linux installation under Virtualbox, kernel setup.

Creating the ASM environment using Linux loopback devices, creating ASM disks.

Allows identical environment like in basic Oracle DB Administration course.

INSTALL manually test ORACLE DB on Windows or Linux.

Manually create database and setup SQL*Net connections.

Creates data files on local disk, no ASM possible.

It is good for testing SQL.

RMAN

RMAN-06025 error - no backup of log thread 1 seq 2337 scn 644417475 found to restore

Error that can happen during RMAN BACKUP DUPLICATE, e.g. database cannot be opened

because there is missing archive log. The procedudure here fixes that issue.

Demonstrates how to search for data in unencrypted backup files and

how to implement encryption using Oracle wallet.

RMAN SETUP - how to setup RMAN environment.

SQL commands to create tablespace and user.

ORA ERRORS

ORA-600 error - how to understand better this kind of error. When you get this kind of error

it looks terrible, but to locate the error in the source code it is very simple, there is one unique

place in the code for every distinct ORA-600 error.

ORACLE DB KERNEL

Formula how Oracle distinguishes small and big tables in db buffer cache.

In other words, this has influence to decision when to perform direct path read.

Involves hidden parameter _small_table_threshold.

JDBC

Example how Oracle to use JDBC.

Driver installation, connect string, example Java program.