Installing multiple oracle homes on the same machine Installing Multiple Oracle Homes on the Same Machine A Guide Installing multiple Oracle Homes on the same machine is a common practice particularly in developme 3 min read 06-10-2024 50
How to test Oracle ODBC Driver Configuration connection? Connecting to Oracle Testing Your ODBC Driver Configuration Connecting to an Oracle database from an application often requires the use of an ODBC Open Database 2 min read 06-10-2024 42
What is significance of ewallet.p12.lck and cwallet.sso.lck files in oracle wallets? Understanding the Locks ewallet p12 lck and cwallet sso lck in Oracle Wallets The Problem Oracle wallets are crucial for securing sensitive data like passwords 2 min read 06-10-2024 37
Cannot drop Oracle flashback data archive Cant Drop Oracle Flashback Data Archive Unlocking the Secrets of Persistent Data Have you ever encountered the frustrating error ORA 38846 Cannot drop flashback 2 min read 06-10-2024 37
BI-Publisher RTF Template: Repeat colums or rows horizontally first before new page Breaking the Mold Repeating Columns and Rows Horizontally First in BI Publisher RTF Templates Problem You re working with a BI Publisher RTF template and need t 2 min read 05-10-2024 42
Oracle SQL find max number before repeating values start Finding the Maximum Number Before Repeating Values in Oracle SQL In this article we ll explore how to identify the maximum number in a dataset before any repeat 2 min read 22-09-2024 49
Visibility of external tables in CROSS APPLY Understanding the Visibility of External Tables in CROSS APPLY When working with SQL Server one may encounter the challenge of understanding how external tables 2 min read 18-09-2024 38
ODI 12c Work Repository: Reusable Mapping Lineage Understanding ODI 12c Work Repository Reusable Mapping Lineage In the world of data integration Oracle Data Integrator ODI 12c offers powerful features that enh 2 min read 16-09-2024 41
Connecting Oracle12c to a spring boot application Connecting Oracle 12c to a Spring Boot Application Connecting an Oracle 12c database to a Spring Boot application can seem daunting but with the right steps and 2 min read 16-09-2024 56
ORA-28040: No matching authentication protocol exception Troubleshooting ORA 28040 No Matching Authentication Protocol in Oracle 12c The dreaded ORA 28040 No matching authentication protocol error can be a frustrating 2 min read 06-09-2024 46
StaleConnectionException: No more data to read from socket Troubleshooting Stale Connection Exception No more data to read from socket in Oracle 12c and Web Sphere 8 5 The dreaded No more data to read from socket error 3 min read 06-09-2024 61
Cannot connect Oracle database by Sqldeveloper(ORA-01017，invalid username/password;logon denied) Troubleshooting ORA 01017 Invalid username password logon denied in Oracle 12c This article will guide you through troubleshooting the common Oracle error ORA 0 3 min read 05-09-2024 52
Status : Failure -Test failed: IO Error: An existing connection was forcibly closed by the remote host Troubleshooting IO Error An existing connection was forcibly closed by the remote host in Oracle SQL Developer Connecting to your Oracle database is a fundament 2 min read 05-09-2024 65
Scheduled Load plan in ODI doesn't trigger automatically and needs manual intervention to run Troubleshooting ODI Scheduled Load Plans Why They Might Not Run Automatically Problem Your ODI scheduled load plan is supposed to run automatically but instead 2 min read 05-09-2024 46
Retrieving Images from Oracle 12C into BIP Report Retrieving Images from Oracle 12c into BIP Reports A Step by Step Guide Displaying images directly in your Oracle Business Intelligence Publisher BIP reports ca 2 min read 31-08-2024 55
How to create a trusted certificate to run https in oracle 12c db Secure Your Oracle 12c Database Creating Trusted Certificates for HTTPS Connections Running an HTTPS API in Oracle 12c requires a secure connection and that mea 2 min read 30-08-2024 43
Converting timestamp to date format in Oracle 12c Converting Timestamp to Date Format in Oracle 12c A Comprehensive Guide Oracle 12c offers powerful tools for manipulating dates and timestamps but converting th 2 min read 28-08-2024 44
Oracle hierarchical query joining 2 tables Navigating Oracle Hierarchical Queries Joining Projects and Tasks for a Clear View This article delves into the complex world of Oracle hierarchical queries foc 3 min read 28-08-2024 36