Home » RDBMS Server » Server Utilities » exp error EXP:0000 (Oracle-10.2 / Linux )
exp error EXP:0000 [message #420325] Fri, 28 August 2009 05:44 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
I am getting this error EXP:0000. How to set oracle_home in linux

oracle_sid=orcl
oracle_home=/dbusr1/oracle/app/product/10.2.0/client;
path=$oracle_home/bin:$path; export path
ld_library_path=$oracle_home/lib:$ld_library_path; export ld_library_path
NLS_LANG=AMERICAN_AMERICA.AL32UTF8;export NLS_LANG

[abc@dev114 bin]pwd
/dbusr1/oracle/app/product/10.2.0/client/bin

[abc@dev114 bin]$ exp
-bash: exp: command not found

[abc@dev114 bin]$ ./exp

Message 206 not found; No message file for product=RDBMS, facility=EXP: Release 10.2.0.1.0 - Production on Fri Aug 28 05:53:03 2009

Copyright (c) 1982, 2005, Orac

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

Thanks in advance
Re: exp error EXP:0000 [message #420329 is a reply to message #420325] Fri, 28 August 2009 06:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First thingie that caught my eyes is your "style" of scripting.
oracle_sid
oracle_home

Always use uppercase for ENV variables. It could drive folks crazy.
Did you install oracle specifically under
/dbusr1/oracle/app/product/10.2.0/client ?

Else usually, it is supposed be under
/dbusr1/oracle/app/product/10.2.0/bin
Set your ORACLE_HOME and PATH properly and try again.

If above would not work,
Are you logged in as Oracle?
Check your perms.
Re: exp error EXP:0000 [message #420338 is a reply to message #420325] Fri, 28 August 2009 07:30 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
yes, I tried with this, still I am getting the same error
1)Bin folder exist under /dbusr1/oracle/app/product/10.2.0/client
2)I am not logged in as oracle user, but bin folder has the following privilege
-rwx--x--x
so that all (user/group/others) having execute privilege.
3)what all r the other things I have to check ?


ORACLE_SID=orcl; export ORACLE_SID
ORACLE_HOME=/dbusr1/oracle/app/product/10.2.0/client; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
NLS_LANG=AMERICAN_AMERICA.AL32UTF8;export NLS_LANG

Thanks in advance

Re: exp error EXP:0000 [message #420350 is a reply to message #420338] Fri, 28 August 2009 08:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>1)Bin folder exist under /dbusr1/oracle/app/product/10.2.0/client
Does the tool exp or imp exist in the said directory?

Re: exp error EXP:0000 [message #420351 is a reply to message #420325] Fri, 28 August 2009 09:05 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
>> Yes exp,imp, expdp and impdb all
exist in .../10.2.0/client/bin folder
Re: exp error EXP:0000 [message #420353 is a reply to message #420351] Fri, 28 August 2009 09:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
copy and post the exact.Verbatim. Do an echo on $ORACLE_HOME. Goto $ORACLE_HOME/bin and do an exp.
Re: exp error EXP:0000 [message #420354 is a reply to message #420325] Fri, 28 August 2009 09:26 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
[abc@dev114 ~]$ echo $ORACLE_SID
orcl

[abc@dev114 ~]$ echo $ORACLE_HOME
/dbusr1/oracle/app/product/10.2.0/client

[abc@dev ~]$ cd /dbusr1/oracle/app/product/10.2.0/client/bin

[abc@dev114 bin]$ pwd
/dbusr1/oracle/app/product/10.2.0/client/bin

[abc@dev114 bin]$ exp
Message 206 not found; No message file for product=RDBMS, facility=EXP:
Release 10.2.0.1.0 - Production on Fri Aug 28 10:15:27 2009

Copyright (c) 1982, 2005, Orac

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

Note : I tried with ./exp & exp help=y I am getting the same error

Re: exp error EXP:0000 [message #420356 is a reply to message #420325] Fri, 28 August 2009 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
post results from following

env | sort
Re: exp error EXP:0000 [message #420358 is a reply to message #420354] Fri, 28 August 2009 09:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
See if you can reproduce the error Logged in as Oracle.
Else,
I suspect it is a known bug. Look into patch 4516865 and see if it is applicable to you.
I have seen this myself with invoking sql*plus ( for non-oracle users) but not with exp / imp.
Meanwhile can you invoke sql*plus?
Seems mesg directory has issues.
or
I failed to see something very basic Wink
Re: exp error EXP:0000 [message #420376 is a reply to message #420354] Fri, 28 August 2009 13:19 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Get a full environment like BlackSwan said, but do it of both current user and oracle user and see what differs.

Then also check that you have oraus.* in the rdbms/mesg directory under $ORACLE_HOME, and the rights on rdbms and mesg.
Previous Topic: loading huge xml file data to oracle table using sql loader
Next Topic: i got ??? when i import from oracle database 8 inside the table
Goto Forum:
  


Current Time: Wed Dec 07 06:41:42 CST 2016

Total time taken to generate the page: 0.11405 seconds