Database Administration (MOSC)

MOSC Banner

Identifying active database links

edited Nov 1, 2013 6:12AM in Database Administration (MOSC) 2 commentsAnswered
Hi All, we have over 500 DBs in our company and they are from 9.2 to 11.2. I've been asked to identify the database links that are NOT functional anymore and are NOT PUBLIC DB links. I'm able to validate the DB links that are PUBLIC but for private DB links I need to provide passwords which is impossible to provide because we don't keep track of personal passwords. People have left the organization as well and their ids are still there.

I've to run the query like   

SELECT USER FROM DUAL@NAME_OF_PVIVATE_DB_LINK  to prove if the DB Link is working or not.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center