how to extract port number in listener.ora and store it in a variable - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

how to extract port number in listener.ora and store it in a variable

dosjedinoobdosjedinoob Posts: 1Member
the content of listener.ora is as follow:

[code]
# listener.ora Network Configuration File: C:app homasproduct11.2.0dbhome_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.

#Default LISTENER.ORA file

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TIMHALL)
(SID_NAME = TIMHALL)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bn-thomas)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)

ADR_BASE_LISTENER = C:app homas

[/code]

so how do I extract the port number 1521 and store it in a variable?

thanks
Sign In or Register to comment.