Bangla fonts in oracle 12c, 11g

1.
Registry.dat

default.fontMap.appFontnames=..,SutonnyMJ
default.fontMap.javaFontnames=..,SutonnyMJ

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\WLS_FORMS\tmp\_WL_user\formsapp_12.2.1\wblalg\config\oracle\forms\registry
D:\Oracle\Middleware\Oracle_Home\forms\templates\config


2.
uifont.ali
Comment out all all & save ANSI format

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\ReportsToolsComponent\reptools1\tools\COMMON
copy uifont.ali to paste
D:\Oracle\Middleware\Oracle_Home\tools\common

3.
[ PDF:Subset ]

"SutonnyMJ"="SutonnyMJ.ttf"

D:\Oracle\Middleware\Oracle_Home\reports\templates

4.
rwserver.conf

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration

AMERICAN_AMERICA.AL32UTF8

5.
reports.bat

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\reports\bin


set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

set REPORTS_ENHANCED_FONTHANDLING=YES

set REPORTS_ENHANCED_SUBSET=YES

6.
Restart
set bagnla font in oracle report in SutonnyMJ in report field

Instance change Oracle APEX 5 ADMIN Password

Approach I
Login SYS user as SYSDBA to the database
Run @apxchpwd.sql
Follow the instructions and update or reset the password for ADMIN user.



Approach II
Login SYS user as SYSDBA to the database.
Execute following command, to get user_id of the ADMIN user.

select user_id
from apex_050000.wwv_flow_fnd_user
where lower(user_name) = 'admin'
order by last_update_date desc;
-- use the appropriate user of the APEX, in my case it is APEX_050000.

-- to format user_id value.
column user_id format 99999999999999999



3. Run the following command to reset the password.

update apex_050000.www_flow_fnd_user
set web_password = '#YOUR_NEW_PASSWORD#'
where lower(user_name) = 'admin'
and user_id = '#USER_ID_FROM_PREVIOUS_QUERY#';

commit;



4. If user got locked.


begin
  apex_050000.wwv_flow_security.g_security_group_id := 10;
  apex_050000.wwv_flow_fnd_user_api.unlock_account('ADMIN');
  commit;
end;
/