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 APPS passwords

FNDCPASS change SYSADMIN APPS passwords Applies to:             Oracle Enterprise Linux – Version: 5             Oracle EBS R12 Description:             How to change SYSADMIN and APPS passwords Solution:             You can change SYSADMIN and APPS passwords as follow: Change the SYSADMIN password: Login to application manager user and execute the following command [appltest@ebstest] FNDCPASS apps/apps 0 Y system/managerr USER SYSADMIN <new-password> Log filename : L1234567.log Report filename : O1234567.out Change the APPS password: changing the APPLSYS password change the APPS password: Login to application manager user and execute the following command [appltest@ebstest] FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS...

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 Solution Guide The ORA-00845: MEMORY_TARGET not supported on this system error is a common Oracle Database startup issue that occurs when Oracle's Automatic Memory Management (AMM) feature cannot allocate shared memory resources required by the operating system. This error is most frequently encountered on Linux environments during: Oracle Database installation Database startup Memory parameter configuration changes Database cloning and migrations Oracle upgrades Although the error appears straightforward, it is often confusing because the database parameter settings may appear correct while the underlying operating system configuration is preventing Oracle from starting successfully. In this complete Oracle DBA troubleshooting guide, you will learn: What ORA-00845 means Why the error occurs How Automatic Memory Management works How Linux shared memory affects Oracle Step-by-step sol...