Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> export errors
I am running Oracle 8.1.6 on RedHat Linux. When I try to do an export, I
get the following:
/opt/app/oracle:> exp user/pass
Message 206 not found; No message file for product=RDBMS, facility=EXP: Release 8.1.6.1.0 - Production on Mon Aug 19 10:23:59 2002
(c) Copyright 1999 Oracle Corpo
Invalid format of Export utility name
Verify that ORACLE_HOME is properly set
Export terminated unsuccessfully
EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP
I have seen many other postings with this same problem, and the common answer is "check ORACLE_HOME". Here are the environment variables which have all been exported:
/opt/app/oracle/product/8.1.6/bin:> env | grep -i ora
PATH=/usr/local/bin:/usr/kerberos/bin:/bin:/usr/bin:/usr/local/bin:
/usr/bin/X11:/usr/X11R6/bin:/opt/app/oracle/product/8.1.6/bin:
/opt/jdk1.2.2/bin
ORACLE_BASE=/opt/app/oracle ORACLE_HOME=/opt/app/oracle/product/8.1.6 ORACLE_BIN=/opt/app/oracle/product/8.1.6/bin ORACLE_SID=db2
/opt/app/oracle/product/8.1.6/bin:> oerr exp 206
00206, 00000, "Export"
// UI[207,273]
I also get the "No message file" error for ORA errors. For example, in sqlplus:
SQL> select * from abc;
select * from abc
*
ERROR at line 1:
ORA-00942: Message 942 not found; No message file for product=RDBMS,
facility=ORA
and yet I can do this:
/opt/app/oracle:> oerr ora 942
00942, 00000, "table or view does not exist"
// *Cause:
// *Action:
Any thoughts? Thanks in advance.
Tom Received on Mon Aug 19 2002 - 09:42:58 CDT