Techgoeasy

Pre-built Oracle database for learning and testing using Oracle Developer VM

Oracle Developer Day pre-installed virtual machine is very useful for performing lab testing on the Oracle database. It is beneficial for practising the Oracle database on a Linux machine on your laptop. You can also export your application database and import it into this pre-installed Oracle VM, It is very quick and easy to set […]

Pre-built Oracle database for learning and testing using Oracle Developer VM Read More »

How to re-attach 12.2 E-Business Oracle Homes to the central inventory

Oracle, Oracle Ebuisness Suite

In R12.1, we have just two applications homes (10.1.2) and (10.1.3) and database homes registered in central inventory. Due to dual filesystem and weblogic inclusion, this has undergone drastic changes, We have now 4 Oracle homes per filesystem registered in central inventory and one database home. This article presents How to re-attach 12.2 E-Business Oracle Homes

How to re-attach 12.2 E-Business Oracle Homes to the central inventory Read More »

New Optimizer Feature with 11g,12c and 19c

Oracle, Oracle Database, Oracle Ebuisness Suite

New Optimizer Feature with 11g (1) Invisible indexes With an 11g release, the index can be made invisible. They will be maintained all the time and can be made visible at any time alter index K invisible; Optimizer will not use the index if it is invisible alter index K visible; If want one query

New Optimizer Feature with 11g,12c and 19c Read More »

RMAN DUPLICATE DATABASE CLONING WITH ACTIVE DATABASE

Oracle, Oracle Database

What is duplicate using the Active database : Active database duplication copies the target database over the network to the destination and then creates the duplicate database. Only difference is you don’t need to have the pre-existing RMAN backups and copies. The duplication work is performed by an auxiliary channel. This channel corresponds to a

RMAN DUPLICATE DATABASE CLONING WITH ACTIVE DATABASE Read More »

Troubleshooting Workflow Notification Mailer issues

Oracle, Oracle Ebuisness Suite

To Troubleshoot Workflow Notification Mailer issues, we need to understand how outbound and inbound processing works Outbound Notification Processing – -Creation of Workflow notification raises oracle.apps.wf.notification.send event.-This event is deferred immediately and placed on the WF_DEFERRED agent.-Workflow Agent Listener on the WF_DEFERRED queue processes the deferred subscription.-Subscription to this event calls the Generate function (WF_XML.Generate)

Troubleshooting Workflow Notification Mailer issues Read More »

Top AWR useful queries for R12.2/R12.1 Upgrade

Oracle, Oracle Ebuisness Suite

R12.1/R12.2 is a pretty big and time-consuming upgrade. We need to find all the long-running sql to resolve the R12.2 upgrade performance issues. Since each iteration takes a lot of time, it is important, that we try to find out the performance issues in fewer iterations and fix them accordingly Here are Top AWR useful queries to

Top AWR useful queries for R12.2/R12.1 Upgrade Read More »