Posts

Showing posts from October, 2018

Oracle Database Error Solutions & DBA Knowledge Base

Welcome to Oracle Database Error Solutions, a professional technical knowledge base dedicated to helping Oracle Database Administrators, Oracle E-Business Suite administrators, developers, and IT professionals troubleshoot Oracle Database and Oracle Linux issues with confidence.

This website provides practical, real-world troubleshooting guides based on hands-on Oracle administration experience. You'll find detailed solutions for Oracle Database errors, RMAN backup and recovery, Data Guard, ASM, RAC, Oracle Linux administration, Oracle E-Business Suite (EBS), cloning, performance tuning, patching, installation, and day-to-day DBA tasks.

Whether you're resolving ORA-27101, ORA-28040, ORA-01555, ORA-12154, ORA-01017, or other Oracle errors, our step-by-step articles are designed to save you time and help you solve problems efficiently.

Unable to start HTTP server, error while loading shared libraries: libdb.so.2

Image
Applies to: Oracle Enterprise Linux – Version: 5.8 Oracle EBS R12.1.3 Description: After cloning EBS R12 successfully, when I am going to start the services, find that the HTTP_Server is down. I have tried to restart the HTTP service, but could not start. All services of Oracle EBS going to startup normal except HTTP server: Solution: Find the following error in HTTP server log file: There is missing some libraries. Shutdown all EBS services and create a link for missing library as below: Find that the library libdb.so.2 not exists. So create the link as below: Now start all services and retest the issue: HTTP Server is started normal, Oracle EBS is up and running now. 👉 Check our complete guide: Oracle Error Codes Guide Author Box About the Author Rana Abdul Wahid  is an experienced Oracle Database Administrator with expertise in Oracle Database Administration, Oracle Data Guard, RMAN Backup & Recovery, Oracle RAC, Oracle E-Busines...

How to Reset or Change the SYS User Password in Oracle Database (Complete DBA Guide)

Image
How to Reset or Change the SYS User Password in Oracle Database (Complete DBA Guide) 📅 Last Updated: August 2026 This guide has been fully updated for Oracle Database 11g, 12c, 18c, 19c, 21c, and Oracle Database 23ai. It explains how to safely reset or change the SYS user password using Oracle-supported methods, understand password file authentication, verify Oracle security settings, and troubleshoot common SYSDBA authentication issues in production environments. The SYS account is the most privileged administrative account in Oracle Database. It owns the Oracle data dictionary and is responsible for managing internal database objects, startup and shutdown operations, recovery, upgrades, and many critical administrative tasks. Because of its elevated privileges, changing the SYS password requires careful planning. Oracle provides multiple supported methods depending on the database configuration, authentication mode, and whether the database uses a password fi...

How to Change the Default Port of Oracle Database Listener (Complete Oracle Net Services Guide)

Image
How to Change the Default Port of Oracle Database Listener (Complete Oracle Net Services Guide) 📅 Last Updated: August 2026 This guide has been completely updated for Oracle Database 11g, 12c, 18c, 19c, 21c, and Oracle Database 23ai. It explains how to safely change the default Oracle Listener port, update Oracle Net Services configuration files, verify database registration, troubleshoot connectivity issues, and validate client connections using Oracle Database administration best practices. The Oracle Listener is one of the most critical components of Oracle Net Services. Every remote client connection to an Oracle Database passes through the Listener before a database session is established. By default, Oracle configures the Listener to listen on TCP port 1521 , which has become the industry-standard Oracle Database port. Although port 1521 works well for most installations, database administrators may need to change it due to security policies, firewall requi...

ORA-39213: Metadata Processing is not Available – Complete Oracle Data Pump Troubleshooting Guide

Image
ORA-39213: Metadata Processing is not Available – Complete Oracle Data Pump Troubleshooting Guide 📅 Last Updated: August 2026 This guide has been completely updated for Oracle Database 11g, 12c, 18c, 19c, 21c, and Oracle Database 23ai. It explains how to diagnose and resolve ORA-39213: Metadata Processing is not Available , understand the Oracle Data Pump Metadata API, reload XSL stylesheets, validate database components, and restore Data Pump functionality using Oracle Database administration best practices. Oracle Data Pump is the recommended utility for high-speed logical backup, migration, upgrade, and data movement in Oracle Database environments. Database administrators rely on EXPDP and IMPDP to export and import schemas, tablespaces, databases, transportable tablespaces, and metadata. One of the less common but critical Data Pump errors is ORA-39213: Metadata Processing is not Available . This error indicates that Oracle Data Pump cannot access the Meta...

APPS Login Failed with Error HTTP 404 in Oracle E-Business Suite R12 (Complete Troubleshooting Guide)

Image
APPS Login Failed with Error HTTP 404 in Oracle E-Business Suite R12 (Complete Troubleshooting Guide) 📅 Last Updated: August 2026 This guide has been completely updated for Oracle E-Business Suite Release 12.1 and 12.2. It explains how to troubleshoot the HTTP 404 error during Oracle EBS login , understand the underlying Oracle Application Server architecture, identify incorrect file ownership issues, review application logs, and restore application availability using Oracle Applications DBA best practices. Oracle E-Business Suite (EBS) is one of the world's most widely deployed enterprise ERP systems. Thousands of organizations rely on Oracle EBS every day to manage Finance, Supply Chain, Procurement, Human Resources, Manufacturing, Projects, and numerous other mission-critical business processes. One of the more frustrating issues Oracle Applications DBAs encounter is when users successfully reach the Oracle EBS login page, enter valid credentials, and then...