The lsnrctl status shows a fully qualified name listed as the "Service" but it should only list the actual service_names value that is in the database.
Why is it using the fully qualified service name????
service_names = abcdefg
tnsnames.ora file shows:
ABCDEFG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host.domain.edu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = abcdefg)
)
)
LISTENER_HOST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host.domain.edu)(PORT = 1521))
lnsrctl status show the following in the Services Summary
Services Summary...
Service "abcdefg.domain.edu" has 1 instance(s).
Instance "abcdeft", status READY, has 1 handler(s) for this service...
The command completed successfully