Please follow to Add Services to a Single instance
While the database is up, run the following as sys:
alter system set service_names=’DB_DEFAULT_SERVICE, DB_HTML_DB, DB_DEV_SERVICE’
When you check lsnrctl it will now show the new services as listening:
SQL> lsnrctl status
LSNRCTL for Linux: ………..
————————
Services Summary…
Service “DB” has 1 instance(s).
Instance “DB1”, status READY, has 2 handler(s) for this service…
Service “DBXDB” has 1 instance(s).
Instance “DB1”, status READY, has 1 handler(s) for this service…
Service “DB_DEFAULT_SERVICE” has 1 instance(s).
Instance “DB1”, status READY, has 2 handler(s) for this service…
Service “DB_DEV_SERVICE” has 1 instance(s).
Instance “DB1”, status READY, has 2 handler(s) for this service…
Service “DB_HTML_DB” has 1 instance(s).
Instance “DB1”, status READY, has 2 handler(s) for this service…
Service “DB_XPT” has 1 instance(s).
Instance “DB1”, status READY, has 2 handler(s) for this service…
The command completed successfully
Recent Posts

Start typing and press Enter to search