To Change Schemas password & Change Site Name

sqlplus apps/apps
    set pages 0
    set lines 80
    spool schema_pwd.ksh
select 'FNDCPASS apps/<appspwd> 0 Y system/<systempwd> ORACLE ' ||
           replace(ORACLE_USERNAME,'$','\$') || ' ' || oracle_username
"CMD"
      from APPLSYS.FND_ORACLE_USERID
    where  READ_ONLY_FLAG = 'A'
      and  ORACLE_USERNAME in (select USERNAME from SYS.DBA_USERS)
/
    spool off
    exit
***********************************************************
Change Site Name:
a).To find the SiteName:
select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTION_VALUES V
WHERE V.PROFILE_OPTION_ID = (SELECT O.PROFILE_OPTION_ID FROM
FND_PROFILE_OPTIONS_VL O WHERE O.PROFILE_OPTION_ID=V.PROFILE_OPTION_ID
AND V.APPLICATION_ID=O.APPLICATION_ID AND
O.PROFILE_OPTION_NAME='SITENAME' )

b).To Update the SiteName:

UPDATE FND_PROFILE_OPTION_VALUES V
set V.PROFILE_OPTION_VALUE='SUPT - Support Instance - Cloned from
&backup_date Production Backup'
WHERE V.PROFILE_OPTION_ID = (SELECT O.PROFILE_OPTION_ID FROM
FND_PROFILE_OPTIONS_VL O WHERE O.PROFILE_OPTION_ID=V.PROFILE_OPTION_ID
AND V.APPLICATION_ID=O.APPLICATION_ID AND
O.PROFILE_OPTION_NAME='SITENAME' )
/
commit;
/
********************************************************************