Ubuntu Howto: Install Oracle

August 31, 2007 at 16:16 · Tags: , , , , , ,

Installing Oracle on Ubuntu is fairly easy, since Oracle has created a Debian and Ubuntu package repository, so it is possible to download and install the Oracle database software using apt-get and aptitude.

Howto use the Oracle Debian and Ubuntu Repository:

Add the following lines to the /etc/apt/sources.list

# Oracle Repository
deb http://oss.oracle.com/debian unstable main non-free

Update the package repository database with:

cc@ray:~$ sudo apt-get update

Now you should be able to install the following Oracle software:

  • libaio
  • oracle-xe-client
  • oracle-xe
  • oracle-xe-universal

Install the Oracle Express packages

sudo aptitude install oracle-xe oracle-xe-client

Configure using:

sudo /etc/init.d/oracle-xe configure

Access the nice Oracle web interface by pointing your Firefox to:

http://127.0.0.1:8080/apex

Updated:
The installation process might report that the Oracle packages are not gpg signed, but you should be able to install the packages anyway.

You can avoid this report by added the Oracle gpg-public key to your apt-key chain

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -

Read more on Oracle and Debian and Ubuntu here

Related posts:

  1. Howto Install Oracle on Debian
  2. Ubuntu Howto: Install Sun Java
  3. Howto: Create your own Debian or Ubuntu package repository
  4. Howto Install Sun Java on Debian Etch
  5. Ubuntu Howto: Install Ruby and Ruby on Rails
  6. Howto: Install Ruby and Rails on Debian or Ubuntu
  7. Howto: Install Windows Vista Fonts in Ubuntu
  8. Ubuntu Howto: Install Xen
  9. Ubuntu and Ruby
  10. Howto Install Fedora From a USB Flash Key Drive

Comments (10)

Optimize MySQL for Low Memory Use

March 22, 2007 at 7:32 · Tags: , , , , , ,

MySQL LogoMySQL is a light database engine compared to many of it’s rivals, but for some reason the Debian MySQL-server package contains a setup that makes it very heavy and memory consuming. The Debian version of becomes memory consuming because it comes with config file where MySQL’s most memory consuming and seldom used storage engine InnoDB is enable. As result of this the MySQL server instance uses around 100MB of memory while almost idle.

And here comes the optimization tip.

Since the InnoDB storage engine is used very seldom it can be disable in most cases and let the server save almost about 100MB of memory.

To disable to InnoDB storage engine add this to my.cnf (the default MySQL configuration files) in /etc/mysql/
skip-innodb

More on MySQL and Apache optimization and here

Related posts:

  1. MySQL Optimization and Performance Tips
  2. Optimize MySQL Performance With MySQLTuner
  3. Howto: How to Reset the MySQL Root Password
  4. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  5. Slow Query Log Analyzes Tools
  6. Sun acquires MySQL
  7. WSJ: Sun to Use Flash Memory in Servers
  8. WSJ: Sun to Use Flash Memory in Servers
  9. MySQL Performance Monitoring and Optimization Tools
  10. Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)

Comments (5)

Forrester Research: Open Source Databases Are Cheaper

November 22, 2006 at 16:50 · Tags: , , , , , , , , ,

Open source databases can save enterprises up to 60 per cent over proprietary products, according to data collected by Forrester Research.

Noel Yuhanna, a senior analyst at Forrester covering database management systems, estimated that average savings on the total cost of ownership are about 50 per cent. The data is based on surveys and customer interviews.

Open source databases such as Enterprise DB, Ingres and MySQL do not carry licence fees, and management tools tend to be less expensive than for proprietary databases from Oracle, Microsoft and IBM.

Open source databases ‘60 per cent cheaper’ @ Vnunet.com

Related posts:

  1. Nasdaq moves to open-source
  2. InfraRecorder: Open Source CD Burning for Windows XP/Vista
  3. Skype Open Source
  4. Ubuntu Howto: Install Oracle
  5. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  6. Sun acquires MySQL
  7. an ex-microsoft employee’s view on Linux and the open source community
  8. Windows Open Source Software
  9. Open Source EPJ
  10. Major List of Useful Open Source and Freeware Software

Comments

Recover (Crack) a password from a Microsoft Access Database (mdb)

September 22, 2006 at 15:48 · Tags: , , , , , , , , ,

Today, I had to do a password recovery from an old Microsoft Access Database. First I thought that this was a very time consuming task, but as I searched on Google I found a great number of utilities to do that kind of password recovery / crack, but none of the shiny tools I found in the first round were free, so I searched on and found a free utility called Access PassView – and it’s able to do the job. I tried to password protect a sample access database and it worked – it recovered the password within less than a second :)

The author of Access PassView mentions that it has a few limitations; In Access 2000/XP files, it cannot recover passwords that contains more than 18 characters and it’s only able to recover the main database password. It cannot recover the user-level passwords.

You can download Access PassView from this page or directly from this location.

Access PassView - Password Recovery a Microsoft Access Database

Related posts:

  1. Crack or Recover Password Protected Excel Spreadsheet
  2. Crack mdb Password
  3. Crack or Recover Read-only Password Protected Word Document
  4. HackerGuide: Crack Password Encrypted Zip-files
  5. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  6. How to hack Windows password with Ophcrack
  7. Crack Cisco VPN (hack)
  8. Crack zip password with fcrackzip
  9. Crack pdf password with pdfcrack
  10. Crack Windows Password

Comments (35)

MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL

September 22, 2006 at 14:01 · Tags: , , , , , , , ,

Today I was working on how to convert an old Microsoft Access database into a MySQL database. This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin.

To export a given table from a mdb-file, we type:

mdb-export db.mdb customers >> customers.csv

In my case, since I got some danish characters, I need to force mdbtools to encode everything as ISO8859-1 instead of UTF-8, which is the default. This can be done by setting the environment variable MDB_ICONV to ISO8859-1

export MDB_ICONV="ISO8859-1"

The resulting CSV-files coult be imported into MySQL using phpMyAdmin.

MySQL Logo

Another howto on database migration ms2pg – Migrate Microsoft SQL Server Database to PostgreSQL Database.

Related posts:

  1. Sun acquires MySQL
  2. Optimize MySQL for Low Memory Use
  3. Recover (Crack) a password from a Microsoft Access Database (mdb)
  4. MySQL Performance Monitoring and Optimization Tools
  5. NO to the Microsoft Office format as an ISO standard
  6. Forrester Research: Open Source Databases Are Cheaper
  7. MySQL Optimization and Performance Tips
  8. Howto: How to Reset the MySQL Root Password
  9. Executing SQL Statements from a Text File
  10. Slow Query Log Analyzes Tools

Comments (5)

Set MySQL Auto Increment Manually

August 31, 2006 at 12:36 · Tags: , , , 

ALTER TABLE table_name AUTO_INCREMENT = 100000

Related posts:

  1. MySQL: Remove Duplicate Entries
  2. Optimize MySQL Performance With MySQLTuner
  3. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  4. MySQL Concatenate: Adding String At The End Of Field Data
  5. Mysql Data Import
  6. Optimize MySQL for Low Memory Use
  7. Howto: How to Reset the MySQL Root Password
  8. MySQL Optimization and Performance Tips
  9. MySQL Performance Monitoring and Optimization Tools
  10. Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)

Comments (5)