59 get_all_db () {
 60 #echo getting all db
 61 dblist=`egrep -i "product/12" /etc/oratab |grep -v "listener"|\
 62       awk -F\: '{print $1}'|sort`
 63 echo list is $dblist
 64 echo
 65 echo
 66 echo "INSTANCE_NAME    HTTPS Port  HTTP Port"
 67 echo "---------------- ---------- ----------"
 68 for ORACLE_SID in $dblist
 69 do
 70 echo checking for pmon_$ORACLE_SID
 71 ps -ef|grep pmon_$ORACLE_SID|grep -v grep
 72 echo ps command complete
 73   if ps -ef|grep pmon_$ORACLE_SID|grep -v grep
 74   then
 75     echo calling sqlplus
 76     . oraenv
 77     sqlplus -s /nolog <<EOF
 78     set echo off feedback off verify off head off
 79     conn / as sysdba
 80     select instance_name,
 81            DBMS_XDB_CONFIG.gethttpsport "HTTPS Port",
 82            DBMS_XDB_CONFIG.gethttpport "HTTP Port"
 83     FROM v\$instance;
 84 EOF
 85   fi
 86 done
 87 }

  1 list is db12 fs91upg fs92dev fs92upg hr92dev hr92tst hr92upg
  2
  3
  4 INSTANCE_NAME    HTTPS Port  HTTP Port
  5 ---------------- ---------- ----------
  6 checking for pmon_db12
  7 ps command complete
  8 checking for pmon_fs91upg
  9 ps command complete
 10 checking for pmon_fs92dev
 11 ps command complete
 12 checking for pmon_fs92upg
 13 ps command complete
 14 checking for pmon_hr92dev
 15 ps command complete
 16 checking for pmon_hr92tst
 17 ps command complete
 18 checking for pmon_hr92upg
 19 ps command complete

  1 oracle:fs91upg$ echo $ORACLE_SID
  2 fs91upg
  3
  4 oracle:fs91upg$ ps -ef|grep pmon_$ORACLE_SID|grep -v grep
  5 oracle    2842     1  0 Jan22 ?        00:00:34 ora_pmon_fs91upg
  6
  7 2018-01-26 08:59:44
  8 oracle:fs91upg$