Today we had to parse one SQL error log file in UNIX box and I saw a kind diff file format -
#grep "Database mirroring is inactive" ERRORLOG.1
And i saw no output. :-(
I thought its dos2unix which can help me. BUT not!!
ERRORLOG.4: Little-endian UTF-16 Unicode English character data, with very long lines, with CRLF line terminators
grep command couldn’t parse the UTF-16 Unicode file. Hence, the file had to be converted to the format which ‘grep’ can parse.
#iconv -f UTF-16 -t UTF-8 ERRORLOG.1 | grep "Database mirroring is inactive"
And cheers! I am done.
Effective Time-management and Time-boxing is a concern for 'always ready people'. Being from a background that I am from, I am...
( A story on - how we formulated a process around measuring and achieving CICD, and how these journey lines has now become a means t...
Have you come across a situation when you need to reset the root password of a XEN virtual box. Logon Host machine run following command to...
I had to handle a recent escalation where /var reportedly got filled up - Someone with 'dbuser' userid deleted /var/log/message file...