Re: Oracle Instance Name and Listener Port information

From: Niall Litchfield <>
Date: Fri, 25 Oct 2013 16:04:54 +0100
Message-ID: <>

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 <> 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
> Sanjay
> --

Niall Litchfield
Oracle DBA

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

Original text of this message