Wednesday, August 24, 2011

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.


Tuesday, December 21, 2010

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.

Monday, October 25, 2010

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

Friday, October 1, 2010

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.

Friday, September 24, 2010

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.

Friday, September 10, 2010

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.

Monday, August 23, 2010

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