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
Note: Please test scripts in Non Prod before trying in Production.
Loading...
Aditya
Good information
Krishnakumar
The article contains very useful information