Kbase P93121: Getting error 1891 in dataserv.lg
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Getting error 1891 in dataserv.lg
BROKER: The server could not open the foreign database. (1891)
Using SQLNET connection to a local Oracle database.
Using @ for userid in connect string to a local database
When the -U connect parameter was issued, it contained the /@<instance name>.
When trying to connect to a local Oracle Instance, all proper environmental variables set properly.
CAUSE:
Instance name not listed in tnsnames Listener file
FIX:
Remove the /@<instance name> from the -U parameter