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@xxxxxxxxx> wrote:
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?
Am Do., 2. Apr. 2020 um 08:28 Uhr schrieb Sumit Kumar T <
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 ?