This exercise is worth 10 points. Enter the commands you used and the relevant verification output, and then select Submit to compare your response with the suggested solution.
Oracle AI Database 26ai normally uses the Listener Registration process (LREG) to register database services dynamically. Dynamic registration usually eliminates the need to place ordinary database services in the SID_LIST section of listener.ora.
This lab intentionally uses a static SID_LIST_LISTENER entry for the COIN instance so that you can practice administering the listener and verifying a static registration. Restarting the listener causes it to read the updated listener.ora configuration.
Lab caution: Stopping a listener temporarily prevents new client connections through that listener. Perform these steps only in the lab or during an approved maintenance window.
- Open an operating-system command shell as the Oracle software owner.
- Run
lsnrctl STATUS and identify the listener name. The default name is LISTENER.
- Run
lsnrctl STOP to stop the default listener.
- Run
lsnrctl START to start the listener and verify connectivity to it.
- Run
lsnrctl SERVICES and locate the service or instance entry for COIN.
- Paste your command sequence and the relevant
COIN lines into the response area.
If your listener has a nondefault name, append that name to each command, for example lsnrctl STATUS listener_name.