All Receiving Transactions Fail with rvtptcontrol Error
All Receiving Transactions Fail with
rvtptcontrol Error
Description:
All Receiving transactions fail with rvtptcontrol.
After some research work I found that the error occurs when many transactions fail
with same error it is usually because the receiving executables (RVCTP and
RCVOLTM) are out of sync.
Solution:
1.
Resolve INVALID Objects
1.1
Set environment
1.2
cd $ORACLE_HOME/rdbms/admin
1.3
sqlplus / as sysdba
1.4
SQL>@utlrp.sql
2.
Relink Receiving executables
2.1
cd $AD_TOP/bin
2.2
sh adrelink.sh force=y ranlib=y "PO
RCVOLTM"
2.3
sh adrelink.sh force=y ranlib=y "PO
RVCTP"
3
Bounce Receiving Transaction Manager:
3.1
(System Administrator > Concurrent >
Manager > Administer)
3.2
Deactivate Receiving Transaction Manager
3.3
ps -ef | grep RCVOLTM (repeat until no
processes are running)
3.4
Restart Receiving Transaction Manager
4
Perform transactions and retest the issue
5
If the transaction still fails, bounce the
database and then perform another transaction.
6
If bouncing the database or flushing Shared
Pool resolves the issue only for a few days (or a few weeks) and bounce
database (or flush Shared Pool) must be repeated periodically to resolve
the issue, please log a Service Request.
👉 Check our complete guide: Oracle Error Codes Guide
Author Box
About the Author
Rana Abdul Wahid is an experienced Oracle Database Administrator with expertise in Oracle Database Administration, Oracle Data Guard, RMAN Backup & Recovery, Oracle RAC, Oracle E-Business Suite, Performance Tuning, and High Availability Solutions.
Through this blog, he shares practical Oracle DBA solutions, troubleshooting guides, interview preparation resources, and production-tested best practices for database professionals worldwide.
Thanks for sharing.
ReplyDelete