Linux

Check below:
===============================================
pid=`ps -ef | egrep "${sqlFile}" | awk '{print $2}'`
Returns the SQLPlus PID, filtering the "ps" command output using the SQL file, in this case: scriptDb.sql.
===============================================

===============================================
chk_err=`egrep -i 'ORA-|SP2-|TNS-|Usage' "${sqlplusOutputLog}" | wc -l`
Returns the number of Oracle errors in the log file pointed by: "${sqlplusOutputLog}".
This part:
egrep -i 'ORA-|SP2-|TNS-|Usage' "${sqlplusOutputLog}"
tries to find in the log file the words: "ORA-", "SP2-", "TNS-", "Usage" and if it finds, it prints to the screen, so the command "wc -l", count the lines returned.
===============================================

If you want you can execute each part of a pipe, as the next part will always do something with the previous command output.

About learning shell script, the following link seems to be a good start:
Unix shell scripting with ksh/bash

And if you have doubts, you can read the manual pages of each command, like: "man ps", there you will find all the command options and if you could not find the answer you are looking for, you can post a question here in the forum, we have excelent people here! =o)

I hope it helps!

Regards!

i have a small question
how we can get pid from dbscript.sql script
pid=`ps -ef | egrep "${sqlFile}" | awk '{print $2}'`

Thanks,

As it is a database script, which runs in SQLPlus, there is no easy way.

By the way, why do you need it?

I would like to know how can we find the pid of that sql session because we need pid to kill that session if it takes more time

Could you please help me how to find the pid

Thanks a lot for Your help all the time

I think the script is not clear for you!

When you execute SQLPlus:

Code:

sqlplus <User><Pass>@${ORACLE_SID}

It opens a connection to the database and you can find it in the V$session view and when you kill the sqlplus process, it also closes the database connection, so, when the steps below are executed, the database connection is also closed:

Code:

pid=`ps -ef | egrep "${sqlFile}" | awk '{print $2}'`
kill -9 ${pid}

hi

I have a question
pid=`ps -ef | egrep "${sqlplusoutputlog}" | awk 'NR==19 {print $0}'`

in the above command i want to get the number from the sqlplusoutputlog and that number is in 19th line. I don't know whether the syntax is correct or not
could you please help me in this

thanks,

What number ??

Again, what number is it ?
19th line of what ? Do you mean 19th line of the ${sqlplusoutputlog} file ?

tyler_durden