# oracle 18xe
lxc launch images:oracle/7 oracle7

# new version:
https://raw.githubusercontent.com/panticz/installit/master/install.oracle-xe.sh

# fix
W: GPG error: https://oss.oracle.com unstable Release: The following signatures were invalid: KEYEXPIRED 1378511808 KEYEXPIRED 1378511808 KEYEXPIRED 1378511808

# add oracle repository
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | apt-key add -
cat < /etc/apt/sources.list.d/oracle.list
deb http://oss.oracle.com/debian unstable main non-free
EOF

# update repository
apt-get update

# install oracle
apt-get i

#!/bin/bash

MAX_HEIGHT=150
DENSITY=72
TARGET=/tmp/nl_$(date -I)
SOURCE=/media/bilder/300dpi

# create target directory
[ -d ${TARGET} ] || mkdir ${TARGET}

# convert images
for i in $@; do
IMG=${i}.jpg
convert "${SOURCE}/${IMG}" -resize "x${MAX_HEIGHT}" -density "${DENSITY}x${DENSITY}" -sharpen "0x1" "${TARGET}/${IMG}"
echo "${IMG}: $?"
done

# save partition / disk to image
dd if=/dev/hda bs=16065b | gzip -9 > hda_backup.dd.gz

# restore partition / disk from image
gunzip -dc hda_backup.dd.gz | dd of=/dev/hda bs=16065b

# copy over network
netcat -l -p 1234 | dd of=/dev/hdc bs=16065b
dd if=/dev/hda bs=16065b | netcat TARGET_IP 1234

# backup mbr
dd if=/dev/hda of=mbr.img bs=512 count=1

# restore mbr (better will by bs=446)
dd if=bs.img of=/dev/hda bs=512 count=1

# view all manual selections
for PACKAGE in $(debconf-show --listowners); do
echo ${PACKAGE}
debconf-show ${PACKAGE} | grep "*"
done

apt-get install debconf-utils

# replace with tabulator key
for i in $(debconf-show ${PACKAGE} | grep "*" | cut -d" " -f2 | cut -d":" -f1); do
debconf-get-selections | egrep "$i";
done

debconf-get-selections | grep -v "#"

debconf-show ddclient | grep '*'

apt-get install debconf-utils
sudo debconf-set-selections

# show installed packages
debconf-show --listowners
debconf-show mysql-server-5.0 | grep "*" | cut -

# install
sudo apt-get install -y stress

stress --cpu 8 --io 4 --vm 2 --vm-bytes 128M --timeout 600s

# LINKS
http://packages.ubuntu.com/saucy/stress

# rsync only files matching pattern
rsync -avz --include "*_small.jpg" --exclude "*.jpg" dir1/ dir2/
rsync -avz --include "*/" --include "*.jpg" --exclude "*" dir1/ dir2/
rsync -avz --include "*/" --include "**.svn**" --exclude "*" just-checked-out/ old-and-modified/

# rsync over ssh
rsync -are ssh root@192.168.1.2:/data/bilder /mnt/

# test

apt-get install live-helper cdebootstrap

cat <> /usr/share/cdebootstrap/suites
Suite: hardy
Config: generic-ubuntu
Keyring: ubuntu-archive-keyring.gpg
EOF

# sed
/usr/bin/lh_chroot_sources
${LH_DISTRIBUTION}/updates
${LH_DISTRIBUTION}-updates

mkdir ~/live && cd ~/live

lh_build

http://clemensfam.org/john/?p=39

sudo su

cd /usr/src/
apt-get install dpkg-dev lm-sensors dialog build-essential
echo "deb-src http://archive.ubuntu.com/ubuntu hardy main universe multiverse restricted" >> /etc/apt/sources.list
apt-get update
apt-get source linux-image-$(uname -r)
ln -sf /usr/src/linux-2.6.24/ /usr/src/linux

# 1.3.0
wget http://downloads.sourceforge.net/sourceforge/va-ctcs/ctcs-1.3.0.tgz -P /tmp
tar xzf /tmp/ctcs-*.tgz -C /tmp
cd /tmp/ctcs-*/
make all

# 1.3.1
wget http://downloads.sourceforge.net/sourceforge/va-ctcs/ctcs-1.3.1-pre1.tgz -P /tmp
tar xzf /tmp/ctcs-*.tgz -C /tmp
cd /tmp/ctcs-

BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'update_snapshots',
job_type => 'STORED_PROCEDURE',
job_action => 'UPDATE_SNAPSHOT',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=5',
end_date => NULL,
enabled => TRUE
);
END

-- 10xe
DBMS_SCHEDULER.create_job (
job_name => 'update_invoice_positions',
job_type => 'PLSQL_BLOCK',
job_action => 'K.INVOICE;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=0',
end_date

set pagesize 50000
set linesize 240
set echo off

column job format 9999 heading 'Job' justify right
column schema_user format a20 heading 'Oracle User' justify left
column broken format a6 heading 'Broken' justify left
column last_date format a20 heading 'Last Date' justify left

column this_date format a20 heading 'This Date' justify left
column next_date format a20 heading 'Next Date' justify left
column interval format a60 heading 'Interval' justify left
column what format a80 heading 'What'