oracle 添加服务

修改service_names,添加一个test服务

SQL> show parameter service_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
service_names                        string      WANDA
SQL> 
SQL> alter system set service_names='wanda,test';

System altered.

SQL> show parameter service_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
service_names                        string      wanda,test

配置listener，让listener能注册test服务

[oracle@node1 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production