How To Register "This" As The Listener

Connor McDonald

Thanks for the question, John.

Asked: July 08, 2016 - vi:03 pm UTC

Last updated: July xi, 2016 - 12:51 am UTC

Version: eleven.2

Viewed 50K+ times! This question is

You Asked

Hello

I create a service similar and then:

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.ii.0/dbhome_1)
(SID_NAME = MYSERVICE)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = /u01/app/oracle/product/xi.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)

So I offset the listener:

(Clarification=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1527)))
Services Summary...
Service "Oracle8" has one instance(s).
Instance "ORCL", status UNKNOWN, has ane handler(s) for this service...
Service "oem" has 1 instance(due south).
Instance "MYSERVICE", status UNKNOWN, has one 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 mistake:

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

SQL*Plus: Release 11.2.0.iv.0 Production on Fri Jul eight 11:02:30 2016

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

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

Please advise,

Thanks,

John

and Connor said...

You dont need to change the listener.ora. Later you lot create/start the service, the database will annals that service with the listener (and will do then periodically). Or you tin can effect "alter system annals".

In item, the SID proper name is *not* related to the service.