UNIX for Dummies Questions & Answers

Hi,

I am new to shell scripting. Need help with the below requirement.

I need help to read a log file and line containing word ORA needs to be captured into a variable and the values of the variable need to be inserted into a table.

For E.g. file test.sql has below error:

ORA-01017: invalid username/password; logon denied

I need to captured this entire line starting from ORA till logon denied. Any error starting from ORA need to be assigned into a variable and to be inserted into a table.

I tried below command:

Code:

awk '/ORA|ORA/ { print }' <  test.log

The above command gave me below output:

Code:

ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

I want the first line starting from ORA and that line needs to be inserted into table.

Thank you in advance.

Change:

Code:

awk '/ORA|ORA/ { print }' <  test.log

to:

Code:

awk '/^ORA/ { print }' <  test.log

or:

Code:

awk '/^ORA/ { print }' test.log

or more simply:

Code:

awk '/^ORA/' test.log

or:

Code:

grep '^ORA' test.log

For this, I would recommend using grep instead of awk.

Don Cragun told you already how you do select the correct lines. Here is how they are put into a variable:

Code:

typeset VARAIABLE=""

grep '^ORA' /path/to/file |\
while read VARIABLE ; do
     echo "this is the line: >${VARIABLE}<"
done

replace the read-statement with whatever you want to do with the variable.

I hope this helps.

bakunin

Thank you Don Cragun and Bakunin for you help. It worked.

Thanks again.