Manage Services

数据库的service名称，用于数据库对外的连接服务：
例如可以通过不同的服务名称，分别用于数据库的独占连接，或者共享连接
或在RAC数据库中，配置TAF，不同服务名可以连接到不同实例。
 
查看数据库服务名：
show parameter service_names
 
设置服务名的简单方法：
 
SQL> alter system set service_names='ora10g48,o48';
 
SQL> show parameter service_names
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      ora10g48,o48
 
$ lsnrctl service
......
Service "o48" has 1 instance(s).
  Instance "ora10g48", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "ora10g48" has 2 instance(s).
  Instance "ora10g48", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2 refused:0
         LOCAL SERVER
......