This post is also available at:
Português
How about keeping track of what’s happening in the log on Windows servers, just like we do on Linux with the tail command, but on Windows.
Here’s how to do this log analysis on Windows. When troubleshooting, it helps a lot to see if an error is occurring at the time.
Get-Content <caminho completo do arquivo> -Wait -Tail 30Example of use:
PS C:\Users\Henrique> Get-Content C:\oracle\app\product\12.1.0\dbhome_1\log\diag\tnslsnr\PDV\listener\trace\listener.log -Wait -Tail 30
07-MAI-2021 08:03:24 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=pdv))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.68)(PORT=56712)) * establish * xe * 0
07-MAI-2021 08:03:25 * <unknown connect data> * 12537
TNS-12537: TNS:conexão fechada
TNS-12560: TNS:erro de adaptador de protocolo
TNS-00507: Conexão fechada
07-MAI-2021 08:03:25 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=user_pdv))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.68)(PORT=56713)) * establish * xe * 0
07-MAI-2021 08:03:25 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.158)(PORT=57660)) * establish * xe * 0
07-MAI-2021 08:03:25 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.162)(PORT=50167)) * establish * xe * 0
07-MAI-2021 08:03:25 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.156)(PORT=49738)) * establish * xe * 0
07-MAI-2021 08:03:26 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.171)(PORT=53335)) * establish * xe * 0
07-MAI-2021 08:03:26 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.160)(PORT=58082)) * establish * xe * 0
07-MAI-2021 08:03:26 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.84)(PORT=54695)) * establish * xe * 0
07-MAI-2021 08:03:26 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.61)(PORT=50003)) * establish * xe * 0
07-MAI-2021 08:03:27 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.77)(PORT=57860)) * establish * xe * 0
07-MAI-2021 08:03:27 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=User_PDV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.153)(PORT=52769)) * establish * xe * 0
07-MAI-2021 08:03:27 * <unknown connect data> * 12537
TNS-12537: TNS:conexão fechada
TNS-12560: TNS:erro de adaptador de protocolo
TNS-00507: Conexão fechada
