Shrinking the size of the undo tablespace

-- Create a new undo tablespace with smaller size.
SQL> create undo tablespace UNDO_SMALL datafile ''undo-small.dbf' size
100m;
-- Set new tablespace as undo_tablespace.
SQL> alter system set undo_tablespace=UNDO_SMALL;
-- Drop the old tablespace.
SQL> drop tablespace UNDO_LARGE including contents;

The drop command may give ORA-30013 until existing transactions commit
or rollback.

Install Oracle on HPUX 11.11

There is a problem to install Oracle 10g on HP UX that running on command mode, because Oracle 10g installer will need to run on X-Window.

1) Download the XManager : http://www.netsarang.com

2) Install XManager to any PC, this PC has to be accessible by the HPUX.

3) telnet to your HP UX, type the following :

export DISPLAY={IP address of the PC that installed with XManager}:0.0

4) set oracle home and other path, pls follow the Oracle Installation Guide

5) run the installer :
./runInstaller

Change Screen Resolution For Ubuntu Running On VirtualBox

1) Devices->Install Guest Additions and your virtual Ubuntu should recognize a new CD. Open a terminal and run this command:

sudo /media/cdrom/VBoxLinuxAdditions.run

2) Open your guest machine’s xorg.conf file:

gksu gedit /etc/X11/xorg.conf

Find the device section, which should look like this:

Section "Device"
Identifier "Configured Video Device"
EndSection

Replace to :

Section "Device"
Identifier "Configured Video Device"
Driver "vboxvideo"
EndSection

3) Find the code like this :

Section "Screen"
Identifier "Default Screen"
Monitor "Configured Monitor"
Device "Configured Video Device"
EndSection

replace with :

Section "Screen"
Identifier "Default Screen"
Device "VirtualBox graphics card"
Monitor "Generic Monitor"
DefaultDepth 24
SubSection "Display"
Depth 24
Modes "1024x768"
EndSubSection
EndSection

4) Save the file, and restart your Virtual box.