Start All DB’s using script

Share via:

for ORA_SID in $(cat /var/opt/oracle/oratab |grep -vi asm |grep -v ‘#’|grep -vi agent |grep -vi orcl7 |awk -F”:” ‘{ print $1}’)
do
ORACLE_SID=$ORA_SID
export ORACLE_SID
sqlplus -s “/ as sysdba” <<!
startup;
exit;
!
done

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (12 votes, average: 5.00 out of 5)
Loading...

2 thoughts on “Start All DB’s using script

Add Comment