Update the Administrator Password for Oracle Autonomous Data Warehouse

Update the ADMIN schema password for the Oracle Autonomous Data Warehouse that is provisioned in your tenancy if the password for that ADMIN schema has changed.

Prior to updating the ADMIN schema password in your Oracle Fusion Analytics Warehouse instance, ensure that you have updated the administrator password in the Oracle Autonomous Data Warehouse instance associated with your Oracle Fusion Analytics Warehouse instance. Both the passwords must be the same. See Unlock or Change the ADMIN Database User Password.

Note

You need to be either an Oracle Cloud Infrastructure administrator or an administrator user with the necessary privileges to sign in and reset the password for the ADMIN schema.

LiveLabs Sprint

Sign in to the Oracle Cloud Infrastructure Console.
In Oracle Cloud Infrastructure Console, click the Navigation menu icon in the top left corner.
Click Analytics & AI. Under Analytics, click Fusion Analytics Warehouse.
On the Instances page, click the instance for which you want to update the administrator password for the Oracle Autonomous Data Warehouse that is provisioned in your tenancy.
On the instance details page, click the Name URL under Autonomous Data Warehouse.
On the Autonomous Data Warehouse Details page, from the More actions drop-down list, select Administrator password.
In the Administrator password dialog, enter the new password, confirm, and then click Change.
Navigate to your Oracle Fusion Analytics Warehouse instance details page and click Update password.
In the Update Autonomous Data Warehouse Credentials dialog, in Username, select ADMIN, select the Updated ADMIN password in ADW console check box, enter the same password provided on the Autonomous Data Warehouse Details page, confirm the password, and then click Save Changes.

Oracle Cloud Infrastructure Documentation