Page 1 of 1

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.The TNSNAMES.ORA file in $ORACLE_HOME/n

Posted: Sun Jun 11, 2023 3:55 pm
by answerhappygod
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?
In The Spfile O 1
In The Spfile O 1 (4.31 KiB) Viewed 195 times
A. Dynamic service registration cannot be used for this database instance
B. The LREG process registers services dynamically with the LISTENER_1 listener
C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration