RE: sys_context to get connection string?
Date: Mon, 12 Jun 2017 05:31:36 +0000
Message-ID: <1119_1497245510_593E2746_1119_6784_1_ECDEF0CC6716EC4596FCBC871F48292AB1895367_at_ZRH-S231>
Andrew,
Why don’t you use LDAP servers for the names resolution? It is the real centralized solution. Not only does it save you of trouble with deployment of tnsnames.ora, but any change to a connection string is instantaneously visible to all of the database clients.
If Active Directory is not a viable solution in your organization, you can setup your own Oracle Directory Server (ODS) for this purpose. For me, ODS is one of the key enabler of the agility in database provisioning.
Nenad
Home Page: http://nenadnoveljic.com/blog/ Twitter: _at_NenadNoveljic<https://twitter.com/NenadNoveljic>
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber
Sent: Sonntag, 11. Juni 2017 23:58
To: Norman Dunbar
Cc: Mladen Gogala; ORACLE-L
Subject: Re: sys_context to get connection string?
And even assuming they use dns, it only 'centralizes' the host name. 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. 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.
On Sun, Jun 11, 2017 at 4:31 PM, Norman Dunbar <oracle_at_dunbar-it.co.uk<mailto:oracle_at_dunbar-it.co.uk>> wrote: Does it Malden? I have a funny feeling that the host part of an ezconnect string is permitted to be an IP address. No DNS required. :-(
Cheers,
Norm.
On 11 June 2017 22:23:19 BST, Mladen Gogala <gogala.mladen_at_gmail.com<mailto:gogala.mladen_at_gmail.com>> wrote:
On 06/11/2017 05:22 PM, Andrew Kerber wrote:
You lost me completely. How does ezconnect centralize anything? if anything it decentralizes everything.
EZCONNECT relies on DNS, which is usually centralized.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
</head>
<body>
<p>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of the Vontobel Group and its affiliates for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version.<br/>
</p>
</body>
</html>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 12 2017 - 07:31:36 CEST