Posts

Showing posts from March, 2016

Oracle Database Error Solutions & DBA Knowledge Base

Practical, step-by-step Oracle Database troubleshooting and administration resources for DBAs, developers, Oracle E-Business Suite administrators, and IT professionals.

Explore practical guidance covering Oracle Database errors, RMAN backup and recovery, Data Guard, ASM, RAC, performance tuning, installation, patching, cloning, Oracle Linux administration, and Oracle E-Business Suite.

Our troubleshooting guides explain common causes, diagnostic steps, SQL queries, configuration checks, and recommended solutions to help database professionals understand problems and resolve them systematically.

Start with the Oracle Error Codes Guide or explore the main DBA topic areas to find detailed technical articles and practical administration resources.

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...