Database Networking (MOSC)

MOSC Banner

tnsnames.ora - many names for the same thing

edited Apr 4, 2012 1:06AM in Database Networking (MOSC) 6 commentsAnswered ✓
Greetings All;
Is it possible to add "aliases" into tnsnames.ora such that multiple names can share the same definition?

We use a combination of application code and wallets to access a number of databases (no; we never do anything the Easy Way).
As a result, we have several Wallets pointing to the same instance, but connecting under different sets of credentials for different, fairly high-powered tasks.

What I'm looking for is a way to "alias" an existing Descripton, just under a different name, as in
florence-test =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = magic.round.abo.ut)(PORT = 1234))
    (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mchenry) )

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