corpus.blog
41554 blogs · [ { "id": "01a0d7fa-317a-7330-9598-86c5324ba759", "title": "Troubleshooting RMAN ORA-01403 When Allocating an SBT_TAPE Channel", "url": "https://dincosman.com/2026/09/19/allocating-tape-channel-fails/", "published_at": "2026-09-19T20:45:30+00:00" }, { "id": "01a0d7fa-317a-7330-9598-86c53258e61b", "title": "Oracle Data Pump Export Fails with ORA-31642", "url": "https://dincosman.com/2026/09/19/oracle-expdp-ora-31642/", "published_at": "2026-09-18T22:37:42+00:00" }, { "id": "01a0876d-1c61-722c-839d-b2b5d4980476", "title": "Here is the wrap-up of POUG2026 (Pint With Oracle User Group).", "url": "https://dincosman.com/2026/09/07/wrap-up-of-poug2026/", "published_at": "2026-09-06T23:46:09+00:00" }, { "id": "01a0876d-1c61-722c-839d-b2b5d580fb57", "title": "rpmdb: DB_RUNRECOVERY Errors When Using dbaascli on Exacc", "url": "https://dincosman.com/2026/08/18/rpmdb-dberror-dbaascli/", "published_at": "2026-08-18T18:43:41+00:00" }, { "id": "01a0876d-1c61-722c-839d-b2b5d5e46d48", "title": "ODA Patching Issue: Resolving DCS-10045 and DCS-12013 Errors During DB Home Update", "url": "https://dincosman.com/2026/08/15/oda-patching-issue/", "published_at": "2026-08-15T13:13:14+00:00" }, { "id": "01a0876d-1c61-722c-839d-b2b5d648dec1", "title": "RMAN Register database for Catalog fails with ORA-01403", "url": "https://dincosman.com/2026/07/27/rman-register-database-fails/", "published_at": "2026-07-26T21:42:29+00:00" }, { "id": "01a0876d-1c61-722c-839d-b2b5d707da4e", "title": "ORA-48128: opening of a symbolic link is disallowed during Data Pump Export ", "url": "https://dincosman.com/2026/07/26/ora-48128-symboliclink-export/", "published_at": "2026-07-26T11:48:30+00:00" }, { "id": "01a0876d-1c61-722c-839d-b2b5d71f1cae", "title": "Escalating Update Decisions to Oracle Update Advisor", "url": "https://dincosman.com/2026/05/21/escalating-update-decisions-to-oracle-update-advisor/", "published_at": "2026-05-21T19:55:39+00:00" }, { "id": "01a0c508-28b1-71c3-b506-c80376abc385", "title": "How to Configure RHP Server for Oracle FPP Local Mode in 19c Oracle RAC", "url": "https://dincosman.com/2026/05/20/configure-rhpserver-fpp-local/", "published_at": "2026-05-20T19:12:23+00:00" }, { "id": "01a0c508-28b1-71c3-b506-c80376e26fb2", "title": "Fixing “Wallet Key Needed” Errors During Oracle PDB Migration Despite No Encrypted Tablespaces", "url": "https://dincosman.com/2026/05/18/encryption-errors-in-oracle-pdb/", "published_at": "2026-05-18T19:13:51+00:00" }, { "id": "01a0c508-28b1-71c3-b506-c80376e9d24d", "title": "Oracle Database Appliance Disk State FAILED / DiskRemoved but ASM Healthy: Troubleshooting Guide", "url": "https://dincosman.com/2026/05/17/oda-diskstate-removed/", "published_at": "2026-05-16T22:03:47+00:00" }, { "id": "01a0c508-28b1-71c3-b506-c803776e42b8", "title": "Running Oracle Forms 6i with Oracle 19c: Is It Possible?", "url": "https://dincosman.com/2026/04/26/oracle-forms6i-19cdatabase/", "published_at": "2026-04-26T18:15:13+00:00" }, { "id": "01a0c518-b171-718c-b327-f0087d9eefdc", "title": "Should You Move to Oracle Database 26ai Now?", "url": "https://dincosman.com/2026/04/24/oracle-26ai-move/", "published_at": "2026-04-24T20:40:52+00:00" }, { "id": "01a0c518-b171-718c-b327-f0087e1ce068", "title": "All features in V$OPTION become FALSE after a rollback operation", "url": "https://dincosman.com/2026/04/18/oracle-voption-all-false/", "published_at": "2026-04-18T20:24:50+00:00" }, { "id": "01a0c518-b171-718c-b327-f0087e90343b", "title": "Automating Oracle 19.28 Patching with Ansible (RAC + Grid + DB)", "url": "https://dincosman.com/2026/04/18/ansible-oracle-patching/", "published_at": "2026-04-18T10:53:39+00:00" }, { "id": "01a0c518-b171-718c-b327-f0087f691377", "title": "Opatch rollback fails – .patch_storage directory is missing", "url": "https://dincosman.com/2026/04/04/patch-storage-missing/", "published_at": "2026-04-04T19:32:45+00:00" }, { "id": "01a0c518-b171-718c-b327-f008802b8ca3", "title": "ORA-00600: internal error while Gathering Fixed Object Stats", "url": "https://dincosman.com/2026/03/29/ora-00600-gathering-stats/", "published_at": "2026-03-29T14:11:32+00:00" }, { "id": "01a0c518-b171-718c-b327-f0088065430a", "title": "Unable to Parse the Content of exa_map Error on ExaCC Grid RU Precheck", "url": "https://dincosman.com/2026/01/31/parse-examap-exacc/", "published_at": "2026-01-31T13:14:00+00:00" }, { "id": "01a0c523-9d43-72be-8553-a3b0e05a6d64", "title": "Cloning Oracle RAC Database Home to Single Instance and vice versa", "url": "https://dincosman.com/2025/12/14/cloning-oracle-homes/", "published_at": "2025-12-13T21:30:17+00:00" }, { "id": "01a0c523-9d43-72be-8553-a3b0e086111c", "title": "Backing up to a fake tape (SBT) in Oracle RMAN and using sbttest tool", "url": "https://dincosman.com/2025/11/09/backupto-fake-tape-rman/", "published_at": "2025-11-09T12:22:49+00:00" }, { "id": "01a0c523-9d43-72be-8553-a3b0e130ff05", "title": "Ping Checks Life, tnsping Checks Purpose #JoelKallmanDay", "url": "https://dincosman.com/2025/10/15/ping-tnsping-ociping-connping/", "published_at": "2025-10-14T21:47:35+00:00" }, { "id": "01a0c523-9d43-72be-8553-a3b0e1e74d62", "title": "New Exachk Criterion: Hardware Assisted Resilient Data (HARD) Validation During ASM Relocation", "url": "https://dincosman.com/2025/07/26/asm-hard-validation/", "published_at": "2025-07-26T18:55:59+00:00" }, { "id": "01a0c523-9d44-7361-af57-573bc63d0d83", "title": "Deploy Oracle Autonomous Database on your Computer", "url": "https://dincosman.com/2025/06/18/deploy-autonomous-database-locally/", "published_at": "2025-06-18T05:52:45+00:00" }, { "id": "01a0c523-9d44-7361-af57-573bc6fe8290", "title": "Oracle Database Patching with AutoUpgrade in Offline Environments", "url": "https://dincosman.com/2025/06/14/autoupgrade-offline-patch/", "published_at": "2025-06-14T10:40:51+00:00" }, { "id": "01a0c52f-1179-733c-97fb-347dfff353ee", "title": "Downloading Oracle Patches with AutoUpgrade on Windows Behind a Proxy", "url": "https://dincosman.com/2025/06/04/download-patches-behind-proxy/", "published_at": "2025-06-04T16:22:20+00:00" }, { "id": "01a0c52f-1179-733c-97fb-347e0055efb6", "title": "How Oracle Changes Your SQL: Uncovering Hidden Query Transformations", "url": "https://dincosman.com/2025/05/24/hidden-transformations/", "published_at": "2025-05-24T10:33:00+00:00" }, { "id": "01a0c52f-1179-733c-97fb-347e00c3ff9b", "title": "Avoid Misusing LEFT JOIN in SQL Queries", "url": "https://dincosman.com/2025/05/17/left-join-for-everything/", "published_at": "2025-05-17T08:26:00+00:00" }, { "id": "01a0c52f-1179-733c-97fb-347e01682783", "title": "How SQL Handles No Matching Rows in Aggregation", "url": "https://dincosman.com/2025/05/17/aggregate-function-with-nomatch/", "published_at": "2025-05-17T08:25:22+00:00" }, { "id": "01a0c52f-1179-733c-97fb-347e0234be91", "title": "Why NO_DATA_FOUND Behavior Differs in SQL and PL/SQL", "url": "https://dincosman.com/2025/05/17/no-data-found-not-raised/", "published_at": "2025-05-17T08:22:38+00:00" }, { "id": "01a0c52f-1179-733c-97fb-347e02fa0bcd", "title": "Scalar Subquery Caching Behavior in a SQL Statement", "url": "https://dincosman.com/2025/05/17/scalar-subquery-caching/", "published_at": "2025-05-17T08:20:36+00:00" }, { "id": "01a0c539-680b-7117-a295-29e8ae1f6f8a", "title": "NVL and DECODE: Lazy vs Eager Evaluation", "url": "https://dincosman.com/2025/05/17/nvl-eager-evaluates/", "published_at": "2025-05-17T08:19:34+00:00" }, { "id": "01a0c539-680b-7117-a295-29e8ae5a8b92", "title": "Common SQL and PL/SQL Pitfalls: Insights from Real-World Experience", "url": "https://dincosman.com/2025/05/17/common-sql-pitfalls/", "published_at": "2025-05-17T08:18:14+00:00" }, { "id": "01a0c539-680b-7117-a295-29e8aeb6bdd6", "title": "Oracle Hash Partitioning : Benefits and Best Practices", "url": "https://dincosman.com/2025/05/09/oracle-hash-partitioning/", "published_at": "2025-05-09T10:52:47+00:00" }, { "id": "01a0c539-680b-7117-a295-29e8af3988f2", "title": "DBMS_METADATA.GET_DDL Does Not Return Hashed Passwords Anymore", "url": "https://dincosman.com/2025/05/02/get-ddl-user-password/", "published_at": "2025-05-02T10:09:05+00:00" }, { "id": "01a0c539-680b-7117-a295-29e8b00009f6", "title": "Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes)", "url": "https://dincosman.com/2025/04/26/ansible-for-oracle-dba/", "published_at": "2025-04-26T13:21:49+00:00" }, { "id": "01a0c539-680b-7117-a295-29e8b07db25f", "title": "Disabling the Oracle Compression Advisor", "url": "https://dincosman.com/2025/04/20/disable-compression-advisor/", "published_at": "2025-04-20T11:20:16+00:00" }, { "id": "01a0c542-b08b-7150-8d1d-3f7f0eb666ac", "title": "SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Cases", "url": "https://dincosman.com/2025/04/10/sqlplanbaselines-sqlpatches-sqlprofiles/", "published_at": "2025-04-10T20:38:56+00:00" }, { "id": "01a0c542-b08b-7150-8d1d-3f7f0f76bbfe", "title": "Exadata: Configure Management Network Switch with multiple uplinks for redundant connectivity", "url": "https://dincosman.com/2025/04/07/exadata-management-switch/", "published_at": "2025-04-07T19:03:36+00:00" }, { "id": "01a0c542-b08b-7150-8d1d-3f7f0fcd6f11", "title": "Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnect", "url": "https://dincosman.com/2025/03/13/cluster-interconnects/", "published_at": "2025-03-13T12:55:02+00:00" }, { "id": "01a0c542-b08b-7150-8d1d-3f7f105f866b", "title": "Tools and Scripts for Oracle Database Health Checks and Diagnostics", "url": "https://dincosman.com/2025/02/23/oracle-database-health/", "published_at": "2025-02-23T12:46:47+00:00" }, { "id": "01a0c542-b08b-7150-8d1d-3f7f112b0d51", "title": "Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILURE", "url": "https://dincosman.com/2025/02/09/bind-var-related-child-cursors/", "published_at": "2025-02-09T13:13:00+00:00" }, { "id": "01a0c542-b08b-7150-8d1d-3f7f11660f4f", "title": "Checking for NOT NULL Values in a BLOB Column", "url": "https://dincosman.com/2025/01/10/retrieve-notnull-blobs/", "published_at": "2025-01-10T20:17:59+00:00" }, { "id": "01a0c54b-830c-71e8-a78c-fa598b73b7c6", "title": "Moving Oracle Database Objects to Another Tablespace in 19c (Table, Index, LOB Column)", "url": "https://dincosman.com/2025/01/03/move-tablespace/", "published_at": "2025-01-03T20:47:06+00:00" }, { "id": "01a0c54b-830c-71e8-a78c-fa598c2277f4", "title": "Oracle Database 19c APEX Upgrade: 19.2 to 24.1.7", "url": "https://dincosman.com/2024/12/21/oracle-apex-upgrade/", "published_at": "2024-12-21T14:31:39+00:00" }, { "id": "01a0c54b-830c-71e8-a78c-fa598c2886fd", "title": "Oracle Incrementally Updated Backups : Detect and Delete Orphaned (Expired) Datafile Copies", "url": "https://dincosman.com/2024/12/15/delete-expired-datafile-copies/", "published_at": "2024-12-15T18:16:36+00:00" }, { "id": "01a0c54b-830c-71e8-a78c-fa598cc5d4d3", "title": "CPU-intensive query to simulate CPU load in PostgreSQL database", "url": "https://dincosman.com/2024/12/13/cpu-intensive-query-for-postgresql/", "published_at": "2024-12-13T18:48:28+00:00" }, { "id": "01a0c54b-830c-71e8-a78c-fa598dbf81ae", "title": "CPU-intensive query to simulate CPU load in Oracle database", "url": "https://dincosman.com/2024/12/13/cpu-intensive-query-for-oracle/", "published_at": "2024-12-13T18:45:34+00:00" }, { "id": "01a0c54b-830c-71e8-a78c-fa598e95164a", "title": "Finding Row Counts for All Tables in Oracle Database", "url": "https://dincosman.com/2024/12/07/find-row-counts-oracle/", "published_at": "2024-12-07T10:47:00+00:00" }, { "id": "01a0c553-c71e-709e-af50-d64887455e84", "title": "Finding Row Count for All Tables in PostgreSQL Database", "url": "https://dincosman.com/2024/12/07/find-row-counts-postgresql/", "published_at": "2024-12-07T10:45:00+00:00" }, { "id": "01a0c553-c71e-709e-af50-d648880b17e3", "title": "Table Statistics vs. SELECT COUNT: What to Choose?", "url": "https://dincosman.com/2024/12/07/finding-row-counts/", "published_at": "2024-12-07T10:35:04+00:00" }, { "id": "01a0c553-c71e-709e-af50-d64889093e12", "title": "Installing Oracle Database 23ai on ARM Macs with Sample Schemas", "url": "https://dincosman.com/2024/12/03/install-oracle23ai-on-macbook/", "published_at": "2024-12-02T21:36:51+00:00" }, { "id": "01a0c553-c71e-709e-af50-d6488969f338", "title": "File System Corruption on Root (/) Partition of Exadata Storage Server – Oracle Linux 7", "url": "https://dincosman.com/2024/12/01/exadata-file-system-corruption/", "published_at": "2024-12-01T06:35:22+00:00" }, { "id": "01a0c553-c71e-709e-af50-d64889eaef33", "title": "How To Change Oracle Central Inventory Location", "url": "https://dincosman.com/2024/11/23/change-central-inventory/", "published_at": "2024-11-23T12:55:13+00:00" }, { "id": "01a0c553-c71e-709e-af50-d6488a056c14", "title": "Upgrade Oracle Database Time Zone (DST) version: Key Considerations", "url": "https://dincosman.com/2024/11/16/database-time-zone-upgrade/", "published_at": "2024-11-16T11:27:13+00:00" }, { "id": "01a0c55c-2945-7262-9363-bc013a630300", "title": "Column-Level Auditing in Oracle: audit_condition Explained", "url": "https://dincosman.com/2024/11/10/fga-audit-condition/", "published_at": "2024-11-10T08:41:49+00:00" }, { "id": "01a0c55c-2945-7262-9363-bc013a8210b1", "title": "ORA-30554 errors on Function-Based Spatial Indexes after Spatial Bundle Patch", "url": "https://dincosman.com/2024/11/09/ora-30554-functional-indexes/", "published_at": "2024-11-09T07:40:59+00:00" }, { "id": "01a0c55c-2945-7262-9363-bc013b1727b1", "title": "ORA-00942 Errors from Wnnn Slave Processes working on Behalf of FBDA: Solutions Provided", "url": "https://dincosman.com/2024/11/02/wnnn-process-ora-00942/", "published_at": "2024-11-02T18:37:18+00:00" }, { "id": "01a0c55c-2945-7262-9363-bc013c038a03", "title": "Automate Oracle Database Patching with Ansible Playbooks – 19.24", "url": "https://dincosman.com/2024/11/01/ansible-playbooks-for-1924/", "published_at": "2024-11-01T18:38:40+00:00" }, { "id": "01a0c55c-2945-7262-9363-bc013c3e4ff8", "title": "SYSAUX Tablespace Growing Rapidly due to SCHEDULER$_JOB_OUTPUT Table and ORA-01031 Error in Automatic segment advisor task", "url": "https://dincosman.com/2024/10/27/sysaux-tablespace-growing/", "published_at": "2024-10-26T21:27:49+00:00" }, { "id": "01a0c55c-2945-7262-9363-bc013ccd4ced", "title": "A 3D data with a 2D SRID may result with ORA-13029 #JoelKallmanDay", "url": "https://dincosman.com/2024/10/16/ora-13029-invalid-srid/", "published_at": "2024-10-16T04:52:20+00:00" }, { "id": "01a0c564-78f5-7181-8434-6b484613e799", "title": "How to send mail from PostgreSQL database", "url": "https://dincosman.com/2024/10/06/send-mail-postgresql/", "published_at": "2024-10-06T10:47:00+00:00" }, { "id": "01a0c564-78f5-7181-8434-6b4846924ca7", "title": "Oracle ACFS File System: Inode Limitations Explained", "url": "https://dincosman.com/2024/09/29/oracle-acfs-inode/", "published_at": "2024-09-29T09:21:26+00:00" }, { "id": "01a0c564-78f5-7181-8434-6b4846ddf58f", "title": "Troubleshooting gc cr/current block lost events and Improving Oracle RAC Network Performance", "url": "https://dincosman.com/2024/09/22/gc-block-lost/", "published_at": "2024-09-22T10:01:04+00:00" }, { "id": "01a0c564-78f5-7181-8434-6b4846eb7fa1", "title": "Resolving Enq: TX – Row Lock Contention with Real-life Scenario Analysis", "url": "https://dincosman.com/2024/09/01/enq-tx-row-lock/", "published_at": "2024-09-01T11:40:07+00:00" }, { "id": "01a0c564-78f5-7181-8434-6b48477e315b", "title": "v$sql INVALIDATION column and Prevent SQL Cursor Invalidation", "url": "https://dincosman.com/2024/08/25/sql-cursor-invalidation/", "published_at": "2024-08-25T10:58:32+00:00" }, { "id": "01a0c564-78f5-7181-8434-6b48485874f2", "title": "How to configure HAProxy with external-check to query PostgreSQL database directly", "url": "https://dincosman.com/2024/08/10/haproxy-external-sqlcheck/", "published_at": "2024-08-10T12:14:46+00:00" }, { "id": "01a0c56b-a4d6-7021-8a28-e899598fdc03", "title": "Oracle Database 23ai Fuzzy Matching and Similarity Searches", "url": "https://dincosman.com/2024/08/04/fuzzy-search-oracle/", "published_at": "2024-08-04T15:59:51+00:00" }, { "id": "01a0c56b-a4d6-7021-8a28-e8995a556b92", "title": "Unified Audit Trail: SQL Text Not Recorded in Syslog", "url": "https://dincosman.com/2024/08/04/audit-records-tojson/", "published_at": "2024-08-04T12:27:44+00:00" }, { "id": "01a0c56b-a4d6-7021-8a28-e8995af2d7cc", "title": "Fuzzy Matching in PostgreSQL: A Guide to pg_trgm extension", "url": "https://dincosman.com/2024/08/02/postgresql-search-like-google/", "published_at": "2024-08-02T18:12:02+00:00" }, { "id": "01a0c56b-a4d6-7021-8a28-e8995bcc8d28", "title": "How to Remove Orphan Large Objects in PostgreSQL", "url": "https://dincosman.com/2024/07/28/remove-orphaned-blobs/", "published_at": "2024-07-27T21:31:50+00:00" }, { "id": "01a0c56b-a4d6-7021-8a28-e8995be81845", "title": "Comparing Oracle Users’ Decrypted Passwords with RockYou2024", "url": "https://dincosman.com/2024/07/26/compare-oracle-password/", "published_at": "2024-07-26T19:29:30+00:00" }, { "id": "01a0c56b-a4d6-7021-8a28-e8995bf3376d", "title": "pg_amcheck: PostgreSQL corruption detection tool", "url": "https://dincosman.com/2024/06/29/pg-amcheck/", "published_at": "2024-06-29T19:15:32+00:00" }, { "id": "01a0c575-3c12-7307-a688-f0b46956712a", "title": "Unusable and Parallel indexes on Flashback Data Archive Tables in 19.22", "url": "https://dincosman.com/2024/06/24/unusable-index-fda-tables/", "published_at": "2024-06-24T16:52:32+00:00" }, { "id": "01a0c575-3c12-7307-a688-f0b4697fbc08", "title": "Transactional DDL in PostgreSQL", "url": "https://dincosman.com/2024/06/20/transactional-ddl/", "published_at": "2024-06-20T19:34:00+00:00" }, { "id": "01a0c575-3c12-7307-a688-f0b46a29df6a", "title": "Holistic Patching for Oracle Enterprise Manager", "url": "https://dincosman.com/2024/06/11/holistic-patching/", "published_at": "2024-06-11T15:52:48+00:00" }, { "id": "01a0c575-3c12-7307-a688-f0b46aadc9f8", "title": "Create a Function-based Index with NLSSORT", "url": "https://dincosman.com/2024/06/06/nlssort/", "published_at": "2024-06-06T18:17:28+00:00" }, { "id": "01a0c575-3c12-7307-a688-f0b46b23c7c2", "title": "Installing MariaDB and Configuring MaxScale NoSQL Protocol Module on Oracle Linux 8", "url": "https://dincosman.com/2024/06/02/nosql-protocol-mariadb/", "published_at": "2024-06-02T20:37:08+00:00" }, { "id": "01a0c575-3c12-7307-a688-f0b46c149201", "title": "MongoDB Alternatives: FerretDB vs Oracle vs MariaDB as NoSQL Solutions", "url": "https://dincosman.com/2024/05/19/seamless-nosql/", "published_at": "2024-05-19T10:19:04+00:00" }, { "id": "01a0c583-01cd-70f2-8054-c481a64b32f8", "title": "How to Install Oracle Database API for MongoDB", "url": "https://dincosman.com/2024/05/14/mongo-api-for-oracle/", "published_at": "2024-05-14T19:33:52+00:00" }, { "id": "01a0c583-01cd-70f2-8054-c481a702100d", "title": "Installing FerretDB Using PostgreSQL as the Database Engine", "url": "https://dincosman.com/2024/05/14/ferretdb-installation/", "published_at": "2024-05-14T13:09:51+00:00" }, { "id": "01a0c583-01cd-70f2-8054-c481a72a9d60", "title": "MongoDB Community Version Installation on Oracle Linux Server", "url": "https://dincosman.com/2024/05/14/mongodb-installation/", "published_at": "2024-05-14T07:55:11+00:00" }, { "id": "01a0c583-01cd-70f2-8054-c481a77e3f79", "title": "Secure PostgreSQL: Database, Patroni, Etcd and Pgbackrest", "url": "https://dincosman.com/2024/04/29/secure-postgresql-patroni/", "published_at": "2024-04-29T20:07:00+00:00" }, { "id": "01a0c583-01cd-70f2-8054-c481a7d19017", "title": "“spatial_vector_acceleration” parameter  improves Oracle spatial vector query performance", "url": "https://dincosman.com/2024/04/27/spatial-operations/", "published_at": "2024-04-27T00:00:00+00:00" }, { "id": "01a0c583-01cd-70f2-8054-c481a881c847", "title": "How to Upgrade PostgreSQL, PostGIS and Patroni in Offline Environment", "url": "https://dincosman.com/2024/04/20/upgrade-postgresql-patroni-offline/", "published_at": "2024-04-20T22:37:00+00:00" }, { "id": "01a0c591-03e0-70a7-b4c2-47f9d7b31f83", "title": "Oracle Database Patching by Using Ansible", "url": "https://dincosman.com/2024/03/18/database-update-ansible/", "published_at": "2024-03-18T10:19:00+00:00" }, { "id": "01a0c591-03e0-70a7-b4c2-47f9d884acc7", "title": "Oracle Grid Patching by using Ansible", "url": "https://dincosman.com/2024/03/17/grid-update-ansible/", "published_at": "2024-03-17T13:19:00+00:00" }, { "id": "01a0c591-03e0-70a7-b4c2-47f9d8f49ed0", "title": "TOAD and sqlplus have Different Execution Plans: Bind variable peeking", "url": "https://dincosman.com/2023/12/10/no-bind-peeking-in-toad/", "published_at": "2023-12-10T21:02:00+00:00" }, { "id": "01a0c591-03e0-70a7-b4c2-47f9d9876705", "title": "Creating a Conditional Oracle Index Equivalent to a Partial Index in PostgreSQL", "url": "https://dincosman.com/2023/11/17/filtered-index-in-oracle/", "published_at": "2023-11-17T13:37:00+00:00" }, { "id": "01a0c591-03e0-70a7-b4c2-47f9d9d57f7d", "title": "Column statistics – histogram negatively affected query performance", "url": "https://dincosman.com/2023/11/17/histogram-misleads/", "published_at": "2023-11-17T13:30:00+00:00" }, { "id": "01a0c591-03e0-70a7-b4c2-47f9d9e027a8", "title": "Affecting Direct Path Read Decision with Table_Stats Hint", "url": "https://dincosman.com/2023/11/12/using-table-stats-hint/", "published_at": "2023-11-12T12:03:00+00:00" } ] posts Claim your blog
Back to dincosman.com
Blog · corpus.blog/blogs/dincosman.com/posts

dincosman.com

dincosman.com

2026

Troubleshooting RMAN ORA-01403 When Allocating an SBT_TAPE Channeloriginal ↗
19 Sept 2026
Oracle Data Pump Export Fails with ORA-31642original ↗
18 Sept 2026
Here is the wrap-up of POUG2026 (Pint With Oracle User Group).original ↗
6 Sept 2026
rpmdb: DB_RUNRECOVERY Errors When Using dbaascli on Exaccoriginal ↗
18 Aug 2026
ODA Patching Issue: Resolving DCS-10045 and DCS-12013 Errors During DB Home Updateoriginal ↗
15 Aug 2026
RMAN Register database for Catalog fails with ORA-01403original ↗
26 Jul 2026
ORA-48128: opening of a symbolic link is disallowed during Data Pump Export original ↗
26 Jul 2026
Escalating Update Decisions to Oracle Update Advisororiginal ↗
21 May 2026
How to Configure RHP Server for Oracle FPP Local Mode in 19c Oracle RACoriginal ↗
20 May 2026
Fixing “Wallet Key Needed” Errors During Oracle PDB Migration Despite No Encrypted Tablespacesoriginal ↗
18 May 2026
Oracle Database Appliance Disk State FAILED / DiskRemoved but ASM Healthy: Troubleshooting Guideoriginal ↗
16 May 2026
Running Oracle Forms 6i with Oracle 19c: Is It Possible?original ↗
26 Apr 2026
Should You Move to Oracle Database 26ai Now?original ↗
24 Apr 2026
All features in V$OPTION become FALSE after a rollback operationoriginal ↗
18 Apr 2026
Automating Oracle 19.28 Patching with Ansible (RAC + Grid + DB)original ↗
18 Apr 2026
Opatch rollback fails – .patch_storage directory is missingoriginal ↗
4 Apr 2026
ORA-00600: internal error while Gathering Fixed Object Statsoriginal ↗
29 Mar 2026
Unable to Parse the Content of exa_map Error on ExaCC Grid RU Precheckoriginal ↗
31 Jan 2026

