Wednesday, April 23, 2014

Database crashed, controlfiles deleted and missing archive logs

Current situation: tonight a database crashed and the controlfiles have been destroyed/deleted. When I tried to open the database then I got:

$ sqlplus "sys/password as sysdba"
SQL*Plus: Release Production on Tue Apr 22 18:03:00 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup

ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size                  2232840 bytes
Variable Size             524291576 bytes
Database Buffers          536870912 bytes
Redo Buffers                5541888 bytes
ORA-00205: error in identifying control file, check alert log for more info

Sunday, April 20, 2014

IP forward and masquerading

Today I was in the challenge to setup a router. We ware at a meeting with a small wireless router connected to the internet and a couple of hardware with copper interfaces only. We didn't had physical access to the wireless router. We just saw the ESSID to connect to. Luckily I had my notebook running Slackware with a wireless and a copper NIC. The situation was like:

Saturday, April 19, 2014

Editing MP3/ID3 tags

A couple of days ago someone asked me how to change the ID3 tag in MP3 files via commandline. There are a couple of programs out there and the first one I found did the job right: id3ed
To get id3ed running download the source from first. Then extract the tar file and build the source:

Friday, April 18, 2014

Setting up a tftp server with Slackware

Setting up a tftp server with Slackware is an extremely easy task. Unlike most
of my articles there is no need of compiling any additional software since
everything is shipped with Slackware. So let's get started.
The first thing you need to do is to edit the inetd.conf file and comment out
the line that's starts with tftp:

Wednesday, April 16, 2014

Destroy a deported disk group

Today I wanted to destroy a disk group that was deported. A import fails because there were missing disks (it was just a test environment so loss of data was wanted):

# vxdg import testdg
VxVM vxdg ERROR V-5-1-10978 Disk group testdg: import failed:
Disk for disk group not found