database articles - church1e's blog

How to reset MySQL root password

Updated 3 May 2019 Read time 2 min(s) 3 sec(s) (2233 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) (1985 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 12 Sep 2012 Read time 2 min(s) 50 sec(s) (1551 visits).

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

Updated 18 May 2009 Read time 3 min(s) 8 sec(s) (2640 visits).

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

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

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

Updated 25 Jan 2006 Read time 2 min(s) 24 sec(s) (3033 visits).

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

Updated 10 Feb 2005 Read time 2 min(s) 23 sec(s) (2537 visits).

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

Updated 10 Feb 2005 Read time 6 min(s) 43 sec(s) (2735 visits).

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

Updated 4 May 2009 Read time 2 min(s) 27 sec(s) (3148 visits).

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

Updated 21 Jul 1999 Read time 6 min(s) 22 sec(s) (2877 visits).

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.

Updated 23 Jul 2009 Read time 1 min 20 sec(s) (3043 visits).

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

Updated 24 Aug 2015 Read time 5 min(s) 12 sec(s) (3133 visits).

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