Database Networking (MOSC)

MOSC Banner

Prefix a TNS entry in tnsnames.ora with "LISTENER_": impact...?

edited Jul 18, 2025 1:51PM in Database Networking (MOSC) 1 commentAnswered

Hello,

I'm working now in an 19c environment, on node 1 of a cluster, where I've found that there's a listener running, kind of like:

[user@machine ~]$ ps -ef|grep tns
...
oracle 616255 1 0 Jul16 ? 00:00:02 /u01/app/oracle/product/19.0.0/db_home1/bin/tnslsnr LISTENER_TEST -no_crs_notify -inherit

on a RAC 'TEST' database, on port 1524: yet there's no such specs in this home (file /u01/app/oracle/product/19.0.0/db_home1/network/admin/listener.ora does not contain anything related to this listener).

On the other hand the tnsnames.ora in same directory does show the following entry:

LISTENER_TEST =
(ADDRESS = (PROTOCOL = TCP)(HOST = machine.stuff.com)(PORT = 1524))
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center