Re: sys_context to get connection string?

On 06/11/2017 05:57 PM, Andrew Kerber wrote:
> And even assuming they use dns, it only 'centralizes' the host name.

Not necessarily. There is DEFAULT_SERVICE parameter described here: https://docs.oracle.com/database/121/NETRF/listener.htm#NETRF311

It defines default service for the listener. If the listener is on port 1521 and the service being requested is the default one, host name will suffice.

> I prefer to centralize the database connection definitions. With a
> single tns, i can simply tell users that if they dont use the
> centralized tnsnames.ora file I will decline they are entirely on
> their own in defining their connections from the desktop.

De gustibus non est disputandum. However, my bosses never liked me telling the users that they are completely on their own. That precisely was the problem resolved by EZCONNECT.

>
> On another subject, has anyone else noticed that dgmgrl can be
> inconsistent as to whether it is using the tnsnames.ora file from the
> database home or the asm home? It might just be with the ODA
> (unlikely) but working with one recently I found occasions when it
> used the db home tnsnames.ora and other occasions where it uses the
> asm home tnsnames.ora.
>

Yes, I have noticed that. And resolved by using srvctl setenv command to set TNS_ADMIN for the database. The database needs to be restarted for the setting to take effect. The next time DB starts, the proper TNS_ADMIN is added to the environment.
Regards

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l