Avatar of chalie001
chalie001
 asked on

ORA-12541: TNS:no listener

hi am not able to connect to database

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1539)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 18.0.0.0.0 - Production
Start Date                26-MAY-2020 12:00:18
Uptime                    0 days 0 hr. 47 min. 28 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/soft/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/Ncsmaint/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1539)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "maint" has 1 instance(s).
  Instance "maint", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
bash-4.1$ sqlplus /nolog

SQL*Plus: Release 18.0.0.0.0 - Production on Tue May 26 12:48:01 2020
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

SQL> connect username/pswd@dbid
ERROR:
ORA-12541: TNS:no listener


SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> connect username/pswd@dbid
ERROR:
ORA-12541: TNS:no listener


Warning: You are no longer connected to ORACLE.
SQL>
* Oracle12c* Oracle PL/SQLDatabasesOracle Database* Oracle DBA

Avatar of undefined
Last Comment
noci

8/22/2022 - Mon
Alex [***Alex140181***]

Port 1539 might be, not default, but ok.
But what about the host "0.0.0.0"?! This can't be correct??!!
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
noci

Host 0.0.0.0 effectively means "Address unknown, choose your pick..." and the only globally known address then should be the systems Own address. or discard it as invalid choice.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes