Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Use connection description from tnsnames.ora

Needs Votes
31
Views
3
Comments

Oracle database connection definitions should support a centralized tnsnames.ora file.

6
6 votes

Needs Votes · Last Updated

Comments

  • Jan Holub
    Jan Holub Rank 2 - Community Beginner

    Great idea! The benefits of centralized TNS alias management are obvious – it significantly simplifies connection configuration to all databases across the organization. With a single shared tnsnames.ora file, it's easy to update access details for all users and applications at once, without the need for individual changes. I strongly recommend giving this idea serious consideration.

  • Vlastimil Kukla
    Vlastimil Kukla Rank 1 - Community Starter

    I definitely second to that.

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    Highly wanted feature - to be able effectively "manage" assignment of Db instance in DV connection via reference of connect descriptor defined in tnsnames.ora (central place for managing connection in our institution) instead of having to "paste" the whole connect string into connection definition. Basically we need same option as we have now when defining Connection Pool object in RPD (where in Data Source Name we refer connect descriptor from tsnames.ora). This is valid for OAS (not sure whether OAC can benefit from this).