使用如下命令，请自行替换下文件名

cat test.log|grep HOST|awk -F '=' '{print $4}'|awk -F ')' '{print $1}'|awk '{print $1}'|sed ":a;N;s/\n/\//g;ta"   
复制

兄弟，是写SQL，不是在OS层面操作

– 粗暴拼接，若是还有，更改instr函数中出现的位置 instr(‘字符串’,‘查找字符’,‘开始位置’,‘第几次出现’)

select REPLACE(substr(a,instr(a,'HOST')+7,(instr(a,'PORT')-2)-(instr(a,'HOST')+7))||'/'||
substr(a,instr(a,'HOST',1,2)+7,(instr(a,'PORT',1,2)-2)-(instr(a,'HOST',1,2)+7))||'/'||
substr(a,instr(a,'HOST',1,3)+7,(instr(a,'PORT',1,3)-2)-(instr(a,'HOST',1,3)+7))||'/'||
substr(a,instr(a,'HOST',1,4)+7,(instr(a,'PORT',1,4)-2)-(instr(a,'HOST',1,4)+7)),'//','')
 from test
复制

使用到的测试表：
新建测试表，包含一个字段，并插入你给定的字符串

create  table test(a varchar2(1000));
复制

如果都是IP的话，就正则直接找IP

with t as
 (select '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.12.5.55)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.12.5.56)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTMDB)
)
)' str
    from dual)
select listagg(regexp_substr(str, '(\d+\.\d+.\d+.\d+)', 1, level),'/')
  from t
connect by level <= regexp_count(str, '(\d+\.\d+.\d+.\d+)');
复制

带域名的

with t as
 (select '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.12.5.55)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.12.5.56)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTMDB)
)
)' str
    from dual)
    select listagg(regexp_substr(str,'(HOST\s*=\s*)(.*?)(\))',1,level,'i',2),'/') from t
    connect by level <= regexp_count(str,'(HOST\s*=\s*)(.*?)(\))')
    ;
复制

DarkAthena, 试了你的SQL，似乎在listagg后要加winthin group (order by ...)才行吧：

with t as
(select '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.12.5.55)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.12.5.56)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTMDB)
)
)' str
from dual)
select listagg(regexp_substr(str,'(HOST\s*=\s*)(.*?)(\))',1,level,'i',2),'/') within group(order by null)
from t
connect by level <= regexp_count(str,'(HOST\s*=\s*)(.*?)(\))')
;