How to Reset Your Autonomous Database Administrator Password in OCI

Maintaining strong security practices is paramount for any database, and your Oracle Autonomous Database (ADB) in Oracle Cloud Infrastructure (OCI) is no exception. While ADB handles much of the security for you, managing your ADMIN user password remains a key responsibility.

Whether you've forgotten it, or it's time for a routine security update, resetting the Administrator password in OCI for your Autonomous Database is a quick and straightforward process. This guide will walk you through it step-by-step.

Why Reset Your ADB ADMIN Password?

  • Security Best Practices: Regularly changing passwords enhances your database's security posture.
  • Lost or Forgotten Password: The most common reason – if you can't remember it, a reset is your solution.
  • Compliance Requirements: Many organizations have policies mandating periodic password changes.
  • Personnel Changes: When team members leave, it's good practice to reset critical passwords.

Prerequisites

Before you begin, ensure you have:

  • An Oracle Cloud Infrastructure (OCI) account with the necessary permissions to manage Autonomous Databases.
  • The Display Name of the Autonomous Database instance for which you want to reset the password.

Step-by-Step Guide: Resetting Your ADMIN Password

Follow these simple steps directly in the OCI Console:

Step 1: Log In to the OCI Console

Open your web browser and navigate to the Oracle Cloud Infrastructure (OCI) Console login page. Enter your Cloud Account Name, Username, and Password to log in.

Step 2: Navigate to Your Autonomous Database Details

Once logged in, use the Navigation Menu to find your database:

  1. Click the Navigation Menu icon (☰) in the top-left corner.
  2. Go to Oracle Database.
  3. Select Autonomous Database.
  4. On the Autonomous Databases page, choose the correct Compartment where your database resides from the dropdown menu on the left.
  5. Click on the Display Name of the specific Autonomous Database instance you wish to manage. This will take you to its detailed information page.

Step 3: Access the "Administrator Password" Option

On the Autonomous Database Details page:

  1. Locate the "More Actions" button near the top of the page.
  2. Click on "More Actions".
  3. From the dropdown menu that appears, select "Administrator Password".

This option specifically refers to resetting the Administrator Password for your database, which controls the ADMIN user account.




Step 4: Enter and Confirm the New Password

A "Reset Administrator Password" dialog box will pop up:

  1. In the "New Password" field, enter your desired new password for the ADMIN user.
  2. In the "Confirm Password" field, re-enter the exact same password to confirm it.

Password Requirements: Your new password must adhere to Oracle's strong password complexity rules. It must be between 12 and 30 characters long and include at least:

    • One uppercase letter
    • One lowercase letter
    • One numeric character
    • One special character (excluding double quotes " , dollar sign $, or the whitespace character).


Step 5: Confirm the Password Reset

  • After entering and confirming your new password, click the "Change" button at the bottom .

Important Considerations After Resetting:

  • Update All Connections: Any applications, tools (like SQL Developer Desktop, SQLcl, Python scripts), or users connecting to your Autonomous Database using the ADMIN credentials will need to be updated with the new password immediately. Failure to do so will result in connection errors.
  • Security: Always use a strong, unique password that is not reused for other services. Consider using a password manager.
  • Availability: The password reset operation is non-disruptive; your database remains available during the process.



Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment