Sizing a UPS for your Data Center

Today one of my Buddy came and ask me lots of question on Sizing a UPS for there new office and i can see the complexity which every IT Manager faces while sizing the UPS for there Data-center or Server Room hope these below instructions will reduce your pain and headache .

Make the excel sheet and computes these formulas . I will put a excel Template soon here .

Step 1 List all the equipment to be protected by the UPS in one column. Examples are computers, monitors, modems, PBX phone systems and other network hardware.

Step 2 Read the nameplate on each of the pieces of equipment and write down the volts and the amps next to each piece of equipment using another column. An example would be 120V and 2.0A.

Step 3 Multiply the volts and the amps of each piece of equipment and enter the total in a column labeled as "VA". When the equipment is only rated as watts, convert it to VA by multiplying that figure by 1.43 and enter it in your "VA" column.

Step 4 It's better to calculate A/C usage out of this scope and plan the Electrical architecture based on Generator fail back plan.

Step 5 It’s recommended once you have the total VA load to add an additional 30% to that figure to accommodate any future growth. It’s also a good safety precaution to avoid the potential of overloading a UPS.

Oracle 10g Bug with system Uptime

Oracle 10g Bug with system Uptime

I encounter this issue twice today morning so thought to share with you guys .
Oracle 10g starts acting funny in unix systems making oracle client connection hang and leads to high CPU Utilization and server hung state due to OCI client spins when machine uptime >= 198 days in Linux machines. The user will not be able to connect to the databases.

As per oracle bug doc 4612267 its 248 Days but on RHEL5 (2.6.18-92.el5) i experienced the same in 198 days up-time .

Monitoring Brocade Switches

Monitoring Brocade Switches

I have developed a Zenpack for monitoring Brocade SAN switches you can download it from the below link

Download Brocade Zenpack

The Zenpack Provides the below Performance Graphs for Brocade switches:

Fibrechannel CRC errors recieved
Fibrechannel Class2 frames transmitted
Fibrechannel Class3 frames recieved
Fibrechannel Encoding or disparity errors
Fibrechannel Multicast frames recieved
Fibrechannel Multicast frames transmitted
Fibrechannel Truncated frames recieved
Fibrechannel Truncated too-long frames recieved
Fibrechannel bad EOF delimited frames
Fibrechannel discarded Class 3 frames
Fibrechannel error-disparity errors recieved
Fibrechannel frames recieved
Fibrechannel frames transmitted
Fibrechannel invalid Ordered sets recieved
Fibrechannel timed-out Multicast frames
Fibrechannel words recieved
Fibrechannel words transmitted

Get Component Navigation in PIA using Query

Begin-Select
PI.PORTAL_NAME,
PI.PORTAL_OBJNAME

Let $CONTENT_REFERENCE = &PI.PORTAL_OBJNAME

FROM PSPRSMDEFN PI
WHERE PI.PORTAL_NAME = 'EMPLOYEE'
AND PI.PORTAL_URI_SEG2 = $Component_Name
End-Select


Begin-Select
PORTAL_LABEL,
LEVEL

Let $Path = $path || '>>'||&PORTAL_LABEL

FROM PSPRSMDEFN
WHERE PORTAL_NAME = 'EMPLOYEE' START WITH PORTAL_OBJNAME = $CONTENT_REFERENCE
CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME
ORDER BY LEVEL DESC
End-Select