How To Find Oracle DB Link User Password

It is possible to forget the passwords of the users in the DB Links created for the communication between Oracle databases. These users’ passwords can be identified. You can follow the steps below to find the password of the oracle db link user.

These steps apply to database version 11.2.0.2 and earlier created db links. In later versions, passwordx value cannot be decrypted if it is more than 50 characters.

Follow these steps in the database where the DB link is created.

First, let’s specify db links with passwordx value of 50 characters.

Then, let’s find the encrypted password of this db link.

Let’s find the clear text of the detected password. When you run the following procedure, you will see the clear text of the password in “Password: XXXXXXXXX”.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *