Database articles - church1e's blog

Oracle Secure Backup (obtool) exit codes

Published 24 Aug 2015 Read time 5 min(s) 12 sec(s) (3328 visits).

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

Updated 3 May 2019 Read time 2 min(s) 3 sec(s) (2316 visits).

Have you forgotten MariaDB root password? You don't know how to recover it. Not to worry, use these steps to reset MariaDB root password.

Updated 4 Sep 2018 Read time 1 min 50 sec(s) (2055 visits).

Have you forgotten MariaDB root password? You don't know how to recover it. Not to worry, use these steps to reset MariaDB root password.

Published 12 Sep 2012 Read time 2 min(s) 50 sec(s) (1628 visits).

There are numerous advantages to run multiple database instances on the same physical server.

Published 23 Jul 2009 Read time 1 min 20 sec(s) (3126 visits).

The table below shows the System V IPC parameter and the corresponding Soalris resource controls for Oracle on Sun Solaris 10 OS.

Published 18 May 2009 Read time 3 min(s) 8 sec(s) (2853 visits).

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

Published 4 May 2009 Read time 2 min(s) 27 sec(s) (3251 visits).

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

Updated 12 Jun 2015 Read time 5 min(s) 27 sec(s) (841 visits).

imp and exp are Oracle utilities that allow us to make imports and exports of data objects.

Updated 12 Jun 2015 Read time 5 min(s) 11 sec(s) (2547 visits).

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

Published 25 Jan 2006 Read time 2 min(s) 24 sec(s) (3146 visits).

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