I have a problem with one of production server where listener will die frequently,
I have raised SR with oracle for the same, but mean time i need simple script and i need schedule in cron for every 5 min if listner will down it will start automatically.
this is the script but i am getting error appreciated for inputs.
Code:
lsnrctl status > /oracle/test.txt
aaa=`grep "The command completed successfully" /oracle/test.txt`
bbb="The command completed successfully"
ccc="TNS:no listener"
if ["$aaa" = "$bbb"]; then
exit
else
if ["$aaa" = "$ccc"]; then
lsnrctl start
fi
fi
exit
bash-2.05$ sh listener.sh
listener.sh: test: ] missing
Thanks
Prakash
Last edited by fpmurphy; 06-13-2009 at 11:17 AM..
Reason: Fix spelling in title
Sorry for not being clear, listener.sh should contain only the code below:
Code:
exec >/dev/null 2>&1
lsnrctl status || lsnrctl start
It will produce no output.
P.S. It should be definitely better to leave STDOUT/ERR.
So your script should contain only the line below
and you should redirect its STDOUT/ERR to a logfile:
I have Big brother script, which start/stop Big Brother processes. Something got change on server and now I am not able to start/stop it. There is no change in script, as I compared it from other server. This service is being managed by bb user (group is also bb).
root@tsazdq04:/#... (6 Replies)
Hi,
We have a requirement wherein we do not want to share the Oracle DB sys and system passwords to be shared with the support desk.
But they will be responsible for starting/shuting down the Database.
Is it possible to write a shell script which will read the sys and system passwords from a... (0 Replies)
Hi all,
after reading the post:
* https://www.unix.com/solaris/101653-how-get-process-start-date-time-solaris.html
I wrote my perl script and it worked like a charm.
This script is called every 5 minutes by the monitoring server crontab and is executed on the remote network elements via ssh (the... (6 Replies)
Hi everybody,
i need help from all of you.
I have many users who are no more work in our Company. Some who get objects are Locked. There Many users and many Database Servers. And it'll take long for me to finished this job.
That's why i need your help to provide me anyone Scripts... (2 Replies)
