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

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

You May Also Like

Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
How to recreate MGMT database in ORACLE 12C GRID
Steps for upgrading weblogic 12.1.2 to 12.1.3
How to install OPatch in ORACLE RAC
How to flashback a Pluggable database ( PDB) in oracle 12.2
What is colored sql_id in dba_hist_colored_sql
How to change flash recovery area location
Shell script to delete old archives using RMAN
SAMPLE parameter in EXPDP to export subset of data
How to flashback a RAC database

From This Website

How to get the execution plan for a SQL between two AWR snapshots
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump
Apply database proactive bundle patch in RAC using manual process
Steps for upgrading weblogic 12.1.2 to 12.1.3
Steps for upgrading oracle database to 19c using DBUA
TNS-01106: Listener using listener name has already been started
How to flashback a RAC database
How to recreate physical standby controlfile
How to install postgres database on mac os/linux
OGG-01028 partial record at sequence extract abended