Error:
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.
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:
Post a Comment