plication ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
SQL> show parameter service_names
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string RACDB
[oracle@rac1 ~]$ lsnrctl status 监听的也删除了
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 12-OCT-2013 21:29:16
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 12-OCT-2013 20:08:37
Uptime 0 days 1 hr. 20 min. 38 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP OFF
Listener Parameter File /opt/ora10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/ora10g/product/10.2.0/db_1/network/log/listener_rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.200)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "RACDB" has 1 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
Service "RACDBXDB" has 1 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
Service "RACDB_XPT" has 1 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
The command completed successfully
OCR中的信息已经被删除了,但是数据字典中的还有该service的内容,继续清除数据字典中的内容。
先查看数据字典内容:
select name, failover_method, failover_type, goal, clb_goal
from dba_services;
SYS$BACKGROUND NONE SHORT
SYS$USERS NONE SHORT
RACDBXDB LONG
RACDB LONG
racdb_taf BASIC SELECT NONE LONG
清除数据字典里的内容:
SQL> begin
dbms_service.delete_service(service_name=>'racdb_taf');
end;
/
再查就没有了
select name, failover_method, failover_type, goal, clb_goal
from dba_services;
SYS$BACKGROUND NONE SHORT
SYS$USERS NONE SHORT
RACDBXDB LONG
RACDB LONG