set echo off;

clear screen;

PROMPT

PROMPT COLLECTING USER INFORMATION
PROMPT

ACCEPT database_sid CHAR PROMPT 'DATABASE TO CONNECT TO [ORCL]: ' DEFAULT ORCL
ACCEPT mhsys_password CHAR PROMPT 'PASSWORD FOR USER MHSYS [MHSYS]: ' DEFAULT MHSYS HIDE
PROMPT

prompt CONNECTING USER MHSYS
connect MHSYS/&mhsys_password@&database_sid;

set serveroutput on;
set linesize 100;
spool job_set_ndxsys.log;

prompt SHOWING JOBS
select JOB, SCHEMA_USER,
to_char(NEXT_DATE, 'DD-MON-YYYY, HH24:MI') NEXT_DATE,
INTERVAL, WHAT
from dba_jobs

order by job;

p

set serveroutput on;
set linesize 100;
set echo on;
spool job_remove.log;

select JOB, SCHEMA_USER, BROKEN, WHAT
from dba_jobs;
execute DBMS_JOB.REMOVE(&job_number_to_remove)

commit;

select JOB, SCHEMA_USER, BROKEN, WHAT
from dba_jobs;

spool off;

#!/bin/bash

USER=pako
TARGET=192.168.1.224
tar zcf - /home/${USER} | ssh root@${TARGET} "cd /home/; tar zpxvf -; chown ${USER}.${USER} -R ${USER}"

# Links
http://www.ostc.de/howtos/find-HOWTO.txt

#!/bin/bash

# delete routing for whole network
sudo route del -net 192.168.1.0 netmask 255.255.255.0 dev tap0

# add route to hosts
for ip in {30..50}; do
sudo route add 192.168.1.${ip} dev tap0
done

#!/bin/bash

# todo
# command to configure language
# command to configure timezone

apt-get update
apt-get -y dist-upgrade

# OPTIONAL: configure germany locale
# http://www.thomas-krenn.com/de/wiki/Locales_unter_Ubuntu_konfigurieren
#sudo sed -i 's|en_US.UTF-8|de_DE.UTF-8|g' /etc/environment
#sudo sed -i 's|en_US|de_DE|g' /etc/default/locale
sudo locale-gen de_DE.UTF-8
update-locale LANG=de_DE.UTF-8
update-locale LANGUAGE=de_DE
sudo sed -i 's|XKBLAYOUT="us"|XKBLAYOUT="de"|g' /etc/default/keyboard

reboot

# install ubuntu-desktop
sudo apt-get -y install ubuntu-deskto

script:
https://installit.googlecode.com/hg/install.kvm.sh

# configure locale
wget -q http://www.panticz.de/sites/default/files/scripts/configure_locale.sh -O - | bash -

# install on ubuntu
sudo apt install -y qemu-kvm
# apt-get install -y qemu kvm ubuntu-vm-builder

# install on debian
apt-get install -y kvm
apt-get install -y libvirt-bin
apt-get install -y virtinst

/etc/init.d/libvirt-bin restart

# net
virsh net-start default
virsh net-autostart default

# vg
mkdir /etc/libvirt/storage
cat < /etc/libvirt/storage/vg0.xml

vg0

apt-get install -y pxelinux

# check for current version
# http://www.memtest.org/#downiso

URL=http://www.memtest.org/download/5.01/memtest86+-5.01.bin

wget -q ${URL} -P /tmp/

mkdir /var/lib/tftpboot/memtest
mv /tmp/memtest86+-*.bin /var/lib/tftpboot/memtest
cd /var/lib/tftpboot/memtest
ln -s memtest86+-*.bin memtest86+

echo "confiure tftpboot..."
mkdir -p /var/lib/tftpboot/pxelinux.cfg
cat < /var/lib/tftpboot/pxelinux.cfg/memtest86+.conf
LABEL linux
MENU LABEL memtest86+
KERNEL /memtest/memtest86+
EOF

echo "MENU INCLUDE pxelinux.cfg/memtest86+.conf" >

# view all available printer
lpstat -p -d

# enable webadmin
vi /etc/cups/cupsd.conf
#Listen localhost:631
Listen 0.0.0.0:631

Allow From 192.168.1.0/24

Allow From 192.168.1.0/24

# print file from command line
lpr -P DeskJet_695C YOUR_FILE.pdf

# parallel
# install DeskJet_695C
sudo lpadmin -p HP695C -v parallel:/dev/lp0 -E -P /tmp/DeskJet_695C.ppd

# usb
hp:/usb/hp_business_inkjet_2300?serial=CN39E130GB

# PDF printer
sudo apt-get install cups-pdf
lpadmin -p PDF -v cups-pdf:/ -E -P /usr/share/ppd/cups-pdf