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 <new-password> Log filename : L1234567.log Report filename : O1234567.out Run the autoconfig on all the nodes, autoconfig is configuring the Applications environment. Your comments, especially whic

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 /dev/shm should be greater than MEMORY_TARGET or MEMMORY_MAX_TARGET parameter value ·          We see that /dev/shm have assigned 2G memory, and MEMORY_TARGET more than 2G then above ORA-845 will arise. ·          If you have MEMORY_TARGET