SQL> set define off
Aug 22
Jul 21
eg:
1. alter database drop logfile group 1;
2. alter database add logfile group 1 (
‘/u01/oralog/redo01a.log’,
‘/u02/oralog/redo01b.log’) size 250m reuse;
that’s it. Keep in mind that it’s not possible to drop the “CURRENT” log group (switch to another redo log group with: alter system switch logfile). If the status of the log group you want to recreate is “ACTIVE” then perform a global checkpoint (alter system checkpoint global).
Taken from: http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_34.shtml
Jul 04
./runInstaller -silent -responseFile /home/oracle/linux_x64/response/additional_agent.rsp
Jul 04
If you want to manually remove Oracle Home(s) from the Ora Inventory then try this one:
./runInstaller -silent -detachHome ORACLE_HOME=[absolute path to Oracle Home]
runInstaller is available in any Oracle Home under oui/bin.
Jan 24
If you want users other than the owner to access a fuse mount / encrypted directory you
need to specify the “allow_other” fuse option!
encfs /home/dummy/.private /home/dummy/private – -o allow_other
Unmount with:
fusermount -u /home/dummy/private
Dec 27
This is a handy utility for the graphical analysis of the Linux SAR Output.
Dec 01
sudo mkdir /etc/adobe sudo su sudo echo \"OverrideGPUValidation = 1\" >> /etc/adobe/mms.cfg
works for me.
Reference:
http://ubuntuforums.org/showthread.php?t=1593363&page=4 http://www.noobrescue.com/blog/flash-fullscreen-doesnt-work-on-ubuntu-10-10
Nov 26
* Shutdown the guest
* Find the vdisk image file and (if increasing) add size to the disk (in this case 2GB):
dd if=/dev/zero bs=1M count=2000 >> system.img
* Attach image file as block device in Dom0:
xm block-attach 0 ‘file:/OVS/templates/System.img’ xvda w
* List partitions:
fdisk -ul /dev/xvda
Disk /dev/xvda: 16.4 GB, 16462456320 bytes
255 heads, 63 sectors/track, 2001 cylinders, total 32153235 sectors
Units = sectors of 1 * 512 = 512 bytes
Device Boot Start End Blocks Id System
/dev/xvda1 * 63 192779 96358+ 83 Linux
/dev/xvda2 192780 23824394 11815807+ 83 Linux
/dev/xvda3 23824395 28049489 2112547+ 82 Linux swap / Solaris
* In this case I want to resize xvda2 and I decided to drop and recreate the swap partition
(I’ve used fdisk to drop the swap partition and after the resizing I recreated it wih fdisk and mkswap)
* filesystem check of the partition you want to resize:
e2fsck -f /dev/xvda2
* try to resize the partition with parted:
parted /dev/xvda
-> print (to find the partition number)
-> resize [partition number] / set start and end
** if parted throws “File system has an incompatible feature enabled.” disable partition flags:
(to check which partition flags are set use: tune2fs -l /dev/xvda2)
Remove flags:
tune2fs -O ^has_journal /dev/xvda2
tune2fs -O ^dir_index /dev/xvda2
debugfs -w /dev/xvda2 -R “feature -ext_attr”
Recheck the filesystem: e2fsck -y -f /dev/xvda2
debugfs -w /dev/xvda2 -R “feature -resize_inode”
Recheck it again: e2fsck -y -f /dev/xvda2
* try parted again – it should work now
* after the resize set the partition flags again:
tune2fs -j /dev/xvda2
debugfs -w /dev/xvda2 -R “feature dir_index ext_attr resize_inode”
* recheck the partition:
e2fsck -y -f /dev/xvda2
* find the vdev id (for detaching):
xm block-list 0
* detach the virtual disk:
xm block-detach 0 [vdev id] -f
* Startup the guest
-> everything should be fine!
Jul 19
Jzy3d stands for Java Easy 3d, and allows a rapid display of 3d scientific data. Users can define z=f(x,y) functions binded to (customizable) colormaps, as well as rendering predefined simple 3d shapes programmaticaly or from csv files. Several strategies can be applied to generate surface, such as a Delaunay tesselation that let you build a surface from unknown structured datasets.
The API has been written with the goal to hide the burden of working with OpenGL, 3d polygon ordering and transparency management. Jzy3d replies to the need of a simple tool like plot3d in Matlab and let the user concentrate on its data rather than UI programming.
It’s open-source (BSD license), fast and easy to use – fabulous library!
http://code.google.com/p/jzy3d/