2025

Cloning Oracle RAC Database Home to Single Instance and vice versaoriginal ↗
13 Dec 2025
Backing up to a fake tape (SBT) in Oracle RMAN and using sbttest tooloriginal ↗
9 Nov 2025
Ping Checks Life, tnsping Checks Purpose #JoelKallmanDayoriginal ↗
14 Oct 2025
New Exachk Criterion: Hardware Assisted Resilient Data (HARD) Validation During ASM Relocationoriginal ↗
26 Jul 2025
Deploy Oracle Autonomous Database on your Computeroriginal ↗
18 Jun 2025
Oracle Database Patching with AutoUpgrade in Offline Environmentsoriginal ↗
14 Jun 2025
Downloading Oracle Patches with AutoUpgrade on Windows Behind a Proxyoriginal ↗
4 Jun 2025
How Oracle Changes Your SQL: Uncovering Hidden Query Transformationsoriginal ↗
24 May 2025
Avoid Misusing LEFT JOIN in SQL Queriesoriginal ↗
17 May 2025
How SQL Handles No Matching Rows in Aggregationoriginal ↗
17 May 2025
Why NO_DATA_FOUND Behavior Differs in SQL and PL/SQLoriginal ↗
17 May 2025
Scalar Subquery Caching Behavior in a SQL Statementoriginal ↗
17 May 2025
NVL and DECODE: Lazy vs Eager Evaluationoriginal ↗
17 May 2025
Common SQL and PL/SQL Pitfalls: Insights from Real-World Experienceoriginal ↗
17 May 2025
Oracle Hash Partitioning : Benefits and Best Practicesoriginal ↗
9 May 2025
DBMS_METADATA.GET_DDL Does Not Return Hashed Passwords Anymoreoriginal ↗
2 May 2025
Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes)original ↗
26 Apr 2025
Disabling the Oracle Compression Advisororiginal ↗
20 Apr 2025
SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Casesoriginal ↗
10 Apr 2025
Exadata: Configure Management Network Switch with multiple uplinks for redundant connectivityoriginal ↗
7 Apr 2025
Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnectoriginal ↗
13 Mar 2025
Tools and Scripts for Oracle Database Health Checks and Diagnosticsoriginal ↗
23 Feb 2025
Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILUREoriginal ↗
9 Feb 2025
Checking for NOT NULL Values in a BLOB Columnoriginal ↗
10 Jan 2025
Moving Oracle Database Objects to Another Tablespace in 19c (Table, Index, LOB Column)original ↗
3 Jan 2025

