I was working on R12.2 Test env and I was suppose to increase the JVM(add the manage server in R12.2) for the oacore to sustain the load The procedure to increase JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on […]
How to run sql tuning advisor for a sql _id
Many times a sql may be running long and we may need to run sql tuning advisor to get the recommendation to resolve the long running issue.In this post, we would be looking at the steps to achieve it Steps for running sql tuning advisor on the particular sql -id in the Cursor cache Create […]
How to rollback the patch after failed cutover phase in R12.2
There may be scenario when cutover phase failed . It is possible to go back to previous state of cutover(rollback the patch) ,if flashback database is either enabled in the database or we have taken full backup prior to cutover I would be explaining it with respect to Database Flashback to rollback the patch I am […]
How to upgrade EBS database to 19c: Step by Step
Here in this post , we wil checking out Upgrading Database to 19c with R12.1 Important points about 19c Upgrade When upgrading your Oracle E-Business Suite to Oracle Database 19c, your database will be converted to a multitenant architecture, which will consist of a Container Database (CDB) with a single Pluggable Database. Only multitenant architecture […]
How to rollback the Oracle patch
We apply lot of patches to Oracle product to add new feature, to rectify bugs. Sometime the patch do not work as expected and we need to rollback the oracle patch. I am presenting here the rollback cases for different type of Oracle patches Rollback of Database patches Database patches are applied using opatch. Each […]
how to drop table in oracle
The DROP TABLE oracle command is used to remove a table from the database. The dropped table and its data remain no longer available for selection. Dropping a table drops the index and triggers associated with it. Oracle Views, synonym are not dropped but they become invalid Dropped table can be recovered using FLASHBACK utility, if […]