Re: TNS alias synonym entry

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
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.

I don't do LDAP, so I don't know if it can be done, I don't think so but given my motto is "don't think, find out", I'm not about to start guessing!

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-l
Received on Wed May 27 2020 - 11:27:52 CEST

Original text of this message