Friday, April 23, 2010

35TB Tape!

http://www.prnewswire.com/news-releases/made-in-ibm-labs-ibm-research-sets-new-record-in-magnetic-tape-data-density-82330257.html


More big tape tech 20-50TB
http://www.spectralogic.com/blog/index.cfm/2010/9/17/Aesop-said-Tape-aint-dead

BigDataMatters.com: The cost of High Availability (HA) with Oracle

BigDataMatters.com: The cost of High Availability (HA) with Oracle

Thursday, April 22, 2010

Oracle 11gR2 on JeOS

I wanna play with Oracle 11gR2 (and swingbench) stuff so Im going to use Oracle Enterprise Linux JeOS in Sun Virtual Box....
http://www.oracle.com/technology/software/products/virtualization/vm_jeos.html
...more to come - unless I get bored or sidetracked

OK it would not even boot - shi7

new virtual box is out now v3.2.0b1 - renamed to Oracle Virtual Box
http://forums.virtualbox.org/viewtopic.php?f=15&t=30286
  • Experimental support for Mac OS X guests
  • Memory ballooning to dynamically in- or decrease the amount of RAM used by a VM (64-bit hosts only) (see the manual for more information)
  • CPU hot-plugging for Linux (hot-add and hot-remove) and certain Windows guests (hot-add only) (see the manual for more information)
  • New Hypervisor features: with both VT-x/AMD-V on 64-bit hosts, using large pages can improve performance (see the manual for more information); also, on VT-x, unrestricted guest execution is now supported (if nested paging is enabled with VT-x, real mode and protected mode without paging code runs faster, which mainly speeds up guest OS booting)
  • Support for deleting snapshots while the VM is running
  • Support for multi-monitor guest setups in the GUI (see the manual for more information)
  • USB tablet/keyboard emulation for improved user experience if no Guest Additions are available
  • LsiLogic SAS controller emulation
  • RDP video acceleration
  • NAT engine configuration via API and VBoxManage

MS data mashup tool

http://www.powerpivot.com/

Microsoft PowerPivot for Excel - a free tool to download up to 100 million rows of data from different sources

Wednesday, April 21, 2010

Script to draw a circle

$seq 60|awk '{x=int(20+10*cos($1/9));y=int(40+20*sin($1/9));system("tput cup "x" "y";echo X")}'

If you do not have seq you can use #yes|head -99|cat -n

install SSH 5 on AIX 5.3

http://sourceforge.net/projects/openssh-aix/
https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=aixbp (get openssl need an IBM login)

#zcat openssl.0.9.8.802.tar.Z | tar -xvf -
#zcat openssh-5.0_tcpwrap.tar.Z | tar -xvf -
# /usr/lib/instl/sm_inst installp_cmd -aQd /tmp/openssl.0.9.8.802/ -f _all_latest -cNgXGY

geninstall -I "a -cgNQqwXY -J" -Z -d /tmp/openssl.0.9.8.802/ -f File 2>&1

File:
I:openssl.base 0.9.8.802
I:openssl.license 0.9.8.802
I:openssl.man.en_US 0.9.8.802


+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
openssl.base 0.9.8.802 # Open Secure Socket Layer
openssl.license 0.9.8.802 # Open Secure Socket License
openssl.man.en_US 0.9.8.802 # Open Secure Socket Layer

<<>>

+-----------------------------------------------------------------------------+
BUILDDATE Verification ...
+-----------------------------------------------------------------------------+
Verifying build dates...done
FILESET STATISTICS
------------------
3 Selected to be installed, of which:
3 Passed pre-installation verification
----
3 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
openssl.man.en_US 0.9.8.802
[...snip]
-------------------------------------------------------------------------------
openssl.man.en_US 0.9.8.802 USR APPLY SUCCESS
openssl.license 0.9.8.802 USR APPLY SUCCESS
openssl.base 0.9.8.802 USR APPLY SUCCESS
openssl.base 0.9.8.802 ROOT APPLY SUCCESS

# /usr/lib/instl/sm_inst installp_cmd -aQd /tmp/openssh-5.0_tcpwrap -f _all_latest -cNgXGY

geninstall -I "a -cgNQqwXY -J" -Z -d /tmp/openssh-5.0_tcpwrap -f File 2>&1

File:
I:openssh.base.client 5.0.0.5301
I:openssh.base.server 5.0.0.5301
I:openssh.man.en_US 5.0.0.5301
[...snip...]
openssh.base.client 5.0.0.5301 USR APPLY SUCCESS
openssh.base.server 5.0.0.5301 USR APPLY SUCCESS
openssh.base.client 5.0.0.5301 ROOT APPLY SUCCESS
openssh.base.server 5.0.0.5301 ROOT APPLY SUCCESS
openssh.msg.en_US 5.0.0.5301 USR APPLY SUCCESS
openssh.man.en_US 5.0.0.5301 USR APPLY SUCCESS

File /etc/group has been modified.
File /etc/passwd has been modified.

