PowerPath show “unlic” status

Unlic indicates that unlicensed PowerPath is running for a CLARiiON array (no license key has been installed), Unlicensed defaults to "basic Fail/Over policy, we made change yet.

bash> powermt display dev=emcpower0a|grep policy
state=alive; policy=BasicFailover; priority=0; queued-IOs=0
bash> powermt display dev=emcpower0a
Pseudo name=emcpower0a
CLARiiON ID=CK200071500374 [SERVER]
Logical device ID=60060160F0CE1A00185D33F95722DD11 [LUN 25 SERVER]
state=alive; policy=BasicFailover; priority=0; queued-IOs=0
Owner: default=SP B, current=SP B       Array failover mode: 1
==============================================================================
---------------- Host ---------------   - Stor -   -- I/O Path -  -- Stats ---
###  HW Path                I/O Paths    Interf.   Mode    State  Q-IOs Errors
==============================================================================
3072 pci@8,700000/SUNW,qlc@3/fp@0,0 c5t5006016239A02677d0s0 SP A2     active  alive      0      0
3072 pci@8,700000/SUNW,qlc@3/fp@0,0 c5t5006016A39A02677d0s0 SP B2     active  alive      0      0
3074 pci@8,700000/SUNW,qlc@3,1/fp@0,0 c6t5006016339A02677d0s0 SP A3     unlic   alive      0      0
3074 pci@8,700000/SUNW,qlc@3,1/fp@0,0 c6t5006016B39A02677d0s0 SP B3     unlic   alive      0      0

Workaround
1. powermt check_registration
2. powermt set policy=co dev=all (Set the Policy to co = Clariion Optimization)
3. powermt display dev=all
4. powermt save

bash> powermt display dev=emcpower0a|grep policy
state=alive; policy=CLAROpt; priority=0; queued-IOs=0
bash> powermt display dev=emcpower0a
Pseudo name=emcpower0a
CLARiiON ID=CK200071500374 [SERVER]
Logical device ID=60060160F0CE1A00185D33F95722DD11 [LUN 25 SERVER]
state=alive; policy=CLAROpt; priority=0; queued-IOs=0
Owner: default=SP B, current=SP B       Array failover mode: 1
==============================================================================
---------------- Host ---------------   - Stor -   -- I/O Path -  -- Stats ---
###  HW Path                I/O Paths    Interf.   Mode    State  Q-IOs Errors
==============================================================================
3072 pci@8,700000/SUNW,qlc@3/fp@0,0 c5t5006016239A02677d0s0 SP A2     active  alive      0      0
3072 pci@8,700000/SUNW,qlc@3/fp@0,0 c5t5006016A39A02677d0s0 SP B2     active  alive      0      0
3074 pci@8,700000/SUNW,qlc@3,1/fp@0,0 c6t5006016339A02677d0s0 SP A3     active  alive      0      0
3074 pci@8,700000/SUNW,qlc@3,1/fp@0,0 c6t5006016B39A02677d0s0 SP B3     active  alive      0      0

Rename Volume Group on HP-UX (quick & dirty)

Can you explain how to rename a volume group (VG)?, How to rename your Volume Group on HP-UX ? and many more question about how to rename the volume group. here I show you the magic of how to rename your Volume Group.

bash> bdf|grep /rdbms/oradata/a
/dev/vg07/lvol1    5144576 3515198 1527542   70% /rdbms/oradata/a

We will rename VG07 to VG20, backup your data first.

Backup VG config First

bash> vgcfgbackup /dev/vg07
Volume Group configuration for /dev/vg07 has been saved in /etc/lvmconf/vg07.conf

Ok, now deactivate the first volume group

bash> vgchange -a n /dev/vg07
Volume group "/dev/vg07" has been successfully changed.

Export Vg07 dengan nama 'vg20.map'

bash> vgexport -v -s -m /tmp/vg20.map /dev/vg07
Beginning the export process on Volume Group "/dev/vg07".
/dev/dsk/c5t0d0
Volume group "/dev/vg07" has been successfully removed.

Create New Volume group (VG20)

bash> mkdir /dev/vg20
bash> mknod /dev/vg20/group c 64 0x1a0000

Import VG nya

bash> vgimport -v -s -m /tmp/vg20.map /dev/vg20
Beginning the import process on Volume Group "/dev/20".
Logical volume "/dev/vg20/lvol1" has been successfully created
with lv number 1.
Volume group "/dev/vg20" has been successfully created.

Last but not least, Enable the VG

bash> vgchange -a y /dev/vg20
Activated volume group
Volume group "/dev/vg20" has been successfully changed.

System Administrator Appreciation Day

A sysadmin unpacked the server for this website from its box, installed an operating system, patched it for security, made sure the power and air conditioning was working in the server room, monitored it for stability, set up the software, and kept backups in case anything went wrong. All to serve this webpage

A sysadmin installed the routers, laid the cables, configured the networks, set up the firewalls, and watched and guided the traffic for each hop of the network that runs over copper, fiber optic glass, and even the air itself to bring the Internet to your computer. All to make sure the webpage found its way from the server to your computer.

A sysadmin makes sure your network connection is safe, secure, open, and working. A sysadmin makes sure your computer is working in a healthy way on a healthy network. A sysadmin takes backups to guard against disaster both human and otherwise, holds the gates against security threats and crackers, and keeps the printers going no matter how many copies of the tax code someone from Accounting prints out.

A sysadmin worries about spam, viruses, spyware, but also power outages, fires and floods.

When the email server goes down at 2 AM on a Sunday, your sysadmin is paged, wakes up, and goes to work.

A sysadmin is a professional, who plans, worries, hacks, fixes, pushes, advocates, protects and creates good computer networks, to get you your data, to help you do work -- to bring the potential of computing ever closer to reality.

Happy Sysadmin Day..all of you.

http://www.sysadminday.com/


Troubleshooting for startup inconsistent DB

for e.g. database unable up cause of datafile corruption

SQL> startup
ORACLE instance started.
 
Total System Global Area 1610612736 bytes
Fixed SIZE                  2177912 bytes
Variable SIZE             396149896 bytes
DATABASE Buffers         1207959552 bytes
Redo Buffers                4325376 bytes
DATABASE mounted.
ORA-01113: file 2 needs media recovery
ORA-01110: DATA file 2: '/oradata/oracle/ts/undotbs01.

commonly the database unable be startup if UNDO or SYSTEM table space need recovery, if these happen we need correct temporary workaround to handle this, all workaround for each tablespace datafile is similar

do the recovery

SQL> recover DATABASE;
ORA-00279: CHANGE 7516226638 generated at 05/05/2008 12:32:11
needed FOR thread 1
ORA-00289: suggestion : /oradata/oracle/ts/arc/1_42_653916655.dbf
ORA-00280: CHANGE 7516226638 FOR thread 1 IS IN SEQUENCE #42
 
Specify log: {ret=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot OPEN archived log
‘/oradata/oracle/ts/arc/1_42_653916655.dbf’
ORA-27037: unable TO obtain file STATUS
SVR4 Error: 2: No such file OR directory
Additional information: 3

Read the rest of this entry »


Linux System information

System information

Show architecture of machine

bash> arch
i686

Show used kernel version(1)

bash> uname -r
2.6.9-67.0.15.ELsmp
bash> cat /proc/version
Linux version 2.6.9-67.0.15.ELsmp (mockbuild@builder10.centos.org) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-9)) #1 SMP Thu May 8 10:52:19 EDT 2008

Show hardware system components(SMBIOS / DMI)

bash> dmidecode
# dmidecode 2.2
SMBIOS 2.3 present.
39 structures occupying 2026 bytes.
Table at 0×000F6024.
Handle 0×0000
DMI type 0, 19 bytes.
BIOS Information
Vendor: IBM
Version: -[BWE130AUS-1.11]-
Release Date: 10/25/2007
Address: 0xF0F40
Runtime Size: 61632 bytes
ROM Size: 4096 kB
[...]

Read the rest of this entry »