Object Storage vs Block Storage
Block storage is the oldest and simplest form of data storage. Block storage stores data in fixed-sized ‘blocks’. By itself, a block typically only houses a portion of the data.…
Read MoreHow is Oracle Autonomous Data Warehouse different from the rest of Cloud Database Services
Cloud Database is not new. There are several options from various technology vendors to choose from. However, Oracle Autonomous Data Warehouse is a perfect fit for enterprise business analysts, and…
Read MoreOracle Analytics Server (OAS) vs Oracle Analytics Cloud (OAC)
OAC and OAS are congruent products and therefore enable organizations to leverage both deployments simultaneously. Going from OAS to OAC or vice-versa is as simple as creating a snapshot from…
Read MoreACLPrivileges for websites
FIND ACL PRIVILEGES ==================== set pages 1000 lines 1000 col acl for a50 col principal for a20 col privilege for a20 col is_grant for a20 col invert for a20 col…
Read MoreFind the table size including LOB segments
col owner FOR a20 col segment_name FOR a40 SELECT S.owner “Owner”, Nvl(S.segment_name, ‘TABLE TOTAL SIZE’) “Segment_name”, Round(SUM(S.bytes) / 1024 / 1024 / 1024, 1) “Segment_size_GB” FROM dba_segments S WHERE S.segment_name…
Read MoreHow To Troubleshoot OID DIP Sync Mapping Problems
Consider the following scenarios: Scenario 1: DIP Import Sync from Active Directory (AD) to OID works for most entries, but fails when a new organizationalunit (ou) entry is added in…
Read More12.2 E-Business Suite Applications Technology Stack Oacore and OAFM Servers Do Not Restart And Are Stuck at State-Admin After Aborting ADOP Session And Restarting The Database / Applications Tiers
During an in progress ADOP patch session applying AD/TXK patch, users reported issues with login attempts to the E-Business Suite instance. To resolve the login issues, the ADOP patch session was…
Read MoreAdmin Server Startup Issue in EBS (R12.2) Must Run On Primary Node
Issue: Error starting Admin Server When we are starting Admin Server, getting below error sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start logs: $EBS_DOMAIN_HOME/servers/AdminServer/logs/AdminServer.log adadminsrvctl.sh should be run only from the primary node Doyensys Cause: Wrong Entry…
Read MoreIntegrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA – Supply Planning Work Area
What is Oracle ADF? Oracle Application Development Framework (Oracle ADF) is an end-to-end application framework that builds on Java EE standards and open-source technologies to simplify and accelerate implementing enterprise…
Read MoreQuery to get source code in database from back end
set verify off set feedback off set lines 300 set pages 0 set heading off set space 0 column text format a79 column line noprint select DECODE(line,1,’create or replace ‘,”)||text,…
Read More