2024

Oracle Database 19c APEX Upgrade: 19.2 to 24.1.7original ↗
21 Dec 2024
Oracle Incrementally Updated Backups : Detect and Delete Orphaned (Expired) Datafile Copiesoriginal ↗
15 Dec 2024
CPU-intensive query to simulate CPU load in PostgreSQL databaseoriginal ↗
13 Dec 2024
CPU-intensive query to simulate CPU load in Oracle databaseoriginal ↗
13 Dec 2024
Finding Row Counts for All Tables in Oracle Databaseoriginal ↗
7 Dec 2024
Finding Row Count for All Tables in PostgreSQL Databaseoriginal ↗
7 Dec 2024
Table Statistics vs. SELECT COUNT: What to Choose?original ↗
7 Dec 2024
Installing Oracle Database 23ai on ARM Macs with Sample Schemasoriginal ↗
2 Dec 2024
File System Corruption on Root (/) Partition of Exadata Storage Server – Oracle Linux 7original ↗
1 Dec 2024
How To Change Oracle Central Inventory Locationoriginal ↗
23 Nov 2024
Upgrade Oracle Database Time Zone (DST) version: Key Considerationsoriginal ↗
16 Nov 2024
Column-Level Auditing in Oracle: audit_condition Explainedoriginal ↗
10 Nov 2024
ORA-30554 errors on Function-Based Spatial Indexes after Spatial Bundle Patchoriginal ↗
9 Nov 2024
ORA-00942 Errors from Wnnn Slave Processes working on Behalf of FBDA: Solutions Providedoriginal ↗
2 Nov 2024
Automate Oracle Database Patching with Ansible Playbooks – 19.24original ↗
1 Nov 2024
SYSAUX Tablespace Growing Rapidly due to SCHEDULER$_JOB_OUTPUT Table and ORA-01031 Error in Automatic segment advisor taskoriginal ↗
26 Oct 2024
A 3D data with a 2D SRID may result with ORA-13029 #JoelKallmanDayoriginal ↗
16 Oct 2024
How to send mail from PostgreSQL databaseoriginal ↗
6 Oct 2024
Oracle ACFS File System: Inode Limitations Explainedoriginal ↗
29 Sept 2024
Troubleshooting gc cr/current block lost events and Improving Oracle RAC Network Performanceoriginal ↗
22 Sept 2024
Resolving Enq: TX – Row Lock Contention with Real-life Scenario Analysisoriginal ↗
1 Sept 2024
v$sql INVALIDATION column and Prevent SQL Cursor Invalidationoriginal ↗
25 Aug 2024
How to configure HAProxy with external-check to query PostgreSQL database directlyoriginal ↗
10 Aug 2024
Oracle Database 23ai Fuzzy Matching and Similarity Searchesoriginal ↗
4 Aug 2024
Unified Audit Trail: SQL Text Not Recorded in Syslogoriginal ↗
4 Aug 2024
Fuzzy Matching in PostgreSQL: A Guide to pg_trgm extensionoriginal ↗
2 Aug 2024
How to Remove Orphan Large Objects in PostgreSQLoriginal ↗
27 Jul 2024
Comparing Oracle Users’ Decrypted Passwords with RockYou2024original ↗
26 Jul 2024
pg_amcheck: PostgreSQL corruption detection tooloriginal ↗
29 Jun 2024
Unusable and Parallel indexes on Flashback Data Archive Tables in 19.22original ↗
24 Jun 2024
Transactional DDL in PostgreSQLoriginal ↗
20 Jun 2024
Holistic Patching for Oracle Enterprise Manageroriginal ↗
11 Jun 2024
Create a Function-based Index with NLSSORToriginal ↗
6 Jun 2024
Installing MariaDB and Configuring MaxScale NoSQL Protocol Module on Oracle Linux 8original ↗
2 Jun 2024
MongoDB Alternatives: FerretDB vs Oracle vs MariaDB as NoSQL Solutionsoriginal ↗
19 May 2024
How to Install Oracle Database API for MongoDBoriginal ↗
14 May 2024
Installing FerretDB Using PostgreSQL as the Database Engineoriginal ↗
14 May 2024
MongoDB Community Version Installation on Oracle Linux Serveroriginal ↗
14 May 2024
Secure PostgreSQL: Database, Patroni, Etcd and Pgbackrestoriginal ↗
29 Apr 2024
“spatial_vector_acceleration” parameter  improves Oracle spatial vector query performanceoriginal ↗
27 Apr 2024
How to Upgrade PostgreSQL, PostGIS and Patroni in Offline Environmentoriginal ↗
20 Apr 2024
Oracle Database Patching by Using Ansibleoriginal ↗
18 Mar 2024
Oracle Grid Patching by using Ansibleoriginal ↗
17 Mar 2024

2023

TOAD and sqlplus have Different Execution Plans: Bind variable peekingoriginal ↗
10 Dec 2023
Creating a Conditional Oracle Index Equivalent to a Partial Index in PostgreSQLoriginal ↗
17 Nov 2023
Column statistics – histogram negatively affected query performanceoriginal ↗
17 Nov 2023
Affecting Direct Path Read Decision with Table_Stats Hintoriginal ↗
12 Nov 2023