ORA Errors

Web Services : SOAP, REST Services

Web Services : SOAP, REST Services Introduction: Web Services are services offered over the web that enable communication between different applications. They allow systems built on different technologies, platforms, or…

Read More

Debug Common Errors in SFTP-Based File Transfer Integrations

Use Case:  This integration debugging script and approach is used to analyze and resolve common runtime errors in SFTP-based file transfer services, especially during file archival (Move File) operations. It…

Read More

Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time

Script to upload multiple  LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time   Use-Case: In general during the migration process/Go-Live the downtime of the server will be…

Read More

Error while upgrading the database

Error while upgrading the database from 11.2.0.4 to 19.3.0.0:- REASON: ERRORS FOUND: During Upgrade FILENAME: /u01/app/oracle/product/19c/cfgtoollogs/test19C/upgrade20200127132925/catupgrd0.log AT LINE NUMBER: 801192 —————————————————— Identifier CATJAVA 20-01-27 02:09:14 SCRIPT    = [/u01/app/oracle/product/19c/rdbms/admin/initjms.sql] ERROR     =…

Read More

ORA-30006: resource busy; acquire with WAIT timeout expired and ORA-00054: resource busy and NOWAIT specified

ORA-30006 and ORA-00054 errors raised when update operation is performed against a record, that has been locked by the user or some session FOR UPDATE. To fix this, before performing the update, check…

Read More