Apex角色找回及登录问题求助：改密后无法登录且无重置邮箱

Hey there, let's work through this Apex 4.1 login issue step by step—this is a common gotcha, so we'll get you back in.

First: Rule Out Browser Auto-Fill Interference #

The most likely culprit here is your browser clinging to the old password. Even if you updated it in Apex, auto-fill often overrides manual input without you noticing. Try these steps:

• Delete the saved password for your Apex workspace in your browser's settings. For most browsers, this lives under "Passwords" or "Privacy & Security"—find the entry for your Apex login URL and remove it.
• Manually type your new password when logging in, double-checking that auto-fill isn't populating the field. You can also test in incognito/private browsing mode to bypass saved credentials entirely.

If Browser Fixes Don't Work: Reset via Database #

Apex 4.1 stores user credentials in the Oracle database's Apex metadata schema (usually APEX_040100). If you have access to the database (either directly or via a DBA), you can reset the password directly:

1. Connect to your Oracle database using SQL*Plus, SQL Developer, or another database tool as a user with access to the APEX_040100 schema.
2. Run this PL/SQL block to reset the admin password (replace placeholders with your actual username and desired password):

   BEGIN
       APEX_UTIL.SET_PASSWORD(
           p_user_name => 'ADMIN', -- Replace with your admin username
           p_new_password => 'SecureNewPassword123' -- Set your new password here
       );
       COMMIT;
   END;
   /
   

3. After executing, close all browser windows and try logging in with the new password.

Fixing the Forgotten Password Email #

If you need to use the password reset feature but don't know the linked email, you can query or update it directly in the database:

• Find the current email for your admin user:

  SELECT email_address
  FROM APEX_040100.wwv_flow_fnd_user
  WHERE user_name = 'ADMIN'; -- Replace with your admin username
  

• Update the email to one you have access to:

  UPDATE APEX_040100.wwv_flow_fnd_user
  SET email_address = 'your-accessible-email@example.com'
  WHERE user_name = 'ADMIN';
  COMMIT;
  

Once updated, you can use the "Forgot Password" link on the login page to send a reset request to the new email.

Check for User Locking #

If multiple failed login attempts (from auto-fill using the old password) locked your account, you can unlock it via SQL:

UPDATE APEX_040100.wwv_flow_fnd_user
SET account_locked = 'N', failed_login_attempts = 0
WHERE user_name = 'ADMIN'; -- Replace with your admin username
COMMIT;

Start with the browser auto-fill fix first—it's the quickest and easiest. If that doesn't resolve it, move to the database-level steps.

内容的提问来源于stack exchange，提问作者Andrey Shevchenko