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: Version 11.1.0.7.0 - Production on 09-FEB-2011 15:01:01

------------------------
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

This will also show up in the spfile similar to below:

*.service_names='DB_DEFAULT_SERVICE, DB_HTML_DB, DB_DEVELOPER_SERVICE'

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: