- 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.
- 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.
- Why Consider RENAPS On-Demand? RENAPS On-Demand offers businesses a solution to today's database management challenges. Partnering with RENAPS ensures continuous learning, strategic focus, resilience, and a competitive edge. The collaboration promises enhanced operational efficiency and technological advancement, allowing companies to realize their full IT potential for growth and innovation.
- ODA Schedules: SSH cleaner job to clean up stale SSH keys Oracle has introduced an additional schedule on the ODA in patch the 19.16 patch bundles. The new schedule, think of it as a job, is called SSH cleaner job to clean up stale SSH keys. Pretty self-explanatory what the schedule does by the name. The new SSH cleaner job schedule is enabled by default and executes every 30 minutes
- On Demand vs. Managed Services IT services have traditionally followed the “managed” operating model in which the provider acts as an “extension of your IT team”. This approach supposes that trusted outside experts will manage all IT (or a defined portion) so that companies can focus on their core business
- 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 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".
- 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
- 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.
- 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
- 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.
Your Oracle Stack. MODERNIZED.
