Re: Oracle Instance Name and Listener Port information

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 25 Oct 2013 16:04:54 +0100
Message-ID: <CABe10sZHySeBRU3O7FoVF-HCgo++Ko1Zqa9vRW4ouz_tBbK=nw_at_mail.gmail.com>

Sanjay
surely such a client has some form of centralized naming even if its only a shared tns_admin directory?

On Fri, Oct 25, 2013 at 5:32 AM, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> Hi
> Does any one knows as how I can get Instance name and Listener Port
> configured on the database server from Oracle enterprise Manager Repository
> tables. I has 1200 database in one of the new client and want to create the
> tnsentry locally so that I can connect them. going to 100's of server with
> multiple database on multiple port is very time consuming process. As I had
> Grid control setup and so thought that if I can get the tablename which has
> the information then can can create tnsentry using script
>
> TIA
> Sanjay
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


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

Received on Fri Oct 25 2013 - 17:04:54 CEST