Introduction / Issue Organizations often need to migrate SQL Server databases from on-premises environments to Microsoft Azure SQL Database to leverage cloud-based features such as high availability, scalability, automated…
Read MoreIntroduction / Issue Organizations migrating from on-premises SQL Server environments to Microsoft Azure SQL Database often encounter challenges because Azure SQL Database does not support traditional SQL Server migration…
Read MoreUnderstanding Ledger in Oracle ERP Fusion Introduction / Issue: A recurring gap I see with consultants and even client teams new to Oracle Fusion Financials is a shallow understanding of…
Read MoreGL_AI_Agent_26B_Blog Oracle Fusion Financials 26B – GL AI Agent Setup Guidance Introduction / Issue: For Oracle Financials consultants planning to enable and run the GL AI Agent introduced in the…
Read MoreUnderstanding MongoDB’s Distributed Architecture: Replication and Sharding Introduction / Issue As applications grow, they require databases that can handle increasing amounts of data while ensuring high availability and performance. Traditional single-server databases…
Read MoreUnderstanding MongoDB Document Model and Flexible Schema Introduction / Issue Traditional relational databases require a predefined schema, where every record in a table must follow the same structure. While this…
Read MoreLogin into the Dev Instance with Admin User Go to Tools and Click on Security Console Go to Roles and search for role, Click on Plan Management Role Click on…
Read MoreSupplier Calendar – Clipper -Supplier Test Step 1 : Define ExceptionsNavigation: Setup and maintenance 🡪 Global Search 🡪 Manage Schedule Exceptions 🡪 Create 🡪 Enter the Required Details and Exception…
Read MoreWhy Do We Need Immutable Tables? In many applications, certain data should never be modified once it is stored. Traditional tables allow UPDATE and DELETE operations, which can accidentally or intentionally change critical records. Immutable tables solve this problem by allowing only INSERT operations and protecting data from modification or deletion until the configured retention period expires. Common use cases include: Audit logs Financial transactions Compliance records (SOX, HIPAA, GDPR) Healthcare data Legal and government records Immutable Tables in Oracle Database Immutable tables are insert-only relational structures that enforce immutability through system-managed retention controls at both the table and row levels. These controls prohibit UPDATE and DELETE operations until the retention period expires. While functionally similar to blockchain tables in terms of data immutability, immutable tables do not maintain cryptographic hash links between records. Oracle introduced immutable tables in Oracle Database 19c Release Update 19.11, and they are supported in all later releases. Prerequisites The COMPATIBLE initialization parameter must be set to the appropriate value before immutable tables can be used. [oracle@Primary ~]$ sqlplus / as sysdba NOTE: Verify the database version and apply the appropriate COMPATIBLE value accordingly. SQL> STARTUP SQL> ALTER SYSTEM SET compatible=’19.11.0′ SCOPE=SPFILE; System altered. SQL> SHUT IMMEDIATE; Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP ORACLE instance started. Oracle Version Requirements Immutable Tables were introduced in Oracle Database 19c RU 19.11. Oracle 19.11 contains a few known issues related to retention policy modifications. These issues are resolved in Oracle 19.12 and later releases, including Oracle 21.3. For production environments, Oracle recommends using the latest supported Release Update (RU).…
Read MoreWhy Oracle Database Vault? In a traditional Oracle database, users with powerful privileges such as SYS or DBA can access sensitive application data. While these privileges are required for database administration, they can also pose security and compliance risks. Oracle Database Vault addresses this by enforcing separation of duties and restricting access to sensitive data, even for privileged users. Common use cases include: Protecting HR employee records Securing Finance and payroll data Meeting compliance requirements such as SOX, PCI-DSS, and HIPAA Restricting privileged users from accessing application data Step 1. Verify Current Database Vault and Oracle Label Security Status Start the database. SQL> STARTUP ORACLE instance started. Total System Global Area 1560278096 bytes Fixed Size 9135184 bytes Variable Size 385875968 bytes Database Buffers 1157627904 bytes Redo Buffers 7639040 bytes Database mounted. Database opened. Connect to the CDB root. SQL> SHOW CON_NAME CON_NAME CDB$ROOT Verify whether Database Vault is enabled. SQL> SELECT value FROM v$option WHERE parameter = ‘Oracle Database Vault’; VALUE—– FALSE Verify whether Oracle Label Security is enabled. SQL> SELECT value FROM v$option WHERE parameter = ‘Oracle Label Security’; VALUE—–FALSE…
Read More