Warning: session_start(): open(/tmp/sess_jt6d4cp0s3b34b1vo6heugc075, O_RDWR) failed: No space left on device (28) in /razi/eraazi/darbari/mercy/index.php on line 15
EraAzi | TNS-12542: TNS:address already in use TNS-12542: TNS:address already in use
 

PROBLEM:

While starting the listener, getting an error like TNS-12542: TNS:address already in use

# lsnrctl start LISTENER_TEST2

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-SEP-2018 11:06:57

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/exatree-host/listener_test2/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatree-host)(PORT=1524)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=exatree-host)(PORT=1524)))
TNS-12542: TNS:address already in use ---- >>> 
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Solaris Error: 125: Address already in use

Listener failed to start. See the error message(s) above...

SOLUTION:

To find out the issue, Let-s check the content of the listener in listener.ora file.

LISTENER_TEST2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = exatree-host)(PORT = 1524)) --- >>> 
      (ADDRESS = (PROTOCOL = TCP)(HOST = exatree-host)(PORT = 1524)) --- >>>

    )
  )

SID_LIST_LISTENER_TEST2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = BSSLYDEV)
      (ORACLE_HOME = /oracle/app/oracle/product/12.1.0.2/dbhome_1)
    )
  )

Inside the listener entry, we have 2 ADDRESS entries with same host and same port number(1524) . So starting the listener is failing with conflict.

   (ADDRESS = (PROTOCOL = TCP)(HOST = exatree-host)(PORT = 1524))
      (ADDRESS = (PROTOCOL = TCP)(HOST = exatree-host)(PORT = 1524))

To fix the issue, give different ports for both the ADDRESS entries.

the listener will look as below:( 1524 and 1525)

LISTENER_TEST2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = exatree-host)(PORT = 1524))
      (ADDRESS = (PROTOCOL = TCP)(HOST = exatree-host)(PORT = 1525))

    )
  )

SID_LIST_LISTENER_TEST2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = BSSLYDEV)
      (ORACLE_HOME = /oracle/app/oracle/product/12.1.0.2/dbhome_1)
    )
  )

Now start the listener.

# lsnrctl start LISTENER_TEST2

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-SEP-2018 11:08:09

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/exatree-host/listener_test2/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatree-host)(PORT=1524)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatree-host)(PORT=1525)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=exatree-host)(PORT=1524)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_TEST2
Version                   TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
Start Date                03-SEP-2018 11:08:09
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/exatree-host/listener_test2/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatree-host)(PORT=1524)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exatree-host)(PORT=1525)))
Services Summary...
Service "BSSLYDEV" has 1 instance(s).
  Instance "BSSLYDEV", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully



Listener started successfully.

Listener started successfully and listening on both 1524 and 1525 port. So in simple words, port should be unique for each ADDRESS entry of the listener.

 

 

 

LISTENER TROUBLESHOOTING


Related Topics

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

You May Also Like

resumable_timeout parameter in oracle database
Lock account automatically with INACTIVE_ACCOUNT_TIME
FLASHBACK parameter in DATAPUMP(EXPDP)
How to run expdp in pluggable database(PDB)
Script to get cpu usage and wait event information in oracle database
How to change sysman password for oracle 12c cloud control
Query clause in oracle datapump expdp
Clone a database using dbca command in oracle 19c -New feature
How to change the case (Lower to Upper and Vice Versa) in R
How to install postgres database on mac os/linux

From This Website

MySQL Replication and its Types
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
How to use oratop tool for oracle database monitoring
Install oracle enterprise manager cloud control 12c
Create, configure and mount a Linux file system on Oracle VM
Ansible script to run script on remote server and fetch the output
SQLCL UTILITY IN ORACLE
Display sql_id of the sql, using set feedback in oracle 18C - New feature
How to Read CSV files in R studio
How to change spfile in Oracle RAC.