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

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

 通过隧道配置，访问oracle服务情况

<msg time='2023-08-11T11:09:13.068+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>11-AUG-2023 11:09:13 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Main)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.2)(PORT=18787)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-11T11:09:13.105+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>11-AUG-2023 11:09:13 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Metadata)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.2)(PORT=18788)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-11T11:09:13.151+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>11-AUG-2023 11:09:13 * (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.2)(PORT=18789)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-11T11:09:14.468+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>11-AUG-2023 11:09:14 * service_update * rswb * 0
 </txt>
</msg>

Fri Aug 11 11:09:13 2023
11-AUG-2023 11:09:13 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Main)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.2)(PORT=18787)) * establish * rswb * 0
11-AUG-2023 11:09:13 * (CONNECT_DATA=(CID=(PROGRAM=DBeaver 22?3?0 ? Metadata)(HOST=__jdbc__)(USER=zjl))(SERVICE_NAME=rswb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.2)(PORT=18788)) * establish * rswb * 0
11-AUG-2023 11:09:13 * (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.2)(PORT=18789)) * establish * rswb * 0
11-AUG-2023 11:09:14 * service_update * rswb * 0

 sqlplus

<msg time='2023-08-11T11:16:43.717+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>11-AUG-2023 11:16:43 * (CONNECT_DATA=(SERVICE_NAME=rswb)(CID=(PROGRAM=D:\MApp\product\11.2.0\client_2\sqlplus.exe)(HOST=DESKTOP-U32JPKD)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=64027)) * establish * rswb * 0
 </txt>
</msg>
<msg time='2023-08-11T11:16:44.710+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='localhost.localdomain'
 host_addr='::1'>
 <txt>11-AUG-2023 11:16:44 * service_update * rswb * 0
 </txt>
</msg>

Fri Aug 11 11:16:43 2023
11-AUG-2023 11:16:43 * (CONNECT_DATA=(SERVICE_NAME=rswb)(CID=(PROGRAM=D:\MApp\product\11.2.0\client_2\sqlplus.exe)(HOST=DESKTOP-U32JPKD)(USER=zjl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.1)(PORT=64027)) * establish * rswb * 0
11-AUG-2023 11:16:44 * service_update * rswb * 0