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:
Post a Comment