All Receiving Transactions Fail with
rvtptcontrol Error
Applies
to:
Oracle Application Install - Version: 11.5.10.0
and later.
Oracle Inventory Management - Version: 11.5.1
to 12.1.3
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
Thanks for sharing.
ReplyDelete