Tag Archives: spfile

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file

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? A. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration B. Dynamic service registration cannot be used for this database instance C. The LREG process registers services dynamically… Read More »

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file

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? 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… Read More »