We often need to perform reorganization of the tables. We have to do offline by taking the system down and it consumes a lot of time. we can perform an Online table redefinition using DBMS_REDEFINITION. This feature is available from 9i. How Oracle internally achieve this Online table redefinition There are some Restrictions Tables with …
Online table redefinition using DBMS_REDEFINITION Read More »
We often get in situations where we are Unable to Start Output Post Processor and workflow-related Concurrent Manager. If we check the error in the concurrent manager logs we see the following errors Error in log file : $ cat FNDOPP10587566924.txtUnable to initialize state monitor.oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01403: no data foundORA-06512: at “APPS.FND_CP_GSM_IPC”, line 539ORA-06512: at line 1at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233)at …
Unable to Start Output Post Processor and workflow related Concurrent Manager Read More »
The concept of a “Recycle Bin” plays a crucial role in data recovery and management. This feature, introduced in Oracle 10g, is akin to the recycle bin in Windows or the trash in macOS, providing a safety net for data that has been deleted. This article, we will discuss the recycle bin in Oracle, How …
How to check recycle bin in Oracle: Purge, enable/disable Read More »
R12.2 is the latest Release of Oracle E-business Suite Products. Here we will be discussing the Login flow in R12.2 and how to troubleshoot login issues in R12.2 Login flow in R12.2 Here is the processing in terms of URL(Login HTTP headers) When the EBS login works OK, the browser will be redirected to various …
As part of learning the Oracle SQL tutorial, Here is good detail on the group by Oracle Group by Oracle We use Group by in the select statement to group rows into summary rows using column or expression. We often used aggregate or group functions on the group to obtain the summary rows Syntax SELECT col1, …
We can retrieve Instance Metadata like OCID, Display Name, Region, Availability Domain, Fault domain, Compartment OCID, Instance shape, Subnet CIDR, etc in three ways. Using oci-metadata #oci-metadata Instance details: Display Name: tech Region: uk-london-1 Canonical Region Name: us-ashburn-1 Availability Domain: DSdu:US-ASHBURN-1-AD-3 Fault domain: FAULT-DOMAIN-1 OCID: ocid1.instance.oc1.us-ashburn-1.abwgiljrfu6w22gihsxj4h6m6ybabv3mb23edmqhj4kamvv2sdodk7voplfq Compartment OCID: ocid1.compartment.oc1..aaaaaaaamlbsubwajqyvzyrqas6e6sbl3iqp55u6yloyxmg4muaks5xvxbuq Instance shape: VM.Standard2.1 Image ID: ocid1.image.oc1.uk-london-1.aaaaaaaavrftjg3fa2uw5ndqin3tjme3jc4vpxnsysoxetlswsr6aqlfwurq …
How To Retrieve Instance Metadata from Server Read More »
