Skip to Main Content
  • Questions

  • Listener logs showing other port number than 1521, and audit table show connection port number is other than 1521

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Gyan.

Asked: September 10, 2020 - 4:22 am UTC

Last updated: September 10, 2020 - 7:09 am UTC

Version: 11.2.0.2

Viewed 1000+ times

You Asked

I have set listener with port number as 1521, but while checking the listener logs, the port number is showing other than 1521, and also on audit table connection port number is showing other than 1521.

Listener status:
lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 10-SEP-2020 10:07:19

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 01-JAN-2020 20:02:50
Uptime 252 days 14 hr. 4 min. 29 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/SBKTMHPDPMA/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=******)(PORT=1521)))
Services Summary...



listener log:
(CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=*****))(SERVICE_NAME=****)) * (ADDRESS=(PROTOCOL=tcp)(HOST=****)(PORT=58548)) * establish * PRODSAN * 0

Also unable to identify the failure login attempts from listener logs.

So, please guide us for same.

and Connor said...

I suspect someone is trying to launch the SQL Developer debugger.

Take a look in v$plsql_debuggable_sessions (although this is transient data).

More info on remote debugging here

https://mahmoudhatem.wordpress.com/2017/04/10/improved-remote-session-debugging-dbms_debug_jdwp/

You can set preferences in SQL Developer to set min/max port ranges for debugging

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.