In this post, we will discuss recycle bin in oracle, how to check recycle bin in oracle, how to check if recycle bin is enabled in oracle, how to purge recycle bin in oracle What is recycle bin in oracle The Recycle Bin is a virtual container where all dropped objects reside. The dropped objects […]
how to check fra size in oracle: Location, usage, change size
The Flash recovery area(FRA) is an important location. It stores archivelog, flashback logs, backups etc. Here in this post, we will see how to check fra size in oracle, flash recovery area usage query, and how to increase fra size in oracle how to check fra size in oracle select * from v$recovery_file_dest; flash recovery […]
How to Update the Variables in Context file in EBS
Many times, we need to Update the Variables in Context file in EBS. It could be one variable or a lot of variables. There are many ways to do it Manual Method Here you open the file in the vi or nano editor and go to the variable location and change the value Changes Through […]
AutoConfig Search Utility
We use Autoconfig to manage configuration files in EBS. We generally make changes in the context file and run the autoconfig. Now suppose we want to know what all files will be impacted by the particular variable in the context file. One way would be to search the INST_TOP and other tops for it, but […]
How to run autoconfig in 19c database with EBS
We know that with 19c, the EBS database is a Multitenant database, we need to take care of a few things before running Autoconfig. Here are the steps on how to run autoconfig in the 19c database (1) We have to make sure Listener in the database server is started from the CDB $ORACLE_HOME/network/admin/listener.ora Please […]
Important Changes in Autoconfig R12.2
With Oracle E-Business Suite Release 12.2, OC4J has been replaced with Oracle WebLogic Server. This has resulted in a reduced role for AutoConfig in R12.2 in the configuration of the Oracle HTTP Server and the oacore, oafm, forms, and forms-c4ws services. This article talks about changes in Autoconfig R12.2 Up to and including Oracle E-Business […]