Kbase P212: Error 1461 occurs when ORACLE_HOME is not set
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/08/2003 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)
Schema holder does not match database schema -- file field . (1461)
CAUSE:
The error 1461 is usually reported when there are discrepancies between the schema holder definitions and ORACLE. The DataServer runs a schema check on every table the first time the table is referenced in the session by a program.
However, there are times when no schema descrepencies are present. When this happens, the error can be caused by not setting the ORACLE_HOME environment variable.
FIX:
1. Set ORACLE_HOME environment variable
2. Include $ORACLE_HOME/bin in PATH environment variable.