oracle 连接信息测试 alter log和listener.log 日志信息

发布时间 2023-08-10 15:16:08作者: shiyunyier

DBeaver

<msg time='2023-08-10T14:52:57.100+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:52:57 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Main)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50114)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-10T14:52:58.411+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:52:58 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Metadata)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50116)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-10T14:52:58.925+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:52:58 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? SQLEditor ?Script?4?sql?)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50117)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-10T14:52:59.638+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:52:59 * service_update * rswb * 0
 </txt>
</msg>

Thu Aug 10 14:52:57 2023
10-AUG-2023 14:52:57 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Main)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50114)) * establish * rswb * 0
10-AUG-2023 14:52:58 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Metadata)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50116)) * establish * rswb * 0
10-AUG-2023 14:52:58 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? SQLEditor ?Script?4?sql?)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50117)) * establish * rswb * 0
10-AUG-2023 14:52:59 * service_update * rswb * 0

plsqldev

<msg time='2023-08-10T14:55:52.665+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:55:52 * (CONNECT_DATA=(SERVICE_NAME=rswb)(CID=(PROGRAM=D:\MApp\PLSQL?Developer\plsqldev.exe)(HOST=DESKTOP-U32JPKD)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50379)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-10T14:55:52.940+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:55:52 * (CONNECT_DATA=(SERVICE_NAME=rswb)(CID=(PROGRAM=D:\MApp\PLSQL?Developer\plsqldev.exe)(HOST=DESKTOP-U32JPKD)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50380)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-10T14:55:53.704+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:55:53 * service_update * rswb * 0
 </txt>
</msg>
<msg time='2023-08-10T14:55:59.706+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:55:59 * service_update * rswb * 0
 </txt>
</msg>

Thu Aug 10 14:55:52 2023
10-AUG-2023 14:55:52 * (CONNECT_DATA=(SERVICE_NAME=rswb)(CID=(PROGRAM=D:\MApp\PLSQL?Developer\plsqldev.exe)(HOST=DESKTOP-U32JPKD)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50379)) * establish * rswb * 0
10-AUG-2023 14:55:52 * (CONNECT_DATA=(SERVICE_NAME=rswb)(CID=(PROGRAM=D:\MApp\PLSQL?Developer\plsqldev.exe)(HOST=DESKTOP-U32JPKD)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50380)) * establish * rswb * 0
10-AUG-2023 14:55:53 * service_update * rswb * 0
10-AUG-2023 14:55:59 * service_update * rswb * 0

Kettle

<msg time='2023-08-10T14:58:30.198+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:58:30 * (CONNECT_DATA=(SID=rswb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50626)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-10T14:58:30.200+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>10-AUG-2023 14:58:30 * (CONNECT_DATA=(SID=rswb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50627)) * establish * rswb * 0
 </txt>
</msg>

Thu Aug 10 14:58:30 2023
10-AUG-2023 14:58:30 * (CONNECT_DATA=(SID=rswb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50626)) * establish * rswb * 0
10-AUG-2023 14:58:30 * (CONNECT_DATA=(SID=rswb)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=50627)) * establish * rswb * 0