No free server port in the given ports range

[lsabster]

When executing the datasource from multiple workstations, the user gets the following error: Please advise.

ORA-28501: communication error on heterogeneous database link
[Generic Connectivity Using ODBC][C083] No free server port in the given ports range
ORA-02063: preceding 2 lines from OPTM

Irpcd daemon file is as below.




<?xml version='1.0' encoding='ISO-8859-1'?>
<navobj version='4.8.2.0'>
<daemon name='IRPCD'>
<workspaces>
<workspace name='Navigator' description='Default Workspace' startupScript='/u003/prty/ts11/optm/rt/navroot/bin/nav
_server'
serverPortsRange='25863-25863' serverLogFile='/u003/prty/ts11/optm/rt/navroot/tmp/nav_%i.log'
workspaceAccount='optmts11'/>
<workspace name='ACURLSVC' description='javaServer' serverType='java'
serverMode='multiThreaded' nAvailableServers='1'
disable='TRUE' listingAllowed='FALSE' workspaceAccount='optmts11'
serverLogFile='/u003/prty/ts11/optm/rt/navroot/tmp/java_srv%i.log'
startupScript='/u003/prty/ts11/optm/rt/navroot/bin/nav_jserver'/>
<workspace name='ACADMIN' description='Administration server' serverPortsRange='25864-25864'
serverMode='multiClient' maxNAvailableServers='1'
maxNActiveServers='1' nAvailableServers='1' workspaceAccount='optmts11'
serverLogFile='/u003/prty/ts11/optm/rt/navroot/tmp/admin_svc%i.log'
startupScript='nav_server'/>
</workspaces>
<control serverLogFile='/u003/prty/ts11/optm/rt/navroot/tmp/nav_%i.log'/>
<logging logFile='/u003/prty/ts11/optm/rt/navroot/tmp/irpcd.log' logOpers='true'/>
<security/>
<versionsPorts/>
</daemon>
</navobj>

[ussupport1]

If you look at the worspaces there is only one port per workspace specified. This range is an estimate of the number of conncurrent nav_util processes running at any given time. You can pad this estimate by say 20% plus pad the range with more ports given that we do not reserve the ports in this range. The message given states that a second start of a nav_util process was attempted and one was active. You need to adjust this range according to the criteria given above.