1Z0-052 · Question #59
In which situation would you use static database registration for a listener?
The correct answer is B. When DBAs need to connect remotely to start up the database instance. Static listener registration is configured manually in listener.ora and persists even when the database instance is down. This is required when a DBA must remotely connect to start an instance that has not yet registered itself dynamically via PMON.
Question
In which situation would you use static database registration for a listener?
Options
- AWhen multiple databases are to be registered with the listener
- BWhen DBAs need to connect remotely to start up the database instance
- CWhen users need to connect the database instance using the host naming method
- DWhen the database instance that is to be registered with the listener is configured in shared server mode
How the community answered
(40 responses)- A3% (1)
- B90% (36)
- C5% (2)
- D3% (1)
Why each option
Static listener registration is configured manually in listener.ora and persists even when the database instance is down. This is required when a DBA must remotely connect to start an instance that has not yet registered itself dynamically via PMON.
Multiple databases can be registered with a single listener using dynamic registration via PMON without requiring static configuration.
Dynamic registration relies on the PMON background process to advertise service information to the listener, but PMON only runs when the instance is up. With static registration defined in listener.ora, the listener is aware of the database at all times, allowing a DBA to establish a remote connection with SYSDBA or SYSOPER privileges and issue a STARTUP command before PMON is active.
Host naming resolution is a client-side naming method and does not impose a requirement for static listener registration.
Shared server mode configuration is handled through the DISPATCHERS parameter and dynamic registration; it does not specifically require static registration in listener.ora.
Concept tested: Oracle listener static vs dynamic registration use cases
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-and-administering-oracle-net-listener.html
Topics
Community Discussion
No community discussion yet for this question.