Introduction
Steps to ix apex login error
Posted by Venkateshwaran
ERROR:
I USED CORRECT USERNAME AND PASSWORD BUT STILL I FACED LOGIN ERROR
SOLUTION:
SQL> alter session set current_schema = APEX_040200;
Session altered.
SQL> select user_name, security_group_id from wwv_flow_fnd_user;
USER_NAME
——————————————————————————–
SECURITY_GROUP_ID
—————–
ADMIN
9.3612E+14
SQL> update wwv_flow_fnd_user set security_group_id = 10 where user_name = ‘ADMIN’;
1 row updated.
SQL> select user_name, security_group_id from wwv_flow_fnd_user;
USER_NAME
——————————————————————————–
SECURITY_GROUP_ID
—————–
ADMIN
10
SQL> @apxchpwd.sql
Enter a value below for the password for the Application Express ADMIN user.
Enter a password for the ADMIN user []
Session altered.
…changing password for ADMIN
PL/SQL procedure successfully completed.