#!/bin/sh
sqlplus 'DBSNMP/"DB$NMP"'@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))' <<EOF
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
select host_name from v\$instance;
EOF
watch -n 1 sh test.sh
watch -n 1 “sh test.sh > test.log”