Database Administration (MOSC)

MOSC Banner

tnsping works, but "lsnrctl status" gives error

Odd situation. Anyone know why s1name listener not working with lsnrctl status command? It's working for tnsping and for sqlplus.

Environment is: Oracle 19c, Single Tenant PDB, Linux 7.9

tnsping works successfully

tnsping sname1 
...
...
OK (10 msec) 


sqlplus works successfully

sqlplus user1/spass1@sname1
...
...
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL>


But lsnrctl status s1name gives error

lsnrctl status s1name

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXX)(PORT=XXXX)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
 TNS-00511: No listener
  Linux Error: 2: No such file or directory




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