Oracle Application DBA

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

MEMORY_TARGET not supported on this system Applies to:             Oracle Enterprise Linux – Version: 5             Oracle Database 11gR2 Description:             I am going to create a new TEST instance from Production database. Hardware resources on TEST server less than from Production server. After restore the backup when I am going to start the database I got the following error message: SQL> connect / as sysdba Connected to an idle instance. SQL> startup; ORA-00845: MEMORY_TARGET not supported on this system Solution: After some research work I have found the following solution: ·          Check out /dev/shm is properly mounted by using following commands: #df -h or #df -k command ·          Size of /...