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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Executing exp as batch job fails

Re: Executing exp as batch job fails

From: <sybrandb_at_yahoo.com>
Date: 25 Nov 2005 00:52:13 -0800
Message-ID: <1132908733.819794.7160@g14g2000cwa.googlegroups.com>


You have multiple tnsnames.ora floating around, one of them is incorrect, you didn't set the TNS_ADMIN variable, and your DOS box is hitting the wrong one, as that one is the one in the %ORACLE_HOME% it finds (you have multiple ORACLE_HOMEs). Happens so often. Consequently your assertion problems in the tnsnames.ora can be ruled out, is incorrect, the PATH in your interactive session can differ from the PATH in your cmd file.
You also shouldn't use this syntax, as it will use the TCP/IP protocol, instead of Bequeath.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Nov 25 2005 - 02:52:13 CST

Original text of this message

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