ORA-01552: cannot use system rollback segment for non-system tablespace 'MY_TS'

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      MANUAL
undo_retention                       integer     900
undo_tablespace                      string



SQL>  select segment_name, tablespace_name, initial_extent,status  from dba_rollback_segs;

SEGMENT_NAME                   TABLESPACE_NAME                INITIAL_EXTENT
------------------------------ ------------------------------ --------------
STATUS
----------------
SYSTEM                         SYSTEM                                  57344
ONLINE

_SYSSMU1$                      UNDOTBS1                               131072
OFFLINE

_SYSSMU2$                      UNDOTBS1                               131072
OFFLINE

UNDOTBS1                       SYSTEM                                  16384

OFFLINE

12 rows selected.

SQL> create undo tablespace UNDOTBS1
2 datafile '/oracle/ora90/oradata/orcl/undotbs01.dbf' size 10M;Tablespace created.

SQL> alter rollback segment UNDOTBS1 online;

Rollback segment altered.

Enable copy on select in MAC OSX terminal

1. Install iTerm a nice replacement to the built in Terminall.app which uses X11 server.

2. Open X11 Preferences and make sure all check boxes are selected:

Now:
- whatever you select in iTerm is available on OSX Pasteboard and can be pasted in other applications.
- whatever is in the Pasteboard can be inserted in iTerm with a middle click.

Note: For those wondering how to use the middle click easily with the trackpad I'd suggest installing the MiddleClick app. With it you can paste in the terminal with a single tree-finger tap.

Using Alcatel X220L 3G modem with Linix

If you have an Alcatel x220l 3G modem here is how to get it woring with Linux.

You will need the usb-modeswitch package installed, wvdial is not required if you intend to use the NetworkManager applet:

apt-get install usb-modeswitch wvidial

create the following symbolic link:

ln -s  /etc/usb_modeswitch.d/1bbb\:f000  /etc/usb_modeswitch.d/alcatel_x220l

configure udev by creating this file

/etc/udev/rules.d/50-x220l.rules

with the following content:

SUBSYSTEM=="usb", SYSFS{idVendor}=="1bbb", SYSFS{idProduct}=="f000", RUN+="/usr/sbin/usb_modeswitch -c /etc/usb_modeswitch.d/alcatel_x220l"
SUBSYSTEM=="usb", SYSFS{idVendor}=="1bbb", SYSFS{idProduct}=="0017", RUN+="/sbin/modprobe usbserial vendor=0x1bbb product=0x0017"

service udev reload

Now you should have a functional modem device at /dev/ttyUSB4.
The easiest way to get your internet connection up is to configure wvdial. The following parameters are used by the Vivacom network but configuration is pretty much the same for all operators (only Init2, username and passwords differ). Put in /etc/wvdial.conf the following:

[Dialer Defaults]
Modem = /dev/ttyUSB4
ISDN = 0
Modem Type = Analog Modem
Baud = 460800
Init1 = ATZ
Init2 = at+cgdcont=1,"IP","vivacom.bg"
Phone = *99#
Dial Attempts = 5
Stupid Mode = on
Dial Command = ATDT
Idle Seconds = 7200
Ask Passwords = 0
Password = "vivacom"
Username = "vivacom"
Carrier Check = on
New PPPD = 1
Auto DNS = on

Free internet access scripts - resume of developement

Continuing the post about the collection of scripts for using free Internet access here are some updates.
Firstly the scripts for collecting and spofing MAC and IP adresses in a LAN have new location. Here is a link for the package containing both python and perl versions  http://9mhz.info/fisp-0.3.1.tar.gz

A new version will be released soon. Planned features include  MySQL support and some heuristics for choosing which MAC address will be picked up for assignment.  Entry appearance patterns will be applied for some IP-MAC pairs like 'business hours only' etc.

Find the location of a GSM cell tower by CellID

There are several sites [1] where you can look up the geographical coordinates of a GSM tower based on its CellID, MCC (Mobile Country Code), MNC (Mobile Network Code) and LAC (Location Area Code). The problem with these sites is that their databases are filled by volunteers and the coverage is at almost useless level. However it seems that companies like Google and Nokia have their own databases used in conjunction with their maps applications which are astonishingly accurate and complete.
So the question is how to (if possible) get information form these databases for personal use.

The answer is:  www.9mhz.info
You can use this site to get the location information of a cell tower. This page uses the Google maps database and shows the location on the map.

How to check the cell ID on Nokia phones

Here is a snip from the Nokia AT command description document regarding the CellID and signal level parameters:

