Posts

Showing posts from March, 2016

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.

FNDCPASS – Change SYSADMIN and APPS Passwords in Oracle E-Business Suite (Complete Oracle Apps DBA Guide)

Image
FNDCPASS – Change SYSADMIN and APPS Passwords in Oracle E-Business Suite (Complete Oracle Apps DBA Guide) 📅 Last Updated: August 2026 This guide has been completely updated for Oracle E-Business Suite R12.1 and R12.2 running on Oracle Database 11g, 12c, 19c, 21c, and Oracle Database 23ai. It covers the legacy FNDCPASS utility, Oracle's recommended AFPASSWD utility, APPS/APPLSYS password synchronization, SYSADMIN password management, AutoConfig, WebLogic considerations, security best practices, and production troubleshooting. Managing passwords securely is one of the most important responsibilities of an Oracle E-Business Suite (EBS) Applications DBA. Password changes are required during system hardening, security audits, user administration, cloning activities, password expiration, and compliance with organizational security policies. Oracle E-Business Suite provides the FNDCPASS utility for changing passwords of application users, the APPS/APPLSYS account...

ORA-00845: MEMORY_TARGET Not Supported on This System – Complete Oracle DBA Solution Guide

Image
ORA-00845: MEMORY_TARGET Not Supported on This System – Complete Oracle DBA Guide 📅 Last Updated: August 2026 This guide has been completely updated for Oracle Database 11g, 12c, 18c, 19c, 21c, and Oracle Database 23ai running on Oracle Linux, Red Hat Enterprise Linux (RHEL), CentOS, Rocky Linux, AlmaLinux, and other supported Linux distributions. It explains Oracle Automatic Memory Management (AMM), Linux shared memory ( /dev/shm ), MEMORY_TARGET configuration, root causes of ORA-00845, and production-ready troubleshooting techniques. One of the most common Oracle startup errors encountered after installing Oracle Database or changing memory parameters is: ORA-00845: MEMORY_TARGET not supported on this system This error usually appears when starting the database after enabling Automatic Memory Management (AMM) by configuring the MEMORY_TARGET or MEMORY_MAX_TARGET initialization parameters. Although the error appears to indicate an Oracle configuration p...