Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Listener shows wrong service

user135274Nov 1 2007 — edited Nov 1 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2007
Added on Nov 1 2007
2 comments
720 views