16.4 Reset the Schema User Password

The schema password expires every 180 days from the repository creation date or from the last password reset date. When you try to connect to such an existing repository the Data Transforms instance provisioning fails. You need to reset the password in the Autonomous Database as well the local wallet.

To reset the schema user password:

1. Login to the Autonomous Database that was used for creating the ODI repository.
2. Run the following command to reset the password for the user:
   alter user username identified by newpassword
3. Connect to the compute instance that is running Oracle Data Transforms.
4. Navigate to the Data Transforms desktop and double click the updatepassword.desktop shortcut icon. In the terminal window that appears, enter the new password.
   This updates the password in the local wallet and restarts the jetty server.

   Note:

   Skip steps 3 and 4 if the instance that you want to connect to is no longer available and you are creating a new instance using the existing repository.