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.
Making the Database Part of Your Continuous Delivery Pipeline The database, unlike other software components and code or compiled co...
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 have been having a great company with some of the very talented NCG’s ( New College Hires/ Grads ) last ~2yrs. I work for Intuit I...
I worked with a start up employer where it happened that we got an email from out Top Boss! to block all google and yahoo cousins, to promot...