Database Blog

Oracle Database Vault

The Oracle Database Vault security controls protect application data from unauthorized access and comply with privacy and regulatory requirements. We can deploy controls to block privileged account access to application…

Read More

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 More

How 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 More

Oracle 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 More

ACLPrivileges 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 More

Find 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 More

How 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 More

12.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 More

Admin 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 More

Integrate 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 More