- RENAPS at Oracle AI World 2026: our week in Las Vegas Invited by Oracle GoldenGate product management, our two Oracle ACE Pros spent the week at Oracle AI World 2026 in Las Vegas: an unplanned moment on stage, hands-on labs, a hackathon, the big announcements and a lot of great people.
- RENAPS at TOUG: GoldenGate beyond database replication On September 15, 2026, Prashant Dixit, Oracle ACE Pro at RENAPS, presents "GoldenGate Beyond Database Replication: Moving Oracle Data into Microsoft Fabric Lakehouse" at the Toronto Oracle Users Group.
- Making SYS Password Expiration Work Properly in Oracle – And Why You Should Actually Rotate It Making SYS Password Expiration Work Properly in Oracle – And Why You Should Actually Rotate It
- Two Years at RENAPS: What a DBA Team Actually Looks Like At RENAPS, our DBA team operates with deliberate overlap and shared accountability, ensuring no production incident is faced in isolation. Calm, evidence-based decision-making, rigorous peer validation, and institutional knowledge continuity transform individual expertise into collective resilience.
- Oracle Database Appliance (ODA) Patching Pitfalls to Avoid Oracle Database Appliance (ODA) patch planning is more complex than typical server updates, touching hardware, firmware, Grid Infrastructure, OS, and database layers. Without disciplined methodology, ad-hoc patching risks downtime, version mismatches, and compliance gaps. RENAPS outlines how structured ODA patching protects stability, security, and lifecycle compliance.
- Meet the RENAPS Database & Infrastructure Architects: Modernization, Compliance & Performance Meet the RENAPS Database Architects who bring deep Oracle expertise in multitenant, GoldenGate, performance optimization, and low-risk modernization. With real-world experience across complex environments, they help organizations reduce risk, streamline migrations, and improve long-term operational reliability. Learn how their approach accelerates success with Oracle databases.
- Exadata Exascale Now Available on Oracle Cloud Infrastructure (OCI) In the rapidly evolving landscape of cloud computing, Oracle has consistently demonstrated its commitment to innovation and excellence. The recent announcement of Exadata Exascale marks a significant milestone in this journey. Exadata Exascale represents the pinnacle of intelligent data architecture for the cloud, promising to revolutionize how organizations of all sizes handle their data workloads.
- Oracle's AI Transformation: Empowering Enterprises with Advanced Intelligence Oracle has recently made remarkable advancements in incorporating artificial intelligence (AI) into its product suite, reinforcing its status as a frontrunner in enterprise AI solutions. Here’s a look at some of the transformative developments enhancing business operations and innovation.
- How to leverage AI and Machine Learning in Oracle Database Management? In today's rapidly evolving technological landscape, artificial intelligence (AI) and machine learning (ML) are at the forefront of transforming various industries. One area experiencing significant change is database management.
- Oracle Database Upgrade From 11.2.0.4 To 12.2.0.1 Failed With ORA-06512: At Line 37 ORA-06512 Applies to: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later. Information in this document applies to any platform. Before upgrade, one or more ACL principals are granted with privilege 'resolve' but the ACL has port range defined.
- The Power of Oracle 19c Multitenant In the ever-evolving landscape of database management, Oracle 19c Multitenant architecture emerges as a game-changer. It's more than just an upgrade; it's a strategic shift towards a more efficient, secure, and scalable database infrastructure. For technical experts and organizations, this move to Oracle 19c Multitenant offers a plethora of benefits and advantages that can significantly impact the way databases are managed and utilized.
- ORMIT™-DB: Automated Oracle Database upgrade tool ORMIT™ DB - Upgrade from any Oracle Database to the latest Oracle Database version
- Oracle Licensing Script: Only the first step to Oracle License Compliance Oracle Licensing Scripts are an important first step to compliance. Download the Oracle Licensing Scripts for free.
- Bug 20936731: ALTER SYSTEM ENABLE/DISABLE RESTRICTED SESSION Breaks Notifications (ORA-1033) The fix for 20936731 is first included in • 12.2.0.1 (Base Release) • 12.1.0.2.170117 (Jan 2017) Database Patch Set Update (DB PSU) • 12.1.0.2.170117 (Jan 2017) Database Proactive Bundle Patch • 12.1.0.2.160531 (May 2016) Bundle Patch for Windows Platforms
- Bug 16053545 - RMAN cloning from active database fails when overlapped with database backup job The fix for 16053545 is first included in • 12.2.0.1 (Base Release) • 12.1.0.2 (Server Patch Set)
- Bug 13011409 - ORA-600 [kglLock-bad-byd] can occur The fix for 13011409 is first included in: • 12.1.0.1 (Base Release) • 11.2.0.4 (Server Patch Set) • 11.2.0.3.5 Database Patch Set Update • 11.2.0.3 Bundle Patch 12 for Exadata Database • 11.2.0.3 Patch 10 on Windows Platforms
- How to Diagnose High CPU Utilization of ORACLE.EXE in Windows Environment On windows Oracle processes are represented as "Threads" of the Oracle process so if one session is using a lot of CPU this is simply displayed as "Oracle using CPU".
- Troubleshooting ORA-27300 ORA-27301 ORA-27302 Errors The errors are usually caused by OS system call error or OS configuration issue.
- SYS.DBMS_SCHEDULER .CREATE_JOB Encounters ORA-00904: ORA-06512: at "SYS.DBMS_ISCHED" ORA-06512: at " Error when attempting to create a job via DBMS_SCHEDULER
- Simple Example of Sending Attachments Using UTL_SMTP How to send an E-Mail with attachment using the PL/SQL package UTL_SMTP.
- RMAN Duplicate to ASM Failing With ORA-19870 ORA-19504 ORA-15012 ORA-17502 ORA-15080 RMAN duplicate to ASM is failing with these errors: ORA-15012, ORA-15080, ORA-17502, ORA-19504, ORA-19870, ORA-27041, ORA-27091.
- ORA-31011 XML parsing failed Having XMLTYPE as a return type of a function is a problem when the function is called by a web service.
- ORA-29283: Invalid File Operation The error can be caused by one of the following four items: Issue 1 - The directory referenced is incorrect. Issue 2 - Privileges were not granted to the username to access the directory. Issue 3 - Attempting to read from a file with no data. Issue 4 - The input file has a linesize over 1000 bytes and that was not indicated in UTL_FILE.FOPEN().
- ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS .GATHER_STATS_JOB When attempting to run GATHER_STATS_JOB the following errors occur: ORA-20011. Usually accompanied with varying other errors such as KUP-11024
- ORA-00600: [KSLGES_3] When Mounting Database Received following errors in alert log when trying to mount database: ORA-00600: internal error code
- Oracle Database - Enterprise Edition - Known Issues And Bugs Using the Scheduler This guide is an attempt to list some tips and tricks, relevant notes, known bugs and issues related to Scheduler usage and try to provide the first steps for analyzing, and listing the relevant notes dependent on the database version and specific scheduler part.
- Is Forms/Reports 6i Certified to Work Against Oracle Server 10g Rel 1, Rel 2 or 11gRel 1, Rel 2? Forms / Reports development will no longer provide error correction service for Forms / Reports 6i (unless an organization has purchased extended maintenance support)
- How to Save Forms in the Database ? Usually when you save the form, it gets saved in the filesystem by default. However, if you want to save it in the database, you will need to do some work in the database.
- Does Oracle Forms Support Oracle RDBMS High Availability and Failover (RAC / TAF)? This article will explain Forms usage with Real Application Clusters (RAC) and Transparent Database Failover.
- DataPump Performance Expdp Is Very Slow 10.2.0.4 to 11.2.0.2 Linux x86-64 running standard edition 11.2.0.2 with RAC reporting slow performance on expdp for object_grants.
- DataPump Import (IMPDP) Fails With Errors ORA-2372 ORA-26093 ORA-2374 During DataPump import you received the following oerrors: ORA-02372: data for row: COLLECTION : 0X'050200'" ORA-26093: input data column size (3) exceeds the maximum input size (1) ORA-02374: conversion error loading table "MJSDEV"."COLLECTION
- Configuring Oracle Advanced Security Option (ASO) with Microsoft Windows Server 2003 Active Director The purpose of this article is to describe how to configure an Oracle database with Advanced Security Option (ASO) for external authentication against Microsoft Windows Server 2003 Active Directory (aka Microsoft Kerberos Key Distribution Centre (KDC)).
- Shared Server: "ORA-12523: TNS:listener could not find instance appropriate for the client" When trying to connect the Oracle RDBMS Instance using Shared Server, the following error message may occur: ERROR: ORA-12523: TNS:listener could not find instance appropriate for the client connection
- Rc-50004: Fatal: Error Occurred Running Adcfgclone.pl DBTier For RDBMS 64 Bit In the context file the setting is: <config_option type="database" oa_var="s_bits">32</config_option>. Should be set to <config_option type="database" oa_var="s_bits">64</config_option>
- Ora-07445 [_nsgblini] After Applying Patch When running an application, the following error was generated in both the alert.log and trace files: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_nsgblini+1158]
- Troubleshooting ORA-1031: Insufficient Privileges While Connecting As SYSDBA This document is intended to supply some commonly used steps for diagnosing error ORA-1031 encountered while connecting as sysdba.
- After Upgrading To 10g, Getting ORA-01788 When Running A Query That Includes The LEVEL Pseudo-column After upgrading to Oracle 10g, started getting an ORA-1788 error for a query that includes the LEVEL pseudo column. This query was running fine on 9i.
- ORA-00338, ORA-00312 Errors Reported In Alert Log Below errors are repeatedly reported in the alert log of one RAC node. Note that the actual issue applies to RAC and non RAC databases.
- How to Load File Content to a BLOB Field and Unload BLOB Content to a File on the OS This note describes steps to Load a Binary file into a BLOB Column of a table, and also describes how to unload contents of a blob column to a file on the filesystem.
- Data Pump export hang / uses excessive memory with many "WITH GRANT OPTION" grants - superceded Large numbers of WITH GRANT OPTION object grants can cause Data Pump to run slowly and run out of memory.
- An Introduction to PKI and SSL In order to understand how the Secure Sockets Layer Protocol (SSL) works, it is necessary to understand the fundamental concepts of Symmetric Encryption and Public Key Infrastructure (PKI). All of these technologies are used in SSL. This article aims to outline these concepts.
- 7X24 Middleware and Database Customer Case Study - Stokes Customer case study: RENAPS provides 24/7 remote DBA services for the Oracle Database and Fusion Middleware of Stokes Stores, 130 stores across Canada.
Your Oracle Stack. MODERNIZED.
