Finding ORA and SP2 Errors with grep

In this short post, I will share simple grep style Regular Expression to find Oracle ORA-XXXXX and SqlPlus(SP2-XXXX) errors. Connectionless Session with sqlplus: #!/bin/bash #Set oracle environment variables in the .bash_profile . ~/.bash_profile sqlplus -s /nolog <<EOF>test.ora connect <username>/<password>@<connection identifier> SELECT ID || ‘ ‘ || NAME || ‘ ‘ || SNAME || ‘ ‘ […]

Read More →