Kbase P44040: Oracle error -1012 ** not logged on when migrating Progress
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/26/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows 2000
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Oracle 9i
SYMPTOM(s):
Oracle error -1012 ** not logged on when migrating Progress to Oracle (PROTOORA)
ORACLE error -1012 see "ORACLE Error Messages and Codes Manual". (1252)
** not logged on
Failed to connect to ORACLE database . (1451)
CAUSE:
The user specified for ORACLE Owner's Username has to be a valid Oracle user. If this user isn't defined under Oracle, then the conversion will fail.
FIX:
Ensure that the user is defined under Oracle, e.g. through SQL Plus.
If for instance supervisor should be the owner, then -
create user supervisor identified by supervisor;
grant dba to supervisor;
commit;