Oracle Core DBA
How to run Oracle SQL tuning advisor for a sql_id in Oracle Database
How to run SQL tuning advisor for a SQL_ID or SQL Statement Run SQL tuning advisor against a SQL statement or sql_id, it pr…
How to run SQL tuning advisor for a SQL_ID or SQL Statement Run SQL tuning advisor against a SQL statement or sql_id, it pr…
Execute the below steps to delete the inactive patches and then proceed with patching if any performance issue in oracle Dat…
Finding Out Patches Applied to WebLogic Server in EBS 12.2 To get a list of applied patches on the WebLogic Server home, us…
I have configured Rest API with my EBS. I was following the Oracle note ID: 1311068.1, Installing Oracle E-Business Suite In…
When attempting to register a new supplier on Oracle EBS , the following error occurs. ERROR ----------------------- Error…
How to create JDBC data source connection from WebLogic to Oracle Cloud Autonomous Database ATP or ADW Prerequisites Step 1…
Migrate on-premises Oracle database to Oracle Cloud Architecture(OCI) Autonomous Database using Data Pump Conventional Expor…
Oracle EBS R12 how to know port pool of apps Tier services 1) To get the port pool value of Oracle EBS Application Tier gre…
Retrieve Apps password or Forgot Apps Password in Oracle EBS R12 Step 1 : login to database server with sys user sql…
Prerequisite to install the Oracle EBS with Rapid wiz and Clone EBS with Rapid Clone 1-Prerequisite: - a)Verify the disk s…
How to Automate the restart of Oracle EBS WebLogic Managed OAcore & OAfm servers using Shell Script Below shell script …
Best practice for configuring Data Guard Switchover / Failover HA service between primary and DR sites. --------------------…
If File system is full or ASM file System is full and not able to add the space on the tablespace, you can reclaim the unuse…
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException No such file or directory submitted a concurre…