KB Index

Databases

• 1 Mysql
  • 1.1 Overview
  • 1.2 Install
  • 1.3 Start Mysql
  • 1.4 Install Phpmyadmin
    
• 2 Oracle On Mandrake
  • 2.1 Oracle 10g Express How To - Mandriva 2006 PowerPack
  • 2.2 ORACLE 10g EXPRESS REQUIREMENTS
  • 2.3 STARTING ORACLE 10g EXPRESS
  • 2.4 USING ORACLE 10g EXPRESS - COMMAND LINE/WEB INTERFACE

Mysql

Overview

MySQL is the most widespread Open Source database and is one of the fastest available databases. You can administer it with the phpmyadmin package, the webmin and the Mandrake webadmin tool. You can create a dynamic php based website as the interface for MYSQL, any data input can then be completed by a unique web based form, imagine your personal, or company based website, being able to access data fast, without even seeing the database1.1 You want to collate, and catalog your CD collection; then this is the way to do it. There are many publications on the market in order to learn more.

Install

Open a konsole
su
password
urpmi mysql
MySql

Start Mysql

Open a konsole
su
password
service mysqld start

Install Phpmyadmin

Just install it via the Mandriva Software Manager.

Oracle On Mandrake

Installing Oracle 9i On Mandrake Linux 8.1 (Contribution) {May 14, 02}

David Stevenson describes how to get Oracle8i release 2, version 8.1.6 installed on Mandrake 8.0

Index {Oct. 05, 01}

Introduction {Sep. 14, 01}

Starting Off {Oct. 05, 01}

Pre-Install {Sep. 14, 01}

Installing Oracle {Sep. 14, 01}

Other Sources {Oct. 05, 01}

Oracle 10g Express How To - Mandriva 2006 PowerPack

GUI Install Instructions for Oracle 10g Express on Mandriva 2006 PowerPack

INSTALL ORACLE 10g EXPRESS ON MANDRIVA 2006 PowerPack

Oracle 10g Express may also be referred to as Oracle XE or oracle-xe. To install Oracle 10g Express, you must install the packages "bc" and "libaio1" (libaio1 is available from updates).

• # urpmi bc libaio1

Install the downloaded Oracle 10g Express package.

• # urpmi oracle-xe-10.2.0.1-1.0.i386.rpm

You might see some errors in the Oracle pre-install (%pre) scripts, although pre-installing the package "bc" should address most of these.

ORACLE 10g EXPRESS REQUIREMENTS

The Oracle web site describes the system requirements. Oracle-XE will refuse to install if your disk space, memory footprint and swap doesn't meet Oracle's requirements. You'll also be asked for a password for the system user.

STARTING ORACLE 10g EXPRESS

• # service oracle-xe start

Starting Oracle Net Listener. Starting Oracle Database 10g Express Edition Instance.

If you run "ps ax | grep xe", you'll see a number of processes running.

If you want the service to run at boot, be sure to enable this:

• # chkconfig --add oracle-xe

USING ORACLE 10g EXPRESS - COMMAND LINE/WEB INTERFACE

If you're familiar with Oracle, the command-line sqlplus is available. Oracle-XE is the web interface, which allows you to access all of the features, as well as create database applications in a graphical environment. After installing, and starting Oracle 10g Express, the web-interface is available at:

http://127.0.0.1:8080/apex/

Login initially as the "system" user and enable some user accounts or the sample "HR" account. Within Oracle 10g Express there are links to documentation and tutorials that will quickly get you started in creating a simple application using the web interface.

Wiki Index / top