One or more of the files listed in /etc/check_config.files have changed.
See /var/adm/ras/config.diff for details
##########################################################VERIFY##################################
# openssl version
OpenSSL 0.9.8h 28 May 2008
# ssh -V
OpenSSH_5.0p1, OpenSSL 0.9.8h 28 May 2008
# ps -ef|grep ssh
root 159882 270364 0 15:57:06 pts/1 0:00 grep ssh
root 250034 131178 0 15:54:01 - 0:00 /usr/sbin/sshd

# lssrc -s sshd
Subsystem Group PID Status
sshd ssh 250034 active

How to replace dead hard disk in Solaris using SVM/SDS

For this example, consider the following 2 disks

# format < /dev/null

Searching for disks...done

AVAILABLE DISK SELECTIONS:
0. c1t0d0
/pci@1f,4000/scsi@3/sd@0,0
1. c1t1d0
/pci@1f,4000/scsi@3/sd@1,0

Specify disk (enter its number):

# metastat -p
d300 -m d310 d320 1
d310 1 1 c3t1d0s0
d320 1 1 c3t2d0s0
d3 -m d13 d23 1
d13 1 1 c1t0d0s3
d23 1 1 c1t1d0s3
d5 -m d15 d25 1
d15 1 1 c1t0d0s5
d25 1 1 c1t1d0s5
d1 -m d11 d21 1
d11 1 1 c1t0d0s1
d21 1 1 c1t1d0s1
d0 -m d10 d20 1
d10 1 1 c1t0d0s0
d20 1 1 c1t1d0s0

The failed disk for this example will be c1t1d0 which is a mirrored copy of c1t0d0. The first thing we need to do is determine if this disk had any metadb replicas on it:

# metadb -i

flags first blk block count
a m p luo 16 8192 /dev/dsk/c1t0d0s6
a p luo 8208 8192 /dev/dsk/c1t0d0s6
a p luo 16 8192 /dev/dsk/c1t0d0s7
a p luo 8208 8192 /dev/dsk/c1t0d0s7
a p luo 16 8192 /dev/dsk/c1t1d0s6
a p luo 8208 8192 /dev/dsk/c1t1d0s6
a p luo 16 8192 /dev/dsk/c1t1d0s7
a p luo 8208 8192 /dev/dsk/c1t1d0s7

There are 2 metadb’s on the failed disk slices s6 & s7. We can delete these records.

# metadb -d /dev/dsk/c1t1d0s6 /dev/dsk/c1t1d0s7

The metadb records should now be deleted off the failed disk.(this is not actually deleting them off the disk - the disk is busted - its just saying they dont live there anymore)

# metadb -i
flags first blk block count
a m p luo 16 8192 /dev/dsk/c1t0d0s6
a p luo 8208 8192 /dev/dsk/c1t0d0s6
a p luo 16 8192 /dev/dsk/c1t0d0s7
a p luo 8208 8192 /dev/dsk/c1t0d0s7

Next we need to unconfigure the device to do this run a ‘cfgadm –al’

# cfgadm -al | grep c1t1d0
c1::dsk/c1t1d0 disk connected configured unknown

# cfgadm -c unconfigure c1::dsk/c1t1d0


The disk should now be unconfigured from the system

# cfgadm -al | grep c1t1d0

c1::dsk/c1t1d0 disk connected unconfigured unknown

You can go ahead with the physical replace of the drive.

Now, we will need to configure the drive.

# cfgadm -c configure c1::dsk/c1t1d0

To check it has been configured run:

# cfgadm -al | grep c1t1d0
c1::dsk/c1t1d0 disk connected configured unknown

now copy the partition table (VTOC) across from the working disk to the new disk. Prvtvtoc will print the VTOC to fmthard that will format the new disk

#prtvtoc /dev/rdsk/c1t0d0s2 |fmthard -s - /dev/rdsk/c1t1d0s2

The next step is to run metareplace on all the meta devices which lay on the dead disk c1t1d0. To identify these you can run ‘metastat -p’ again

# metastat -p
d300 -m d310 d320 1
d310 1 1 c3t1d0s0
d320 1 1 c3t2d0s0
d3 -m d13 d23 1
d13 1 1 c1t0d0s3
d23 1 1 c1t1d0s3 <-----HERE
d5 -m d15 d25 1
d15 1 1 c1t0d0s5
d25 1 1 c1t1d0s5 <-----HERE
d1 -m d11 d21 1
d11 1 1 c1t0d0s1
d21 1 1 c1t1d0s1 <-----HERE
d0 -m d10 d20 1
d10 1 1 c1t0d0s0
d20 1 1 c1t1d0s0 <----and HERE

As you can see from the above, c1t1d0 had mirrors in d0, d1, d3 and d5.

Do the following:

# metareplace -e d0 c1t1d0s0
# metareplace -e d1 c1t1d0s1
# metareplace -e d3 c1t1d0s3
# metareplace -e d5 c1t1d0s5


The disks should now start resyncronising, when this is complete all of the devices will be in the OK state.

#while :; do metastat -p | grep -i stale; sleep 5; done