I am trying to create a database troy2 using dbca – silent mode. there is already a database named troy running on this serever
new db - troy2
existing db - troy
server - oel6-node01.eu.brit
listener - configured with floating ip remote.eu.brit / 1521
I recieved this error message
ORA-29532: Java call terminated by uncaught Java exception: java.net.BindException: Unable to bind endpoint, status = 12541<0.0.0.0,2482>
In my case i was creating database on HP-UX box which has service guard package floating IP assigned in the listener.ora
remote.eu.brit – service guard package floating IP
oel6-node01.eu.brit – my actual host
cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = remote.eu.brit)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = troy.eu.brit)
(ORACLE_HOME = /u01/infra/oracle/product/infra)
(SID_NAME = troy)
)
)
as there were other databases running on this server using this default listener so i added one more listener with host=localhost.
note that you have to use port 1521 and localhost in the new listener. instead of locahost you can try oel6-node01.eu.brit as well. If there was already a default listener with host=oel6-node01.eu.brit and port 1521 then you might not receiev this error message.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = remote.eu.brit)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = troy.eu.brit)
(ORACLE_HOME = /u01/infra/oracle/product/infra)
(SID_NAME = troy)
)
)
LISTENER_troy2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
SID_LIST_LISTENER_troy2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = troy2.eu.brit)
(ORACLE_HOME = /u01/infra/oracle/product/infra)
(SID_NAME = troy2)
)
)
start the listener LISTENER_troy2 and try again dbca. it should succeed now.