Faced a strange issue in oracle 12c. In automated maintenance task, sql tuning advisor was enabled. However, it was still not running. Validated dba_autotask_operation, that “sql tuning advisor” is enabled.…
Read MoreWe 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 MoreAfter 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 MoreMany 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 MoreImporting excel data to oracle table using sqldeveloper Choose the table and right click Uncheck Header Select columns Choose match by position
Read MoreWhen 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 MoreError 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 MoreOracle 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 MoreIntroduction 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 MoreIntroduction: 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