thanks Rajendra/Jared/ Waldirio/Howard here is script part ## . /opt/oracle/scripts/setenv cd /opt/oracle/scripts DBS=/opt/oracle/scripts/dbs flist=/opt/oracle/scripts/new_obj.log mlist=/opt/oracle/scripts/mail_new_obj.log echo ' '> $flist echo ' '> $mlist cat $DBS | while read DB do sqlplus db_ro@$DB @new_objects.sql <.pw >> $flist done set -x grep -i created $flist grep -i created $flist > $mlist #mailx ## please note new_objects.sql -- select i.instance_name||' on '|| i.host_name||' : '||d.Object_type ||' ' ||d.owner||'.'||d.object_name|| ' created ' || d.created from dba_objects d, v$instance i where d.created >sysdate - 1 and d.Object_type not like '%BODY%' and d.owner not in ('SYS', 'SYSTEM', 'OUTLN', 'DBSNMP', 'XDB', 'TSMSYS') order by 1 / all other parts working fine. I'm getting the objects created in last one day. From one database getting eight objects and six from another database.however the shell script grep finds only the eight from first database.not six from second database. the very same grep command when I came in my UNIX interactive session gets all 14. which grep from both shell script, UNIX interactive session gives same output /bin/grep + which grep /bin/grep --- On Fri, 11/26/10, rajendra.pande@xxxxxxx <rajendra.pande@xxxxxxx> wrote: > From: rajendra.pande@xxxxxxx <rajendra.pande@xxxxxxx> > Subject: RE: ** UNIX shell -- grep behavior different > To: jkstill@xxxxxxxxx, ajoshi977@xxxxxxxxx > Cc: oracle-l@xxxxxxxxxxxxx > Date: Friday, November 26, 2010, 9:17 AM > As always check how many versions of > grep you have in default path vs the script path. > If there are aliases defined > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Jared Still > Sent: Friday, November 26, 2010 1:27 AM > To: ajoshi977@xxxxxxxxx > Cc: oracle-l@xxxxxxxxxxxxx > Subject: Re: ** UNIX shell -- grep behavior different > > Assisting with troubleshooting is much easier with a > reproducible example. > > On Thursday, November 25, 2010, A Joshi <ajoshi977@xxxxxxxxx> > wrote: > > hi > > I have a UNIX shell script that populates a > file and then does grep on it. in the shell script it is > missing some lines that has the grep string. > > from interactive UNIX session grep I get bigger and > right list. I am using the same exact grep that is in the > UNIX shell script. only difference is in the shell script > file name is referred to as $flist > > I'm submitting shell script as nohup > > I checked everything. I tried removing the file and > re-create. > > it is strange. can someone help. TIA > > > > > > > > > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > Oracle Blog: http://jkstill.blogspot.com > Home Page: http://jaredstill.com > -- > //www.freelists.org/webpage/oracle-l > > > Please visit our website at > http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html > > for important disclosures and information about our e-mail > > policies. For your protection, please do not transmit > orders > or instructions by e-mail or include account numbers, > Social > Security numbers, credit card numbers, passwords, or other > > personal information. > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l