Kbase P27018: Error Ora -1012 with Oracle 9i
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
HP-UX 11.0
Progress 9.1D
Oracle 9i
SYMPTOM(s):
Oracle 9.0.1.4.0 and Progress 64 bit versions
ORACLE error -1012 see "ORACLE Error Messages and Codes Manual". (1252)
DataServer log file shows:
The server could not open the foreign database. (1891)
The executables _progres, orasrv are owned by root and have the correct permission 4755
ORACLE_SID is set correctly
ORASOPATHNAME is set correctly to $ORACLE_HOME/lib/libclntsh.sl
NLS_LANG=AMERICAN_AMERICA.AL16UTF16
With that NLS_LANG setting, sqlplus
olog fails with errors:
SP2-0135:SP2-0642:P2-0642:P2-0642:Memory fault(coredump)
CAUSE:
NLS_LANG=AMERICAN_AMERICA.AL16UTF16 not supported by Oracle 9i for Clients.
FIX:
Change environment variable NLS_LANG to a value supported by Oracle 9i
(NLS_LANG=AMERICAN_AMERICA.UTF8 for example).