DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, January 8, 2016

APEX LOGIN ERROR

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.

No comments: