In this post, we will discuss how to drop the Oracle database. The below procedure drops the spfile also but it does not touch Oracle Home. You may want to backup the spfile before dropping the database sqlplus / as sysdba startup mount (If database not started) create pfile=’/tmp/pfile.ora’ from spfile; Dropping an Oracle database …
How to drop the oracle database Read More »
Cutover phase of adop is downtime phase of Online patching cycle. We should ensure no user access is there in that period as application processes are restarted.Before running the cutover command, ensure you are ready to commit to application of the selected patches. Once cutover is complete, it is not possible to revert to …
In this post, we will discuss, what is a restore point in Oracle, how to check a restore point in Oracle What is a Restore Point in Oracle? Guaranteed restore points Normal Restore Points How to check the restore point in Oracle You can check the restore point in the Oracle database using the below …
Oracle Database Packages are widely used in EBS R12. We have thousands of Packages in the Apps schema. These packages are loaded and modified in the Oracle database using adpatch or adop using the files in the $PRODUCT_TOP/patch/115/sql/*pls. In this article, we will see How to check Package version in EBS R12 Sometimes, we have …
The telnet client is used to connect to the MWA server in EBS. Windows has telnet installed by default but it is often disabled. If you use Start > Run > telnet and the program is not found, then telnet is disabled. In this post, we will check how we can enable it How to …
How the histograms are generated in EBS Oracle product team decides about the column where histograms are needed and those columns are inserted into the table FND_HISTOGRAM_COLS. FND_STATS collects histogram information if a column is listed in FND_HISTOGRAM_COLS. we should not use DBMS_STATS to gather stats in the EBS database as then it will create …
How the histograms are generated in EBS Read More »
