Sunday, November 21, 2010

How to change URL to alias for Share Point 3

How to change URL to alias for Share Point 3
Go to administration (usually on http://localhost:21887)
Central Administration > Operations > Alternate Access Mappings > and edit default URL for Share Point Site (line without any port) and replace with new one eg. http://servername to http://intranet

How to force Automatic Updates / Windows Update Client to check for new updates

How to force Windows Update Client to check for new updates
Go to a command line or go to Start - Run and run this command:
wuauclt /detectnow

Saturday, November 20, 2010

Free MySQL tool - Toad for MySQL

I would like to share information that Quest company offer free tool for MySQL.
Toad® for MySQL is a freeware development tool that improves the productivity of developers and administrators running MySQL on Windows.
It can be downloaded here after registration: http://www.quest.com/toad-for-mysql/default.aspx
For more information check it out http://www.quest.com/toad-for-mysql/default.aspx
Source: http://www.quest.com

Wednesday, November 10, 2010

ORA-00600 [Librarycachenotemptyonclose] Reported At Shutdown

I've experienced this problem so I hope that it will be usefull...
My version: 10.2.0.3 (10.2.0.1 to 10.2.0.4)
Symptoms:
Alertlog:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
Trace file:
Starting by line "----- Call Stack Trace -----" check if you see this functions:
kglshu kqlnfy kscnfy ksmshu
opistp_real opistp opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real main libc_start_main
Cause:
Non-critical bug during database shutdown.
Workaround:
Run sql command before shutdown:
sqlplus / as sysdba
alter system flush shared_pool;
You can also create shutdown trigger to automatically invoke this action.

Friday, October 22, 2010

How to define and update script in TSM server

Here are some tips when managing scripts in TSM server.
  • Defining script in TSM:
DEFine SCRipt script_name command_line Line=number

Example:
tsm: TSMSERVER> DEFine SCRipt test_scrit "q sch t=a" Line=5

  • Updating script in TSM:

UPDate SCRipt script_name command_line Line=1 DESCription=description


Tuesday, October 19, 2010

Best Practice in Backup & Data Protection in a Virtualized World





Webcast for managers and backup administrators:

A BrightTALK Channel

Thursday, October 14, 2010

CZE - Licence produktů MS ve virtuálním prostředí

Narazil jsem na zajímavý článek velice znalého odborníka na licencování Microsoft produktů paní Dariny Vodrážkové, MCTS.
Tento článek pojednává o problematice licencování Microsoft produktů ve virtuálním prostředí:
http://technet.microsoft.com/cs-cz/gg252274.aspx

Monday, October 11, 2010

IBM HMC: Accessing the Product Engineering Shell (PESH) Command Line

On this site you can find manual how to access PESH in HMC.
http://www-01.ibm.com/support/docview.wss?uid=nas1dba3b86d228b9b6c862570d1008009fd

It can be used when solving problem with too big /var/hsc/log/hmclogger.log file and need to do any operation under root.
http://www-01.ibm.com/support/docview.wss?uid=isg3T1011162


The procedure in this document can be used to obtain an unrestricted shell on the HMC and log on as root.
Prerequisites: Obtain a pesh password from IBM support.
Right-click on the HMC desktop, select Terminals > rshterm . Run the lshmc -v command to obtain the HMC serial number (as stored in the BIOS). The serial number is listed in the SE field (in bold blue below):

Thursday, October 7, 2010

How to recover one table from dump in MySQL

If you do dumps just of one table on regular basis then you are happy man :-)
  1. Backup of one table:
    # mysqldump -u username -p password > /path/file.sql
  2. Restore one table:
    # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql
If you do dumps of whole DB then do following:
Backup of DB:
  1. # mysqldump -u username -p password > /path/file.sql
Restore of one table from dump of DB:
  1. We have to know where one table starts and where ends:
    # grep -n 'Table structure' /path/file.sql
  2. Then we have to separate part of file with required table into new file using line number gathered in previous command (where 7506 is start and 17684 is end):
    # sed -n '7506,17684 p' /path/file.sql > /path/new_file.sql
  3. Then we can restore it into DB:
    # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql

Tuesday, October 5, 2010

UNIX and Linux command reference guide

