31 March 2011

How to change the oracle All APPL_TOP password using FNDCPASS

Hi,
Please execute the below query copy the output. make the shell script then run your server .

select concat('FNDCPASS apps/apps 0 Y system/manager ORACLE ' || replace(ORACLE_USERNAME,'$','\$' ) || ' ',  concat(substr('FNDCPASS apps/apps 0 Y system/manager ORACLE ' || replace(ORACLE_USERNAME,  '$','\$'),46),'_OUR12')) muthu
from APPLSYS.FND_ORACLE_USERID
where READ_ONLY_FLAG = 'A'
and ORACLE_USERNAME in (select USERNAME from DBA_USERS);

No comments: