Month: November 2024
-
How To Change Oracle Central Inventory Location
The content discusses the steps of changing the Oracle Central Inventory location for a non-standard installation to ensure consistency before applying Ansible Playbooks for Oracle Database Update. The article explains the role of the Central Inventory, details steps to find the current location, copy directories, update configuration files, and verify the process. It also notes that similar changes on Windows are unsupported.
-
Upgrade Oracle Database Time Zone (DST) version: Key Considerations
The necessity of a time zone upgrade depends on whether a database stores timestamp data with time zones. For organizations with clients in various time zones, upgrading may be essential. The data types TIMESTAMP WITH TIME ZONE (TSTZ) and TIMESTAMP WITH LOCAL TIME ZONE (TSLTZ) are key considerations, with TSTZ retaining original time zone data while TSLTZ normalizes it according to DBTIMEZONE value. Oracle’s Data Pump requires matching time zone versions during data transfers. The steps for upgrading the time zone in a sample database are explained in detail.
-
Column-Level Auditing in Oracle: audit_condition Explained
Unified Auditing mechanism currently in 19c lacks affected rows count reporting and column-level monitoring, presenting challenges in detecting data accesses. Upcoming Oracle Database 23ai will introduce column-level monitoring, allowing focused audits on specific sensitive columns like PAN and SSN. Until then, Fine-Grained Auditing can help track sensitive data at a granular level. Both auditing methods can be effectively used together for comprehensive auditing solutions. Is it possible to audit a specific column for specific users only, and only when rows are returned? I demonstrate how to do this using DBMS_FGA.
-
ORA-30554 errors on Function-Based Spatial Indexes after Spatial Bundle Patch
After applying the Spatial Bundle Patch, ORA-30554 errors may occur on functional indexes that use spatial operators. Functional indexes provide the benefit of spatial indexing but can become disabled after changes to dependent functions. Specific commands are required to re-enable them. This blog post provides details on handling spatial operations, managing indexes, and troubleshooting issues that arise after updates.
-
ORA-00942 Errors from Wnnn Slave Processes working on Behalf of FBDA: Solutions Provided
This post discusses troubleshooting ORA-00942 errors from Wnnn Processes working on Behalf of FBDA (Flashback Data Archive) process. By enabling error tracing, numerous ORA-00942 entries appeared in the alert log. The focus is on the relationship between Wnnn slave processes and Flashback Data Archive management, highlighting that untriggered archive history table creation leads to parsing failures. The absence of SYS_FBA_* tables due to lack of DML operations led to failed parsing attempts by FBDA, adversely affecting performance metrics. Two solutions are suggested: reconsidering Flashback Data Archive necessity for these tables or triggering the creation of SYS_FBA_* tables through minor modifications.
-
Automate Oracle Database Patching with Ansible Playbooks – 19.24
This post discusses the introduction of a new patching feature (one-button patching) in the AutoUpgrade tool, now at version 24.7, which simplifies the database release update process. Although currently, it only supports single-instance homes and Oracle Database 19c on Linux, the Oracle Database Upgrade Team will be addressing additional requirements in future versions. Since automating patching is essential for large environments to ensure updates and compliance, I have provided a comprehensive set of Ansible playbooks for database patching(19.24) on my GitHub repo, which can help promote efficiency and reduce errors in the patching process.
Osman’s DBlog 