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
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|