database upgrade

utlrp hangs after upgrade to 12c ERP database

We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…

Read More

SOA webservices not working after 12c ERP db upgrade

After upgrading  database from oracle 11g to 12c in Oracle Apps R12.1.3,  got a strange issue where SOA webservices- SOAP, REST  stopped. The following url showed 404 http://host.domain:8000/webservices/SOAProvider/?testquery The issue…

Read More

Oracle 19c Database Upgrade From 12.2.0.1.0 to 19.3.0.0 Using Manual Method

Oracle 19c Database Upgrade DETAILS SOURCE TARGET OS_VERSION OEL 6.4 OEL 6.4 DB_VERSION 12.2.0.1 19.3.0.0 DB_NAME PROD PROD ORACLE_HOME /u01/app/oracle/product/12.2.0.1/db_1 /u01/app/oracle/product/19.0.0/dbhome_1 INSTALL THE 19C BINARIES  CREATE THE REQIRED DIRECTORIES &…

Read More