Kbase P10038: Can not connect to oracle database using the DataServer broker
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/25/2005 |
|
Status: Unverified
SYMPTOM(s):
Can not connect to oracle database using the DataServer broker
Has 4 distributed schema holders
This is a client/server configuration to the schema holder but the schema holder is not proserved with a port number
The following connection parameters are missing from the connection to the schema holder:
-S -H and -N tcp
The _probrkr is running fine
The broker information (-H, -S and -N tcp) also missing from the connection parameter from the progress client machine
CAUSE:
Since this is a distributed configuration, The schema holder needs to be running as a server, and the schema holder and the broker port needs to be supplied in the connection parameters with -S including -H and -N.
The schema holder is not being run as server, and in addition, the schema holder port and the broker port were not supplied in the connection parameters with -S including -H and -N.
FIX:
In order to connect to the schema holder, follow the steps below:
1. proserve each of the four schema holder with a distinct port number with -H -S -N.
2. start the broker using one distinct port.
3. Use the connection parameters as
-db <schema holder_name> -H <schema holder_host_name> -S <port#_schema holder is running> -N tcp -db <orecle_SID_Name> -dt ORACLE -ld <logical_name> -H <broker_host_Name> -S <broker_port> -N tcp -U <user_name@sql-net_service_name> -P <password>