AT+CREG=2
OK
AT+CREG?
+CREG: 2,1,"1030","639E"

The returned values are as follows:
"2" reflects the current "+CREG" setting (2 means "Enables unexpected network
registration and location information messages" )
"1" indicates that the phone is registered with the network
"1030" is the Location Area Code (LAC) in hex (4144 decimal)
"639E" is the CellID (CI) in hex (25502 decimal).


AT+CSQ
+CSQ: 13,99

Returns:
13 = signal level, 99 = bit error rate unknown.

Logitech QuickCam

046d:08f0 Logitech, Inc. QuickCam Messenger with Ubuntu Lucid:

1. Edit /etc/modprobe.d/blacklist.conf and add:

blacklist gspca_stv06xx
blacklist gspca_main

2. Execute:

rmmod gspca_stv06xx
rmmod gspca_main

3. Execute:

rmmod quickcam_messenger
modprobe quickcam_messenger brightness=10000 hue=10000 contrast=10000 whiteness=10000

3D acceleration with i965

Optimizing the performance of an Intel 965 graphics card could be a tricky job. The problem gets bigger if you want to use Compiz and have to use the 3D acceleration. There are three available acceleration methods for Intel cards: the old 'XAA', the stable 'EXA' and the not-ready-yet 'UXA'. I found that the default settings give rather poor performance in Unbuntu Jaunty and the result from glxgears was ~480 FPS. With the following settings in xorg.conf I was able to get 750 FPS.


Section "Device"
Identifier "Configured Video Device"
Option "AccelMethod" "EXA"
Option "MigrationHeuristic" "greedy"
Option "ExaNoComposite" "false"
EndSection


Also setting this variable in /etc/environment seems to help as well:

INTEL_BATCH="1"


Disable frequent hard disk spindown in Ubuntu

By default the hdparm settings in Ubuntu are not hardware friendly so some tuning might be needed to adjust your hard disc parameters. Example for this is the Load_Cycle_Count counter which usually gets increased once in a minute without heavy disc usage. Most of the manufacturers construct their disks with MTBF of 300,000 load cycles, so you might reach it within one year. You don't want to buy a new HDD once a year, don't you? Here is a fix.

Edit /etc/hdparm.conf and add the following section (replace /dev/sda with your actual device):

/dev/sda {
apm=254
spindown_time = 242
read_ahead_sect = 2
keep_settings_over_reset = on
}


USSD Spec - Stage 2

Digital cellular telecommunications system (Phase 2+);
Unstructured Supplementary Service Data (USSD) - Stage 2

ETSI TS 100 549 V7.0.0 (1999-08)

USSD Spec - Stage 1

3rd Generation Partnership Project;
Technical Specification Group Services and System Aspects;
Unstructured Supplementary Service Data (USSD) - Stage 1
(Release 1999)
22090-310

SMPP protocol spec

SMPP V3.4 Specification - smpp_v3_4_issue1_21

Globul 3G data connect

If you are staring at the sentence "Supported OS: Windows XP/Vista" on your 3G data device and have no clue how to get it working on Linux then this post might help you.

I got a ZTE MF632 device working under Ubuntu Hardy with KPPP.

• Create a new file /etc/udev/rules.d/57-zte-net.rules and put the following in it

ACTION!="add", GOTO="ZTE_End"

# Is this the ZeroCD device?
SUBSYSTEM=="usb", SYSFS{idProduct}=="2000",
SYSFS{idVendor}=="19d2", GOTO="ZTE_ZeroCD"

# Is this the actual modem?
SUBSYSTEM=="usb", SYSFS{idProduct}=="0001",
SYSFS{idVendor}=="19d2", GOTO="ZTE_Modem"

LABEL="ZTE_ZeroCD"
# This is the ZeroCD part of the card, remove
# the usb_storage kernel module so
# it does not get treated like a storage device
RUN+="/sbin/rmmod usb_storage"

LABEL="ZTE_Modem"
# This is the Modem part of the card, let's
# load usbserial with the correct vendor
# and product ID's so we get our usb serial devices
RUN+="/sbin/modprobe usbserial vendor=0x19d2 product=0x0001",
# Make users belonging to the dialout group
# able to use the usb serial devices.
MODE="660", GROUP="dialout"

LABEL="ZTE_End"

• Plug your device in the USB port. This should create three new devices /dev/ttyUSB0, /dev/ttyUSB1 and /dev/ttyUSB2. You now can use the first one to connect to the network.


• Use your favourite PPP program to configure new connection.  Don't forget to set the following parameters:

Modem initialization string 2 = AT+CGDCONT=1,"IP","globul"
Phone = *99***1#
Username = globul
Password = globul

VMware && USB && Ubuntu ?

To be able to use USB devices with VMware guest OSes under Ubuntu Gutsy you have to uncomment lines 42-45 in /etc/init.d/mountdevsubfs.sh

mkdir -p /dev/bus/usb/.usbfs
domount usbfs "" /dev/bus/usb/.usbfs -obusmode=0700,devmode=0600,listmode=0644
ln -s .usbfs/devices /dev/bus/usb/devices
mount --rbind /dev/bus/usb /proc/bus/usb

Then conect with VM->Removable devices -> USB devices

OpenSSL commands

Some useful openssl commands.

Check certificate details:

openssl  verify -verbose -issuer_checks server.crt

Generate new sertificate:

openssl req -new -x509 -days 365 -key server.key  -out server.crt

Check the modulus of an SSL certificate and key:

openssl rsa -noout -modulus -in server.key | openssl md5

openssl x509 -noout -modulus -in server.crt | openssl md5

Internet via WM6 device on Linux (USB)

This article shows how to use a Windows Mobile 5/6 device’s GPRS connecton with USB cable on Linux. The ‘conventional’ way is to use the /dev/ttyUSB device as a regular modem but since we are quite off the dial-up era we want to connect in a more modern way.

Microsoft provides a Remote NDIS stack, a derivative of the original USB communications device class  CDC to connect usb devices. It can be used in linux with the rndis_host kernel module. To avoid patching your kernel there is a simple way to get an internet connection.

svn co https://synce.svn.sourceforge.net/svnroot/synce/trunk/usb-rndis-lite

cd usb-rndis-lite/
make
sudo ./clean.sh
sudo make install

Now just plug in the USB cable and connect your device to the network through the Network sharing menu. Voila

Борек

• 500г. кайма


• 10 глави лук


• сол и пипер на вкус


• газирана вода


• кори за баница


• 4-5 яйца


• олио

Една тава се намазва с олио. Намазват се поединично корите с олио така че мазнината да се разпредели равномерно. Каймата се запържва с лука и пипера след което готовата плънка се разнася върху двойка кори. По този начин се завиват всички кори и се нареждат в тавата като се нарязва предварително. След като се запече се добавя сместта от газираната вода и яйцата.

Карловска луканка

На 4кг. смляно свинско (може и конско+пуешко) месо се прибавят 2 кг. говеждо смляно месо и 1 кг. сланина на дребни кубчета. Към всеки килограм от сместа се прибавя 1 кг. сол, 1/2 лъжица захар, чубрица, черен пипер и кимион на вкус. Сместа се омесва добре като от време на време се налива по 1 л. вода. Оставя се 1 нощ и на следващия ден се напълват с нея говежди или свински черва, като се усукват през 25-30 см. Луканките се завързват в двата края със здрав конец, надупчват се с игла, за да излезе въздуха и се окачват на сухо и проветриво място. През 2-3 дена се отъняват и оформят с точилка. След като изсъхнат добре се увиват отделно в хартия, нареждат се в съндъче и се посипват с дървена пепел.

Рецептата на Данчо

SB450 HDA Audio under Linux

I had some troubles to get any sound out of my Toshiba notebook with the recent kernels 2.6.21 and 2.6.22.  My sound card is

00:14.2 Audio device: ATI Technologies Inc SB450 HDA Audio (rev 01)

However it is working with 2.6.23-rc4 vanilla kernel. I don’t know whether it is a problem in alsa or in the kernel itself but after several hours of googling I finally got it playing.

Firstly you have to put in  /etc/modprobe.d/aliases or whatever module aliases file you have the following

alias snd-card-0 snd-hda-intel

and secondly in /etc/modprobe.d/alsa-base this one

options snd-hda-intel model=auto enable=1 index=0

and voila! Adjust your sound levels with alsamixer

Макарони на фурна

Продукти за една тава:

• 1 пакет макарони


• 800мл прясно мляко


• 1 ч. ч. кристална захар


• 2 пак. ванилия


• 4 яйца

Макароните се сваряват в подсолена вода с 4-5 с.л. олио. След това се слагат в намазана с олио тава заедно със сместа от яйцата, захарта, млякото и ванилията. Разбъркват се леко за да се разпределят развномерно в тавата и се слагат да се пекат във фурната на 200 градуса. Сервират се по желание със сирене.