比如在克隆环境时候,把生产的环境克隆到DEV环境,你可能会在进程调度服务器中看到了生产的进程服务器,例如:你可能会在进程调度的时候选择一个server,但是这个server并没有在psadmin下创建domain,有些时候,他可能会带来运行时错误。
在PIA没有更好的办法删除进程服务器,以下以PSNT2为例,需要在plsql中运行:
DELETE FROM PS_SERVERDEFN WHERE SERVERNAME=’PSNT2′ ;
DELETE FROM PSSERVERSTAT where SERVERNAME =’PSNT2 ;
DELETE FROM PS_SERVERCLASS WHERE SERVERNAME=’PSNT2′ ;
DELETE FROM PS_SERVEROPRTN WHERE SERVERNAME=’PSNT2′ ;
DELETE FROM PS_SERVERACTVTY WHERE SERVERNAME=’PSNT2′ ;
DELETE FROM PS_SERVERMESSAGE WHERE SERVERNAME=’PSNT2′ ;
DELETE FROM PS_SERVERNOTIFY WHERE SERVERNAME=’PSNT2′ ;
DELETE FROM PS_SERVERPURGLIST WHERE SERVERNAME=’PSNT2′ ;
DELETE FROM PSPRCSQUE WHERE SERVERNAMERQST=’PSNT2′ ;
DELETE FROM PS_CDM_TRANSFER WHERE SERVERNAMERUN=’PSNT2′ ;
DELETE FROM PSPRCSRQST WHERE SERVERNAMERQST=’PSNT2′ ;
通过该方法你可以使你的进程服务器列表特别干净,因为没用的进程服务器都可以删掉。/(ㄒoㄒ)/~~