Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> export errors

export errors

From: Tom Sterin <sterin_at_telocity.com>
Date: Mon, 19 Aug 2002 10:42:58 -0400
Message-ID: <3d610305_4@nopics.sjc>


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

LOGNAME=oracle
LD_LIBRARY_PATH=/usr/src/Mesa-3.0/lib:/opt/app/oracle/product/8.1.6/lib HOME=/home/oracle
ORAENV_ASK=NO The message file seems to be intact. I can look at the file or do this:

/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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US