Database

A collection of tech notes, how to, cheat sheets, hints, tips and resources for anything Database related.

Oracle Secure Backup (obtool) exit codes

posted on 24th Aug, 2015

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

Continue reading...

Oracle lsnrctl commands

posted on 18th May, 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

posted on 4th May, 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

posted on 21st Dec, 2008

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

Continue reading...

System Global Area (SGA)

posted on 25th Jan, 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

posted on 10th Feb, 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

posted on 10th Feb, 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

posted on 21st Jul, 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...