Reset the OAX_USER Password

You need to reset the password for the OAX_USER before creating a connection to an Autonomous Data Warehouse.

  1. Sign in to Database Actions with the ADMIN user's credentials.
  2. Click DATABASE USERS in the Administration section and edit the OAX_USER account details.
  3. Enter a new password and confirm it.
  4. Click the Web access toggle, then click Apply Changes.
  5. If Database Actions (SQL Developer Web) isn't accessible, use the SQL Developer desktop client to reset the OAX_USER password. Run the following commands, defining a new password in place of NewPassword in SQL Developer desktop client.
    
ALTER USER OAX_USER IDENTIFIED BY NewPassword;
COMMIT;