Blog Home
Database
Latest Stories
-
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.
-
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
-
Oracle Cloud Accelerates Expansion
Oracle expects to open an average of one region every 23 days over the next 15 months for a total of 20 additional regions (17 commercial and three government). As planned, 11 of the countries or jurisdictions served by local cloud regions will have two or more regions to facilitate in-country or in-jurisdiction disaster recovery capabilities. Oracle’s Gen 2 Cloud Infrastructure makes this possible through highly-optimized region deployment technologies, which can implement an entire software defined data center and customer-facing cloud services in days.
-
How to Win at the Oracle Licensing Game : Introducing ROCS
Unless you are an expert, it’s very easy to be misled by technology license agreements. Licensing complexity, subtle licensing rule changes or price increases, lack of clarity can all lead to non-compliance.
-
Run the duplicate at a time when there is no concurrent operation. Please note: The above is a su
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
-
Recommended Browsers for Oracle E-Business Suite 11i
Browsers may require specific patches for compatibility with Oracle E-Business Suite. Such patches are backwards compatible with earlier browser releases.
-
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
Essential Modernization Insights
-
Download the Oracle Forms Modernization – White Paper | RENAPS
Legacy Oracle Forms applications pose strategic, operational, and talent risks for large organizations. This white paper presents an enterprise-grade modernization framework that balances automation and control, preserves critical PL/SQL logic, and aligns applications with modern architectures. It provides decision-makers with practical guidance to modernize safely, reduce risk, and ensure long-term scalability and maintainability.
Details -
Case study: Oracle Forms automated migration to React/Javascript (2024)
A leading insurance company, headquartered in Europe, contacted RENAPS in 2024 seeking a modern, automated migration solution to transition from their legacy Oracle Forms and Reports to a scalable, JavaScript-based architecture with a React frontend. Their objective was to modernize their systems to improve operational efficiency, integrate seamlessly with modern platforms, and meet evolving security and scalability requirements.
Details -
Break free from Legacy: A guide for Oracle Forms and Oracle Database users
Migrating Oracle applications to open-source technologies can lower costs and broaden talent pools, but requires disciplined planning, compatibility mapping, and quality gates. This article outlines approaches, trade-offs, and best practices to ensure functional parity, maintain performance, and manage risk when transitioning from proprietary Oracle stacks to open-source alternatives.
Details -
Forms to React/Angular Automated Migration
If you're considering migrating from Oracle Forms to a modern Java/JavaScript architecture, ORMIT™-OpenJava is the ultimate automated solution. It significantly reduces the risks, time, and costs traditionally associated with migrations by leveraging advanced automation and a phased implementation strategy. What sets ORMIT™-OpenJava apart is its ability to retain the familiar trigger-based programming approach of Oracle Forms, ensuring a seamless and intuitive transition for your development team while modernizing your application for today's technological demands.
Details