Thanks.

When I started the dbconsole, the homepage shows, but when I try to login in as sys. Got error:

Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))(CONNECT_DAT A=(SERVICE_NAME=SACTD)))


[orasactd tus1sacdbsdex01] /home/orasactd$ lsnrctl service SACTD

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 16-AUG-2007 14:57:28

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))
Services Summary...
Service "SACTD.ges.XXXX.com" has 1 instance(s).
Instance "SACTD", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:110 refused:0
LOCAL SERVER
The command completed successfully


NOTE, In error message. the service_name IS SACTD,

In the lsnrctl service , it shows the service_name is SACTD.ges.XXXX.com.

Does this matter?

If it does, how can I change the client’s service_name to match the listener ‘s ?

Thanks