Kbase P79033: Can not perform schema pull on Oracle tables when the user is not properly defined
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/29/2008 |
|
Status: Verified
SYMPTOM(s):
Can not perform schema pull on Oracle tables
Oracle error - 1012 see "Oracle Error Messages and Codes Manual". (1252)
ORA-01012: not logged on
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Oracle DataServer
Used system/password as login when performing schema pull
Can not log in from sqlplus using system/password
Can log in from sqlplus using "Connect system/password as sysdba"
Query all_users table, system account is defined
Instance is local
Both Windows registry and system environment variables has correct ORACLE_HOME and ORACLE_SID set
Fresh new Oracle installation
Progress 8.x
Progress 9.x
OpenEdge 10.x
CAUSE:
The exact cause is unknown at the time of writing, but it seems to be related how system account is set up since can not log in from sqlplus if "as sysdba" is not used
FIX:
1. Log in as system from sqlplus
2. Create different user and grant appropriate privileges
create user test identified by test;
grant resource to test;
grant dba to test;
3. Use the new user to log and perform schema pull