How to use the FINDSTR Command in Windows

After upgrading or patching your Oracle software on a Windows platform it’s necessary to check through the log files for any errors encountered during the process which have not caused the upgrade to fail. In order to do this, I use the findstr command against the log file, and example would be:

findstr /B /N “ORA-” upgrade_TEST.log
findstr /B /N “SP2-” upgrade_TEST.log

Always make sure that you search from the beginning of the line because Oracle often put ORA- comments in their code which don’t start at the beginning of the line, as they have comment marks before them.

Also, It’s very important to search for SP2- errors because sometimes with multiple oracle homes this can cause an issue with not being able to find the correct paths. I have come across this problem myself where there was a 10g and 11g installation on the same box. The first path was the 10g one so when I was running the scripts in, it was necessary to set the ORACLE_HOME parameter so that the correct scripts would be picked up.

Like it, share it...

Category: Windows

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *