Kbase P179019: Error "No servers available" when attempting to connect to DataServer for Oracle via Unified Broker
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/01/2011 |
|
Status: Unverified
SYMPTOM(s):
Error "No servers available" when attempting to connect to DataServer for Oracle via Unified Broker
Error "No servers available" followed by 7255, 1451 when attempting to connect to DataServer for Oracle started with Progress Explorer
Error "No servers available" followed by 7255, 1451 when attempting to connect to DataServer for Oracle started with OpenEdge Explorer
On screen error reports the following:
No servers available
DataServer connection failure. (7255)
Failed to connect to ORACLE database . (1451)
DatasServer broker log reports multiple errors
IOException reading message from server : java.io.EOFException: pipe to server broken (8117)
ERROR: cannot start server. (8100)
admin error response received: <adminErrorMsg>. (8067)
admin error response received: 2. (8067)
Client disconnected : . (8534)
Error No Servers available ... disconnecting client. (8091)
Dataserv.lg reports error 1159
Server cannot find a free port for a TCP socket. (1159)
FACT(s) (Environment):
Starting DataServer brokers via Unified Broker / AdminServer
OpenEdge Category: Installation
OpenEdge 10.2x
UNIX
CAUSE:
There are no available TCP/IP ports in the DataServer's minport/maxport range. By default, the minport/maxport settings for both the database product and DataServer Broker are 1025/2000, which is not ideal as this range is used extensively by the operating system.
FIX:
Modify the "Minimum port number" (-minport) and "Maximum port number" (-maxport) settings found in Server properties for the DataServer Unified Broker to create a port range above 3000.
If these fields are not available then they can be modified manually in the $DLC/properties/ubroker.properties file by setting the srvrMinPort and srvrMaxPort parameters. For example:
#
# Default properties for broker instances serving Oracle DataServers
#
[UBroker.OR]
appserviceNameList=
brkrLoggingLevel=3
classMain=com.progress.ubroker.broker.ubroker
defaultService=0
description=Oracle DataServer Broker
initialSrvrInstance=0
maxSrvrInstance=256
minSrvrInstance=0
operatingMode=State-aware
portNumber=4445
srvrDSLogFile=
srvrExecFile=@{Startup\DLC}/bin/_orasrv
srvrMaxPort=9000
srvrMinPort=8000
srvrStartupParam=-svub -S X -N TCP -U X -P X -hs 0 -s 40