Database

A collection of techical notes,cheat sheets,how-to documents,hints,tips,resouces and other odds'n'ends for anything database related.

Oracle Secure Backup (obtool) exit codes

Aug 24, 2015

When obtool encounters an error, it reports an exit code with a brief description.

Continue reading...

Oracle lsnrctl commands

May 18, 2009

The listener process runs on the database server. It receives client requests and manages the traffic of these requests to the database server.

Continue reading...

Enable/Disable archivelog mode

May 4, 2009

The following are the steps required to enable archive log mode on an Oracle 10g or 11g database.

Continue reading...

Oracle export and import Utilities

Dec 21, 2008

Export (exp) and import (imp) are the Oracle utilities used to perform logical database backup and recovery.

Continue reading...

System Global Area (SGA)

Jan 25, 2006

The maximum size of a single shared memory segment is specified by the shmmax (shm_max on Tru64 UNIX) kernel parameter.

Continue reading...

Oracle Users and Passwords

Feb 10, 2005

The default accounts are: sys, system, dbsnmp and sysman. The following table provides a basic description of the of the default users.

Continue reading...

Oracle background processes

Feb 10, 2005

An oracle database is run as an instance. A database server can run multiple instances and each instance is made up of different components.

Continue reading...

Quick start on Oracle8i and Solaris

Jul 21, 1999

This page assumes you want an oracle install on a single disk, with minimum memory, to just play around with oracle and learn the basics.

Continue reading...