Kbase P19055: Oracle DataServer limits the Progress DB client connections to 65
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
Progress 9.1C
Progress 9.1D
Progress 9.1E
SYMPTOM(s):
Error: Workgroup server cannot support more than <number> users. (5051)
Error: Workgroup server cannot support more than 65 users. (5051)
Error: Number of users (-n) adjusted to <number>. (5055)
Error: Number of users (-n) adjusted to 65. (5055)
Client server connections.
CAUSE:
ORACLE DataServer has included the Workgroup Database Server capabilities in the product for 9.1C. This Workgroup license is intended for Progress DB's, not for Oracle DataServer connections. Oracle DataServer connections are not limited to 65 if they are correctly connected.
FIX:
Steps to correctly connect the Oracle Data Server
1.- Start the Oracle DataServer broker like this:
_probrkr -S <Service name or port #> -H <host name> -N TCP
2.- Create a directory in a mapped drive on a file server (let's say to h:\holder\).
3.- Open the Progress Data Adminstration and create a new empty DB, that will work as an schema holder (let call it orahold).
4.- Go to the DATASERVER > ORACLE UTILITIES > CREATE DATASERVER SCHEMA option and type:
Logical Database Name: <Name of the Oracle instance>
Oracle Version: <Version of Oracle>
Connection Parameters:
-S <service name or port # of the Oracle DataServer broker > -H <hostname where the Oracle DataServer broker started> -U <Oracle user> -P <Oracle Password>
Example:
-S orabrkr -H mainhost -U Jhon -P secret01
Then press the OK button.
5.- Progress will ask the Oracle user and password, since you have provided the user and password already you can ignore this.
6.- You will be prompted to define which objects you are going to pull into the schema holder.
Type the following:
Object Name: * (leave '*' if you don't know the table name)
Object Type: table
Object Owner: * (leave '*' if you don't know the owner of the table)
7.- Select the tables that you want to access from Progress 4GL.
8.- Disconnect the schema holder and close the Progress session.
9.- Connect to the Oracle DB using the following parameters:
<holder path and name> -1 -RO -db <Oracle instance name> -dt ORACLE
-S <service name or port # of the Oracle DataServer broker > -H <hostname where the Oracle DataServer broker started>
Following the example would be:
prowin32.exe h:\holder\orahold -1 -RO -db ORAsales -dt ORACLE -S orabrkr -H mainhost