All pastes #568149 Raw Edit

Snake007uk

public shellscript v1 · immutable
·published 2007-06-15 09:36 UTC
rendered paste body
#!/bin/bashset -xORACLE_BASE=/opt/app/oracleORACLE_SID=OSTESTAORACLE_HOME=/opt/app/oracle/product/10.2/db_1CRS_HOME=/opt/app/oracle/product/10.2/crs_1RESULTS=`sqlplus -s "/ as sysdba" <<EOFSELECT machine , count(1) KOUNTFROM v$sessionWHERE username = "TESTER"GROUP BY machineORDER BY machine ;EOF`echo SQLPLUS said: $RESULTS