My Oracle Support Banner

TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA while listener status/reload/stop (Doc ID 2378697.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle Net Services - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Unable to stop/reload/status listener, getting below error:

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-MAR-2018 04:47:55

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host_name>)(PORT=16602)))
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Changes

Rebooted the database server.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.