Re: Port Numbers

Hi Martin

Is there any x$ view where oracle store listener port number , I know we can check in listener file / lsnrctl status etc but we don't have access to host .. I just have access via remote sqlplus connection. Local_listener parameter is blank for some database , on few we have named listener or full address list .
So wanted to know if oracle store port anywhere in x$ what I can query .

On Fri, Apr 3, 2020, 01:09 Martin Berger <martin.a.berger_at_gmail.com> wrote:

> Sumit,
>
> can you give some examples what you are searching for?
> The most common connection - SQL*NET - is established by the listener. The
> instance doesn't care a lot about it.
>
> What do you want to achieve?
>
> Martin
>
> Am Do., 2. Apr. 2020 um 08:28 Uhr schrieb Sumit Kumar T <
> dba.tyagisumit_at_gmail.com>:
>
>> Hi Experts
>>
>> Is there any view / x$ view which can tell us all the port numbers
>> configured for different database components . Or can we fetch from any OEM
>> management views ?
>>
>> Br
>> Sumit
>>
>

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