Database Blog

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 apps adpatch fails

Many times , when applying patch using adpatch in oracle apps, the patch session session gets terminated because of network problems. The best way to continue the patch is to…

Read More

Importing excel data to oracle table using sqldeveloper

Importing excel data to oracle table using sqldeveloper Choose the table and right click Uncheck Header Select columns Choose match by position  

Read More

FRM-92102 Errors when Accessing a Forms Module

When attempting to access E-Business Suite Forms on a cloned E-Business Suite instance the following error occurs: FRM-92102 A network Error has occurred. The Forms Client has attempted to reestablish its…

Read More

Sometimes the Formsapp.ear deployment fails on Application startup after applying Patches

Error while executing the perl script txkChkFormsDeployment.pl We have determined that you need to redeploy Forms (using txkChkFormsDeployment.pl). But could not do it automatically for you, due to some issues.…

Read More

Oracle NID Utility

Oracle NID Utility – Changing the Database Name   This utility allows the user to change the DBID or the database name NID utility was introduced in Oracle 10g.  Giving…

Read More

Oracle GoldenGate 19c Silent Installlation

Introduction Usually to install database software we will use ./runInstaller graphical user interface. Some times we may not have access to a graphical user interface. Silent mode installation allows to…

Read More

Image copy Of Database using RMAN

Introduction: By default RMAN takes the backup as BACKUPSETS i.e. it combines of multiple datafiles into one or more backupsets.If you want to take the backup of datafiles as it…

Read More

Silent mode Installation of Grid and database in oracle cloud (19C)

Description: The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities.Oracle…

Read More

Migrating a Normal disk group to flex disk group in ASM oracle cloud (19C)

Description: Flex Diskgroups are the new features in oracle 12c R2 for quotas, cloning and filegroups. Oracle ASM provides two-way mirroring by default for newly-created flex disk groups. We can…

Read More