vicker313 tech blog

May 29, 2009

Tar and Untar tape drive in another HPUX server

Filed under: HPUX — Tags: , , , , — vicker313 @ 10:46 pm

There is situation when you have a new HPUX server and then you need to access the old tape that is not supported on the new tape drive. If there is extra SCSI port on the server, definitely you can move the old tape drive to the new server. But when there is no extra SCSI port and you don’t want to buy extra SCSI card, or the old tape drive is needed to be attached to the old server, you still can access the old tape drive using “remsh” command.

We assume the new server’s host name is newserver, while the old server’s host name is oldserver:

  1. Decide a user login to be used to access the old tape drive, let’s said james.
  2. Ensure that both servers have that particular user login (with same password).
  3. Add the host names of both servers into both hosts file (/etc/hosts), for example: oldserver newserver
  4. At old server, create or edit the .rhosts file at the home directory of that particular user by adding the following line:
    newserver james
  5. To untar files from old tape drive on old server, use this command:
    remsh oldserver dd if=/dev/rmt/0m bs=64b|(cd /location/to/untar;tar -xvpfb - 64)
  6. While to tar files into the old tape drive, use this command:
    tar -cvpfb - 64|remsh oldserver dd of=/dev/rmt/0m bs=64b

Refer Remote access tape drive in another HPUX server for extra commands.


May 24, 2009

Change Oracle 10g edition in Linux

Filed under: Linux, Oracle — Tags: , , , — vicker313 @ 5:04 pm

Because of licensing problem or funtionality problem, we might need to convert Oracle 10g from certain edition to another, for example from Enterprise to Standard or vice versa. The edition is decided during the installation, so we need to reinstall it. Steps below is assuming the Oracle is installed following steps here:

  1. Shutdown the database using command “service dbora stop”.
  2. Remove ORACLE_HOME directory using command “rm -rf /opt/oracle/10gR2”. Or you can rename it by using command “mv /opt/oracle/10gR2 /opt/oracle/10gR2_bk”.
  3. Then install the Oracle by using the Oracle Installer, and remember to select the right edition (refer here).
  4. Edit “/opt/oracle/10gR2/bin/dbstart” and “/opt/oracle/10gR2/bin/dbshut”, change the line below (else the listener will not start), (refer from here)
  5. After the installation, the database cannot be start because the database parameter file does not exist in the new installation. So we need to run SQLPLUS using command “sqlplus / as sysdba”, and execute the following statement:
    create spfile from pfile='parameter_file_location';
  6. Re-setup listener and tnsname using command “netmgr”, or copy over the tnsname.ora and listener.ora from the backup ORACLE_HOME directory (located at $ORACLE_HOME/network/admin).
  7. Start the database using command “service dbora start”.

Refer here to check out the edition of Oracle.

May 21, 2009

SharpDevelop, a replacement to Visual Studio

Filed under: .Net — Tags: , , — vicker313 @ 7:48 am

I have been playing around with programming for a long time, and VB6 is my very first language to do project for real customer. At that time, the only option of IDE to be used was of course Visual Studio.

When it came to the era of Dot Net Framework, class and object got inside the picture and I started to explore C# programming (which is more Object Oriented if compare to VB.Net). Still I was using Visual Studio.

What I don’t like about Visual Studio is that: first the cost, second it installs a lot of things that I don’t want (or don’t understand). So I started to search for an alternative which I found SharpDevelop. Actually SharpDevelop is purposely for C# programming, however you can also code VB.Net using it (even F# in the newest version). As Dot Net evolves from 1.0 to 3.5, SharpDevelop is developed into 3 different version: 1.0, 2.0 and 3.0. What’s so great about this little program is that: firstly it is open source and free, secondly it is small (relatively compare with Visual Studio). When you install SharpDevelop, it doesn’t like installing Visual Studio, make you feel like upgrading your windows.

Well bad things for SharpDevelop (my personal opinion) is that the reporting system doesn’t really fit my requirement. But since it is free and small, easy to install and uninstall, I think every C# and VB.Net programmer should take a look and give it a try (It can open project save in Visual Studio).

May 16, 2009

How to check Oracle 10g is Standard or Enterprise Edition

Filed under: Oracle — Tags: , , — vicker313 @ 8:22 am

In normal situation, we can check the edition of Oracle 10g using SQLPlus. Just login using SQLPlus, and there will be a connention message on top of the SQL prompt, stating that the Oracle is either Standard or Enterprise.

Or you can also issue the following select statement to get the edition information:
select * from v$version

However if the database is not created using Database Configuration Assistant (DBCA), but using script or SQL statement, the 2 methods stated above might not work. It still will show out the edition detail but not stating that it is either Standard or Enterprise.

In such scenario, we will need to digg into the files. First look for this file (applicable to both linux and windows):

Inside this context.xml file, look for parameter s_serverInstallType and check out its value (VAL). If it is EE, means it is Enterprise Edition. While SE means Standard Edition.

If you want to change the Oracle edition, you can refer to here.

May 11, 2009

Set mirroring in HPUX using MirrorDisk

Filed under: HPUX — Tags: , — vicker313 @ 12:11 pm

HPUX 11iv3 has a feature called MirrorDisk that enable user to do software mirroring, basically is integrated with LVM. However you need to pay extra in order to use it. After installing this feature, follow steps below to mirror the disks (assume the new disk as c2t2d0):

  1. Create physical volume for new disk:
    pvcreate -f -B /dev/rdsk/c2t2d0
  2. Add disk to current root volume group.
    vgextend /dev/vg00 /dev/dsk/c2t2d0
  3. Make new disk bootable.
    mkboot /dev/rdsk/c2t2d0
  4. Copy correct AUTO file into new LIF area.
    mkboot -a "hpux -lq (;0)/vmunix" /dev/rdsk/c2t2d0
  5. Here is the part to mirror up the logical volume, boot (stand) logical volume need to be done first so that it occupies the first contiguous set of extends on the new disk. Normally logical volume 1 is for stand, 2 is for swap and 3 is for root.
    lvextend -m 1 /dev/vg00/lvol1 /dev/dsk/c2t2d0
    lvextend -m 1 /dev/vg00/lvol2 /dev/dsk/c2t2d0
    lvextend -m 1 /dev/vg00/lvol3 /dev/dsk/c2t2d0
    lvextend -m 1 /dev/vg00/lvol4 /dev/dsk/c2t2d0
    lvextend -m 1 /dev/vg00/lvol5 /dev/dsk/c2t2d0
    lvextend -m 1 /dev/vg00/lvol6 /dev/dsk/c2t2d0
    lvextend -m 1 /dev/vg00/lvol7 /dev/dsk/c2t2d0
    lvextend -m 1 /dev/vg00/lvol8 /dev/dsk/c2t2d0
  6. Update the boot information contained in BDRA for the mirror copies of boot, root and primary swap.
    lvlnboot -b /dev/vg00/lvol1
    lvlnboot -v -r /dev/vg00/lvol3
    lvlnboot -s /dev/vg00/lvol2
  7. Check if the BDRA is correct.
    lvlnboot -R /dev/vg00
  8. Verify if the mirrors were properly created.
    lvlnboot -v

After finish all the steps, try to restart the server and boot from the new disk. If server is able to boot, it means the mirroring setup is success.

Blog at