Re: sys_context to get connection string?
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sun, 11 Jun 2017 14:51:40 -0500
Message-Id: <72F6F362-9BE8-4CA8-8C0C-C672707F6000_at_gmail.com>
>
> Andrew, I am usually advising users to stop using TNSNAMES.ORA whenever they can. EZCONNECT method is ideal and is based on DNS. The format is very simple: HOSTNAME:PORT/SERVICE. I spent large part of my life fixing tnsnames.ora files needlessly. Another option is using active directory. However, Winduhs admins are frequently less than cooperative, so be prepared to explain why do you need this. I have fought that type of battle several times and have usually won.
> Regards
>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
Date: Sun, 11 Jun 2017 14:51:40 -0500
Message-Id: <72F6F362-9BE8-4CA8-8C0C-C672707F6000_at_gmail.com>
I am not fond of ezconnect at all. The strings get embedded all over the place and failover to a standby or dr site can require changes in far too many undocumented locations. Tnsnames gives you a single place to make changes. If properly done, tns is the way to go as you can change a single file and push to everyplace that is supposed to have it.
Sent from my iPhone
> On Jun 11, 2017, at 2:33 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>
>> On 06/09/2017 04:09 PM, Andrew Kerber wrote: >> We are getting ready to switch to new hardware, and I want to make sure I know how all the users are connecting (whether tns, ezconnect, etc) so I can figure out at a minimum what tns changes are being used. My nightmare, some smart guy had a tns string going to a test database, and rather than changing the tns name in his code he changed his tns entry to point to prod when the time came, without changing the name. Its easy to miss that sort of thing
>
> Andrew, I am usually advising users to stop using TNSNAMES.ORA whenever they can. EZCONNECT method is ideal and is based on DNS. The format is very simple: HOSTNAME:PORT/SERVICE. I spent large part of my life fixing tnsnames.ora files needlessly. Another option is using active directory. However, Winduhs admins are frequently less than cooperative, so be prepared to explain why do you need this. I have fought that type of battle several times and have usually won.
> Regards
>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jun 11 2017 - 21:51:40 CEST