PROBLEM:

While starting the lister , getting below error.

# lsnrctl start LISTENER_TEST

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-SEP-2018 09:34:26

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

TNS-01106: Listener using listener name LISTENER_EXATREE has already been started

where ( listener.ora)

LISTENER_TEST =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = exatreehost)(PORT = 1521))
    )
  )

SID_LIST_LISTENER_TEST =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = EXATREE)
      (ORACLE_HOME = /oracle/app/oracle/product/12.1.0.2/dbhome_1)
    )
  )

We are trying to start LISTENER_TEST, However, the error we are getting is LISTENER_EXATREE already started. So how these listeners are related?

SOLUTION:

This error will come, when we are trying to start a listener with a port, which is being used by a different running listener. In simple words,
Two listeners cannot have same port.

Check the port being used by LISTENER_EXATREE.

# lsnrctl status LISTENER_EXATREE



LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-SEP-2018 09:34:41

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXATREE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_EXATREE
Version                   TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
Start Date                20-AUG-2018 12:44:00
Uptime                    13 days 20 hr. 50 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/exatreehost/listener_EXATREE/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatreehost)(PORT=1521))) ----------------->>>>>>>>>>>>>> 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=exatreehost)(PORT=5500))(Security=(my_wallet_directory=/oracle/app/oracle/product/12.1.0.2/dbhome_1/ad
RAW))
Services Summary...
Service "EXATREE" has 1 instance(s).
  Instance "EXATREE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

So the listener LISTENER_DBACLSS is using 1521 port. And the listener which we are trying start LISTENER_TEST also contains 1521 port.

So now change the port for LISTENER_TEST and start it.

We have changed from 1521 to 1523 in the listener.ora file

LISTENER_TEST =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = exatreehost)(PORT = 1523))
    )
  )

SID_LIST_LISTENER_TEST =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = EXATREE)
      (ORACLE_HOME = /oracle/app/oracle/product/12.1.0.2/dbhome_1)
    )
  )
  

Start the listener.

# lsnrctl start LISTENER_TEST

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-SEP-2018 09:35:45

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

Starting /oracle/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
System parameter file is /oracle/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/exatreehost/listener_test/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatreehost)(PORT=1523)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=exatreehost)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_TEST
Version                   TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
Start Date                03-SEP-2018 09:35:45
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/exatreehost/listener_test/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatreehost)(PORT=1523)))
Services Summary...
Service "EXATREE" has 1 instance(s).
  Instance "EXATREE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

It worked.

lsnrctl TROUBLESHOOTING


Related Topics

TNS-01106: Listener using listener name has already been started
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
ORA-01536: space quota exceeded for tablespace
ORA-16855: transport lag has exceeded specified threshold
ORA-32774: more than one file was specified for bigfile tablespace
ORA-32771: cannot add file to bigfile tablespace
TNS-12542: TNS:address already in use
ORA-32773: operation not supported for smallfile tablespace
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
ORA-30034: Undo tablespace cannot be specified as temporary tablespace

You May Also Like

Steps for upgrading oracle database to 19c using DBUA
How to find execution history of an sql_id
How to install trace file analyzer( TFACTL)
TNS-01106: Listener using listener name has already been started
How to change the case (Lower to Upper and Vice Versa) in R
how to Print execution time of tasks in ansible
Shared Pool Advisory in oracle
Add database as target oracle 12c cloud control
FLASHBACK parameter in DATAPUMP(EXPDP)
Enable DDL replication in goldengate

From This Website

Lock account automatically with INACTIVE_ACCOUNT_TIME
Obey command in goldengate
Open wallet automatically after starting the database
orapwd tool for password file in oracle
Find sessions consuming lot of CPU
How to move controlfile to a new location in oracle
ENABLE_PARALLEL_DML hint in oracle 12c
OGG-00665 OCI Error describe for query
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
Perform Flashback in pluggable database(PDB) in oracle 12.2