Hello

I create a service like so:

exec dbms_service.create_service('MYSERVICE','MYSERVICE');
exec dbms_service.start_service('MYSERVICE');

Then, I add the service in the listener.ora sid_list parameter like so:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oem)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = MYSERVICE)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)

Then I start the listener:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1527)))
Services Summary...
Service "Oracle8" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "oem" has 1 instance(s).
Instance "MYSERVICE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Then, I add the entry in tnsnames:
test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1527))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYSERVICE)
)
)

Finally, I get the error:

[oracle@localhost ~]$ sqlplus jcantu/jcantu@test

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 8 11:02:30 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Is it possible to add a service statically to the listener.ora?

Please advise,

Thanks,

John