Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Restart listener configuration without touching listener.ora?

RobertOrtelJul 24 2014 — edited Jul 24 2014

Hi,

when installing a database in an oracle restart environment, right now I am adding a database listener through srvctl like this:

srvctl add    listener -l LSNR_${DB_NAME} -o ${ORACLE_HOME} -p "TCP:${PORT}"

srvctl setenv listener -l LSNR_${DB_NAME} -T ORACLE_BASE=${ORACLE_BASE}

Additionally I am adding the appropriate lines to the corresponding listener.ora: (example)

LSNR_PLAY =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = sol001.hypoport.local)(PORT = 8029))

    )

  )

ADR_BASE_LSNR_PLAY = /ora01/app/oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LSNR_PLAY = ON

ADMIN_RESTRICTIONS_LSNR_PLAY = ON

This works well as long I as I am no more touching any listener configuration. But when I am changing some listener parameters, some oracle agent rewrites the listener.ora file on its own to reflect those changes.

So I am wondering if I can completly skip to touch the listener.ora file on my own and let this agent do this job, while making all the configuration through srvctl (or maybe lsnrctl). But this would require to toggle ADMIN_RESTRICTIONS and ENABLE_GLOBAL_DYNAMIC_ENDPOINT in a permanent fashion using those utilities. Is that possible? How?


Thx

Robert


==================================

GI is 11.2.0.4

DB is 11.2.0.[34]

This post has been answered by RobertOrtel on Jul 24 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2014
Added on Jul 24 2014
3 comments
680 views