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

Sunday 22 Mar 2009 by Hendrawan | No Comments
Filed under: HPUX, LVM

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

Friday 25 Jul 2008 by Hendrawan | 4 Comments
Filed under: Oot Tags:

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

Tuesday 27 May 2008 by Hilman-Lupus | 2 Comments
Filed under: Backup & Recovery, Oracle Tags:

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

Thursday 22 May 2008 by Hendrawan | No Comments
Filed under: Linux, Sysinfo Tags:

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 »


Set hostname without reboot

Monday 28 Apr 2008 by Gun nee | No Comments
Filed under: Solaris, Tips & Tricks 
bash> uname -a
SunOS Trojan 5.9 Generic_118558-33 sun4u sparc SUNW,Netra-T12

replace old "hostname" with new "hostname" in file /etc/hosts, /etc/nodename, /etc/hostname."ethernet_port_name", /etc/net/ticlts/hosts, /etc/net/ticotsord/hosts, /etc/net/ticots/hosts

bash> vi /etc/hosts
bash> vi /etc/nodename
bash> vi /etc/hostname.bge0
bash> vi /etc/net/ticlts/hosts
bash> vi /etc/net/ticotsord/hosts
bash> vi /etc/net/ticots/hosts

and then execute command :

hostname "new hostname"
bash> hostname worm
bash> . /.profile


ssh[23593]: [ID 530472 user.error] Kerberos mechanism library initialization error:

Monday 24 Mar 2008 by Hendrawan | No Comments
Filed under: Common Problem, Solaris

When I log via ssh to another machine

bash> ssh gandalf@rohan.lotr.com
unable to initialize mechanism library [/usr/lib/gss/gl/mech_krb5.so]

the following message appears was appears

rohan.lotr.com sshd[23418]: [ID 530472 auth.error] Kerberos mechanism library initialization error:
Can't open/find Kerberos /etc/krb5/krb5.conf

Workaround:

Edit /etc/ssh/ssh_config and add the following

Host *
StrictHostKeyChecking no
GSSAPIKeyExchange no
GSSAPIAuthentication no

And
Edit /etc/ssh/sshd_config and add the following

GSSAPIAuthentication no
GSSAPIKeyExchange no
GSSAPIStoreDelegatedCredentials no


Tracking Down "Last Reboot" on windows

Sunday 9 Mar 2008 by Hendrawan | No Comments
Filed under: Tips, Windows

when you handful on your windows environment, you must know this

edit uptime.bat
systeminfo   | find "Up Time"

and then save with "alt+f > s > x"
last reboot action here..

uptime.bat
systeminfo   | find "Up Time"
System Up Time:            3 Days, 19 Hours, 6 Minutes, 26 Seconds


Backup Listener log

Sunday 9 Mar 2008 by Hendrawan | 1 Comment
Filed under: Backup & Recovery, Oracle Tags:

In database production, the log of listener was grow rapidly, some times if you move the "listener.log" while the listener is up and running, listener will stop writing to log file after you move/delete the "listener.log", it won't create new log file.
The listener log status will be 'off', You need to start the "listener log" again manually. For this reason you must do this procedure.

bash> lsnrctl stat
LSNRCTL for Solaris: Version 9.2.0.6.0 - Production on 09-MAR-2008 12:43:22
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.6.0 - Production
Start Date                11-SEP-2007 03:34:17
Uptime                    180 days 9 hr. 9 min. 4 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/app/product/9.2.0/network/admin/listener.ora
Listener Log File         /oracle/app/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOSTNAME)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "DB_SID.domain.com" has 2 instance(s).
Instance "DB_SID", status UNKNOWN, has 1 handler(s) for this service...
Instance "DB_SID", status READY, has 1 handler(s) for this service...
The command completed successfully
bash> lsnrctl
LSNRCTL> SET log_status off
Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_status" SET TO OFF
The command completed successfully
bash> mv /oracle/app/product/9.2.0/network/log/listener.log /backup/listener.log_9-March-2008
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_status" set to ON
The command completed successfully


« Older Entries
Newer Entries »

  • Search