Database Administration (MOSC)

MOSC Banner

how to find target host name when using db link

edited Aug 7, 2014 5:02AM in Database Administration (MOSC) 4 commentsAnswered

Hi Team,

We have migrated databases to one server to other server from 11.1 to 11.2.0.4. Also we have lot of dblinks using in old.

Also they have access for dba_db_links.

So customer asking is there any way to find target host name when using db link?

My testing will involve using the application account and actually *use* the dblink to confirm which system is being targeted.

Is there some other command that is available to all users to verify the hostname of the target system (when using dblink) ?



Please provide any view or query to find the target host name when using db link?

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