OraFAQ Forum: Server Utilities » exp error EXP:0000

Home » RDBMS Server » Server Utilities » exp error EXP:0000 (Oracle-10.2 / Linux )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp error EXP:0000 [message #420325]

Fri, 28 August 2009 05:44

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

Report message to a moderator

Re: exp error EXP:0000 [message #420329 is a reply to message #420325]

Fri, 28 August 2009 06:03

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: exp error EXP:0000 [message #420338 is a reply to message #420325]

Fri, 28 August 2009 07:30

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

Report message to a moderator

Re: exp error EXP:0000 [message #420350 is a reply to message #420338]

Fri, 28 August 2009 08:51

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: exp error EXP:0000 [message #420351 is a reply to message #420325]

Fri, 28 August 2009 09:05

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

Report message to a moderator

Re: exp error EXP:0000 [message #420353 is a reply to message #420351]

Fri, 28 August 2009 09:11

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: exp error EXP:0000 [message #420354 is a reply to message #420325]

Fri, 28 August 2009 09:26

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

Report message to a moderator

Re: exp error EXP:0000 [message #420356 is a reply to message #420325]

Fri, 28 August 2009 09:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from following

env | sort

Report message to a moderator

Re: exp error EXP:0000 [message #420358 is a reply to message #420354]

Fri, 28 August 2009 09:43

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: exp error EXP:0000 [message #420376 is a reply to message #420354]

Fri, 28 August 2009 13:19

joy_division
Messages: 4963
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:08:43 CDT 2024