修改service_names遇到的问题
本帖最后由 biotwang 于 2014-12-16 10:33 编辑尝试修改service_names:alert system set service_names='DBXXX' scope=both;发现在修改后，重启了listener，再次查看状态，发现service PD 仍然存在。。。(DBXXX服务已经可用无问题)。
通过tnsnames.ora将连接描述符中设置为service_name=PD，发现连接任然可用。
Service "PD" has 1 instance(s).
Instance "PD001", status READY, has 1 handler(s) for this service...
想知道如何真正能将PD这个服务关闭。$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-DEC-2014 14:14:39
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 10-DEC-2014 12:43:36
Uptime 0 days 1 hr. 31 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/ listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/inst01/listener/alert/log .xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=inst01.dbxxx.com)(PORT=1521)))
Services Summary...
Service "DBXXX" has 1 instance(s).
Instance "PD001", status READY, has 1 handler(s) for this service...
Service "PD" has 1 instance(s).
Instance "PD001", status READY, has 1 handler(s) for this service...
Service "PD001XDB" has 1 instance(s).
Instance "PD001", status READY, has 1 handler(s) for this service...
The command completed successfully
$
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 10 14:14:48 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string DBXXX
SQL>
页:
[1]