#!/bin/ksh
. /u01/oracle8s/dbalocal/.oracle_tst
svrmgrl <<EOF
connect internal;
spool /u01/oracle8s/dbalocal/dbfs/log
@/u01/oracle8s/dbalocal/dbfs/clone_controlfile_tst.sql
alter user prod_jd identified by ssauxas_tst;
create public database link producao connect to prod_jd identified by "XX"  using 'ssauxas_cabo'; 
connect prod_jd/ssauxas_tst;
update sn_info_conexao_web set agente='tst';
commit;
spool off
exit
EOF