LLI Wiki — My Digital Knowledge Base

Oracle: UNKNOWN service status in lsnrctl

Understand the UNKNOWN status of a static listener registration and check the dynamic (READY) registration after a restart.

The UNKNOWN status in lsnrctl status is not an error by itself. What matters is whether the instance also has a dynamically registered entry with the status READY.

What UNKNOWN means

The instance is hard-coded in listener.ora (static registration). The listener knows about the service, but the instance may not be registered with it. A database that is running and dynamically registered appears with a second entry, with the status READY.

Each database should therefore have two entries: a static entry UNKNOWN and a dynamic entry READY. If the READY entry is missing after a restart, the instance is not registering with the listener.

Force the registration

Connected as SYSDBA, ask the instance to register with the listener, then check the result:

alter system register;
lsnrctl status

Notes

Mastodon LLIMastodon SocialFosstodon