failed connection attempts in listner.log file

From: <ahmed.fikri_at_t-online.de>
Date: Thu, 27 Jan 2022 16:54:06 +0100 (CET)
Message-ID: <1643298846834.7914794.4886618e28b28b121a92df035289718ae670691a_at_spica.telekom.de>



Hi all,  

I'm trying to find out non-successful connection attempts In the listener.log file I see entries like this:  

27-JAN-2022 15:18:38 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=O12CPDB)(CID=(PROGRAM=C:\Program?Files\PLSQL?Developer?12\plsqldev.exe)(HOST=LAPTOP-2LQOLENG)(USER=kirux)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=172.17.0.1)(PORT=60836)) * establish * O12CPDB * 0   27-JAN-2022 15:30:24 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=O12CPDB)(CID=(PROGRAM=C:\Program?Files\PLSQL?Developer?12\plsqldev.exe)(HOST=LAPTOP-2LQOLENG)(USER=kirux)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=172.17.0.1)(PORT=60922)) * establish * O12CPDB * 0   First entry when trying to log in with a wrong PW and the second one with the right one. Both looks similar.  

Is this normal and is there any way find out non-successful connection attempts? The example was done using a 12.2.0.1 installed in a docker and the host is a windows machine.  

Best regards
Ahmed


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 27 2022 - 16:54:06 CET

Original text of this message