nerdexam
Oracle

1Z0-052 · Question #229

You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE .. command. You have not enabled…

The correct answer is F. RELOAD L1. LSNRCTL RELOAD L1 re-reads the listener.ora configuration file and applies the new static entry for PAY to the named listener process without stopping it, preserving active connections.

Configuring the Oracle Network Environment

Question

You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE .. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?

Options

  • ASTART
  • BRELOAD
  • CRESTART
  • DREFRESH
  • ESTART L1
  • FRELOAD L1
  • GRESTART L1
  • HREFRESH L1

How the community answered

(26 responses)
  • A
    4% (1)
  • C
    12% (3)
  • F
    81% (21)
  • G
    4% (1)

Why each option

LSNRCTL RELOAD L1 re-reads the listener.ora configuration file and applies the new static entry for PAY to the named listener process without stopping it, preserving active connections.

ASTART

START is used to launch a listener that is currently not running, not to apply configuration file changes to an already running listener process.

BRELOAD

RELOAD without a listener name targets the default listener named LISTENER, not the named L1 process, so the PAY entry would not be loaded for L1.

CRESTART

RESTART stops the listener and then starts it again, which would temporarily drop all existing connections to the PROD and ADMIN databases.

DREFRESH

REFRESH is not a valid LSNRCTL command for re-reading and applying changes from listener.ora.

ESTART L1

START L1 would only start the L1 listener if it were stopped; it cannot reload a new configuration into an already running process.

FRELOAD L1Correct

The RELOAD command instructs the listener control utility to re-read listener.ora and incorporate any newly added static service entries without stopping the listener process. Specifying L1 targets the named listener rather than the default listener, ensuring the PAY database entry is loaded into the correct process. Because the listener is never stopped, all existing connections to PROD and ADMIN remain completely unaffected.

GRESTART L1

RESTART L1 stops and restarts the L1 listener, which breaks all active connections to PROD and ADMIN during the restart cycle.

HREFRESH L1

REFRESH L1 is not a recognized LSNRCTL sub-command for applying listener.ora changes to a running listener.

Concept tested: LSNRCTL RELOAD command for named listener reconfiguration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/enabling-oracle-net-services.html

Topics

#LSNRCTL RELOAD#listener configuration#LISTENER.ORA#dynamic registration

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice