ORA-01536: space quota exceeded for tablespace xyz

Today I had this error:

ORA-01536: space quota exceeded for tablespace

So it seems that my user couldn't write to his default tablespace. So deceided to check my user:

SQL> select tablespace_name, username, bytes, max_bytes from dba_ts_quotas where username like '%KAREL%';
no rows selected

Replace lilo with grub2

As a Slackware user I use lilo as bootloader by default. But I also like to change things and try out new/other things. One is grub2 which I'll explain a little in this article. The topics of this article are:

Create a backup of your current boot loader
Download, compile and install grub2
Generate a basic configuration and install grub2 into MBR
Define a new timeout
Change the distributor from GNU/Linux to Slackware
Loading the kernel in framebuffer
Changing menu colors
Add a initrd

TNS lookup over LDAP

This article describes how to migrate tnsnames.ora into LDAP. My current tnsnames.ora looks like this:

$ cat tnsnames.ora
...
PINK=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.100)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PINK)(GLOBAL_NAME=PINK)))
FLOYD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.100)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=FLOYD)(GLOBAL_NAME=FLOYD)))
...

Update your bios with Linux

I was thinking a lot about a bios update for my HTPC lately. The hardware is a ASUS Pundit P2-M2A690G running Slackware Linux 14.0 and XBMC. The bios itself allows a bios update through a special prepared CD and some other options but that was not what I was looking for. I just wanted to download the latest bios and install it. After some research I found a pretty cool software that did the job: flashrom.

Mount a ZFS dataset

Mounting an unmounted ZFS dataset is very easy. Eg I have a ZFS pool called orapool. Within in this pool I have various datasets like u01, u02, ... and u06:

# mount | grep u06
/u06 on orapool/u06 ...

Wake-On-Lan with Linux

I have two systems. One is my HTPC and the other is my notebook (both running slackware as usual). Both system are connected via my home router. My HTPC is connected directly via lan cable to my home router and my notebook is connected to my home router via wireless lan. In my case I want to wake up my HTPC from my notebook. To check if WOL is supported use the tool ethtool: 

Create SPFILE from PFILE

PFILE: traditional init.ora file, changes via eg. vi
SPFILE: binary file, changes via SQL 'alter system...'

To create a spfile login to your database as sysdba locally:

$ sqlplus "sys/oracle as sysdba"

Run the following SQL statement to create a binary spfile from a text pfile: 

Change Core behaviour in AIX

When you need to change the core behaviour in AIX then run lscore the check the current settings, eg.:

# lscore
compression: off
path specification: off
corefile location: not set
naming specification: off

Suspend to disk/ram with Linux

This article describes the following topics:

Suspend to disk
Suspend to ram
Stand-By
Configure buttons for ACPI events
Issues with KDE
Issues with VT6102 (Via Rhine NIC)

List DVD content

If you need to know what is on your DVD then you can use mplayer. With the right option mplayer lists the content of any DVD. This is very useful if you need to copy your DVD's to harddisk etc. (especially for TV series on DVD). Just run the following mplayer command to list the DVD content (output truncated - very):