Purga Transacciones Pendiente -Ora-01017 - Transparent

 

#!/bin/sh

#set -x

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/9.2.0; export ORACLE_HOME

ORACLE_SID=B7333; export ORACLE_SID

PATH=$PATH:$ORACLE_HOME/bin; export PATH

$ORACLE_HOME/bin/sqlplus -s ’/ as sysdba’ <<- EOF

#connect system/horamrp04

set linesize 90

set pagesize 0

set head off

spool /u01/CRONTAB/access_denied2.sql

select ’EXECUTE sys.Dbms_Transaction.purge_lost_db_entry(’’’ || LOCAL_TRAN_ID || ’’’);’

from dba_2pc_pending

where rownum = 1;

select ’commit;’ from dual;

spool off

quit

EOF

cat /u01/CRONTAB/encavezado /u01/CRONTAB/access_denied2.sql > /u01/CRONTAB/access_denied2.sh

echo quit >> /u01/CRONTAB/access_denied2.sh

echo EOF >> /u01/CRONTAB/access_denied2.sh

sh /u01/CRONTAB/access_denied2.sh