Listener shows wrong service
I have 2 database on Linux/Oracle 10G machine. For some reason when I check "lsnrctl service" database FSTST shows as service "FSTST", while database "FSGLD" shows as service "FSGLD.<hostname>". They are configured the same in TNSNAMES.ORA
I am hiding real hostname with <hostname>
TNSNAMES.ORA
FSTST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = FSTST)
)
)
FSGLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT =
1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = FSGLD)
)
)
"lsnrctl service" output.
Service "FSGLD.<hostname>" has 1 instance(s).
Instance "FSGLD", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "FSTST" has 1 instance(s).
Instance "FSTST", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER