Skip to content

Linux Commands

Append new line to end of multiple files in linux

cd /tmp

echo “pga_aggregate_limit=0” | tee -a *.txt

execute sql command from shell in one line 

echo “drop user ABC; ” | sqlplus abc/**@db as sysdba

Search One line before and after in Grep

Get one line after grep search

oracle@server1 ~]$ lsnrctl status | grep -i Hello -A 1

Service “Hello world” has 1 instance(s).
Instance “test1”, status READY, has 1 handler(s) for this service…

grep one line before and after grep search

[oracle@server1 ~]$ lsnrctl status | grep -i Hello -B 1 -A 1

Instance “xyz”, status READY, has 1 handler(s) for this service…
Service “Hello world” has 1 instance(s).
Instance “test1”, status READY, has 1 handler(s) for this service..

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: