nerdexam
Oracle

1Z0-082 · Question #54

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement is true?

The correct answer is C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service. https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

Configure the Oracle Network Environment

Question

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

Options

  • ADynamic service registration cannot be used for this database instance
  • BThe LREG process registers services dynamically with the LISTENER_1 listener
  • CLISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service
  • DThere are two listeners named LISTENER and LISTENER_1 running simultaneously using port
  • EThe definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service

How the community answered

(22 responses)
  • A
    9% (2)
  • C
    73% (16)
  • D
    14% (3)
  • E
    5% (1)

Explanation

https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

Topics

#LOCAL_LISTENER#LREG#dynamic service registration#TNSNAMES.ORA

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice