Tuesday, 20 June 2017

TNS-12542: TNS:address already in use TNS-12560 TNS-00512 Linux Error: 98: Address already in use

Error:



TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use
  

Solution:
check the listerner.ora from ORACLE_HOME/network/admin

I see two entries with same IP,So removed one value form the address and started the listener.



LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.11.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =  10.11.11.1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = SID1)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1)
    )
    (SID_DESC =
      (SID_NAME = SID2)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1)
    )
    (SID_DESC =
      (SID_NAME = SID3)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1)
    )
)

No comments: