Re: TNS alias synonym entry
Date: Wed, 27 May 2020 10:27:52 +0100
Message-ID: <7533e496-4203-30db-c1af-2b1f25f48aec_at_dunbar-it.co.uk>
On 27/05/2020 00:26, Mladen Gogala wrote:
> Yes, it is possible to alias a TNS connection name. It's done like this:
>
> ...
>
> *As you can see, both TNS entries work as advertised. I'm not quite sure
> what are you trying to do with "MONIT" entries?*
>
I think the OP has a couple of servers and wants to set up a local tnsnames.ora on each pointing a tnsnames alias at an LDAP "alias". It seems that the two servers both have a database DB01 and DB02 defined in LDAP. The OP wants to set up a new alias, pointing at either DB01 or DB02 depending on which server is logged in to, but using the same alias -- so MONIT on server01 points at DB01, while MONIT on server02 points at DB02, but using the LDAP configuration as opposed to hard coding the full details in tnsnames.ora.
HTH
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 27 2020 - 11:27:52 CEST