Kbase P19930: Error -1012, 1252 and 1451 when connecting to ORACLE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Progress 9.x
SYMPTOM(s):
Error when connecting to ORACLE
Oracle error - 1012 see "Oracle Error Messages and Codes Manual". (1252)
Failed to connect to ORACLE database <db_name>. (1451)
BROKER: The server could not open the foreign database. (1891)
Logoff from dataserver db as user <username>. (2690)
Using Unified Broker
Using SQL*Net/Net8
Error 1891 in the dataserv.log file
Broker is running in a separated machine from ORACLE instance
Message 2690 does not show @servicename in the Dataserv.lg
CAUSE:
Missing sql*net
et8 service name to resolve connection to remote oracle database
FIX:
Add a @ followed by sql*net
et8 service name after the user name on -U parameter of the connection string. For example -U scott@orcl