Here are some commands from UNIX and Linux world.
Source:
http://www.ahinc.com/aix/
http://www.digilife.be/quickreferences/quickrefs.htm
AIX
http://www.tablespace.net/quicksheet/aix-quicksheet.pdf
http://www.tablespace.net/quicksheet/aix-quickstart.html
http://publib16.boulder.ibm.com/pseries/index.htm


AIX Linux
Command Comment Command Comment
Show directory size du -ms /tmp k KB,m MB, g GB du -hs /tmp
Show disk size bootinfo –s hdisk# MB
List exported directories lsfsexp
showmount -e
Show FC Info fcstat fcsX

Friday, September 24, 2010

CZE - How to work around the problem with thumbnails regeneration timeout in PrestaShop

Již několikrát jsem řešil nepříjemný problém s regenerací miniatur - obrázků v PrestaShopu.
Pokud máte 100 a více zboží v eshopu a timeout pro php skripty nastaven na 1 minutu tak se asi při 100 tém zboží přeruší proces regenerace a zobrazí se prázdná stránka nebo chyba s překročením limitu pro běh skriptů. Nezoufejte :-)
Našel jsem zajímavý návod, jak obejít tento problém:
  1. Vytvořit složku tmp ve složce /prestashop_home/img/p
  2. Spustit regeneraci miniatur
  3. Přesunout soubory / obrázky zboží, pro které již došlo k vygenerování miniatur to vytvořené složky
  4. Dále opakovat body 2 a 3 dokud nejsou vygenerovány miniatury pro všechny soubory a to poznáte tak, že se vám zobrazí zpráva "Thumbnails successfully regenerated" a v češtině "Miniatury úspěšně regenerovány"
  5. Přesunout všechny soubory z /prestashop_home/img/p/tmp zpět do /prestashop_home/img/p/

Wednesday, September 8, 2010

Redefining TSM Library and Drives for UNIX OS

Have you experienced problem with offline path of drive and library in TSM server?
Have you received these errors?
ANR0523W Transaction failed - error on output storage device
ANR8300E I/O error on library (OP=xx, CC=xx, KEY=xx, ASC=xx, ASCQ=xx, SENSE=xx)
ANR8301E I/O Error on library
ANR8355E I/O error reading label for volume NNNNNN on drive XXXXX
ANR8359E Media fault detected on volume NNNNNN in drive XXXXX
ANR8441E Initialization failed for SCSI library
ANR8779E Unable to open drive XXXXX, error number=ZZZ
ANR8944E Hardware or media error on drive
ANR8963E Unable to find path to match the serial number defined for drive
or
ANR3512E RECLAIM STGPOOL: Error encountered in accessing data storage - insufficient number
of mount points available for removable media.
ANR1463E RUN: Command script BCK_RECLAIM completed in error.
ANS8001I Return code 14.
or
ANR8840E      Unable to open device /dev/smc0 with error
ANR8840E      Unable to open device /dev/rmt0 with error
ANR8840E      Unable to open device /dev/rmt1 with error
or
UPDATE PATH source destination SRCTYPE=SERVER AUTODetect=Yes DESTTYPE=DRIVE LIBRARY=name DEVICE=/dev/rmt0 ONLINE=YES
ANR8420E UPDATE PATH: An I/O error occurred while accessing drive .
ANS8001I Return code 15.


IBM guys have made nice "How to redefine TSM Library and Drives for UNIX OS"
http://www-01.ibm.com/support/docview.wss?uid=swg21376419&myns=swgtiv&mynp=OCSSGSG7&mync=E

Tuesday, August 24, 2010

NAGIOS/Centreon: Troubleshooting Graphs

Troubleshooting:Graphs

From Wiki Centreon

Here is a short conversation "how to" troubleshoot graphs in centreon:

Conversation:
.. I know, currently this is only a log from an IRC session, but me (or any volunteers) may turn this in a good and structured HowTo :)
(14:22:09) grandmoun: How can i create graphs in centreon??
(14:28:27) nfilus: graphs are autogenerated, if the service you defined returns performance data
(14:29:01) zelia5: how do i generate perfdata ? ^^
(14:31:09) nfilus: # /usr/local/nagios/libexec/check_centreon_ping -H www.google.de
(14:31:15) nfilus: GPING OK - rtt min/avg/max/mdev = 23.269/23.269/23.269/0.000 ms|time=23.269ms;20;40;; ok=1
(14:31:25) nfilus: |time .... is the perfdata