Unlock Apex Admin User

select user_id from APEX_050000.WWV_FLOW_FND_USER where user_name = 'ADMIN' order by last_update_date desc;

update APEX_050000.WWV_FLOW_FND_USER
set web_password = 'pass'
where user_name = 'ADMIN'
and user_id = 1670116652066977;
commit;

alter session set current_schema = apex_050000;

begin
wwv_flow_security.g_security_group_id := 10;
wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');
commit;
end;

OR

sqlplus / as sysdba @apxchpwd.sql

Default Profile - Unlimited Password

SELECT profile FROM dba_users WHERE username='APEX_PUBLIC_USER';

SELECT resource_name,limit FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Restart Failed Adpatch Session

Yesterday i had a problem when my ssh session failed during adpatch session.

How to restart failed adpatch session:

01. Source the env file as applmgr user and run adctrl

02. Select the following options

Opt 4: Tell manager that a worker has failed its job (specify all workers)
Opt 2: Tell worker to restart a failed job (specify all workers)

04. Restart the AD utility (adpatch) that was running when the machine crashed

Glassfish JAVA Memory Settings

To chnage Java Heap Memory in Glassfish4:

/opt/glassfish/glassfish4/glassfish/domains/domain1/config/domain.xml

change <jvm-options>-Xmx512m</jvm-options> to <jvm-options>-Xmx1024m</jvm-options> or more

Restart domain:
asadmin stop-domain
asadmin start-domain