Este post também está disponível em:
English
Que tal acompanhar o que está acontecendo no log em servidores windows, igual fazemos no linux com o comando tail, mas no Windows.
Veja abaixo como realizar essa análise de log no Windows. Na hora de realizar um troubleshooting, ajuda bastante para ver se está ocorrendo erro na hora.
Get-Content <caminho completo do arquivo> -Wait -Tail 30Exemplo de utilização:
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
