Home » RDBMS Server » Server Utilities » Run Exp utility in background mode (Oracle,11.2.0.1,Linux)
Run Exp utility in background mode [message #599849] Tue, 29 October 2013 09:08 Go to next message
sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore
Junior Member
Hi All,

I have executed the exp utility to take schema backup as below.

DB_NAME=name
DAY=`date +%a_%d-%m-%Y`
gzip < exp_test_pipe > exp_test_${DAY}.dmp.gz &
exp username@test.cis.cat.com file=exp_test_pipe log=exp_test_dumps.log parfile=export_options.par

more export_options.par
compress=n
statistics=none
CONSISTENT=n
indexes=Y
owner=test
direct=Y

my password is starts with $

example: $12300$ahhh and hence its not allowing me to execute when given like below..

exp username/$12300$ahhh@test.cis.cat.com file=exp_test_pipe log=exp_test_dumps.log parfile=export_options.par

Could you please help me to resolve the issue?
Please revert back if any need any info or query.
Many thanks.
Re: Run Exp utility in background mode [message #599851 is a reply to message #599849] Tue, 29 October 2013 09:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59498
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

exp username/"$12300$ahhh"@test.cis.cat.com ...

Re: Run Exp utility in background mode [message #599852 is a reply to message #599851] Tue, 29 October 2013 09:26 Go to previous messageGo to next message
sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore
Junior Member
Hi Michael,,

I tried the same but it didnt worked.

exp username/"$12300$ahhh"@test.cis.cat.com

EXP-00056: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon denied
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully
Re: Run Exp utility in background mode [message #599854 is a reply to message #599852] Tue, 29 October 2013 09:38 Go to previous message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
>ORA-01017: invalid username/password; logon denied
BELIEVE the error message!
with V11 default is that password is CaSeSenSitiVe
Previous Topic: IMPDP ---- big table's data can't be imported .hope for resolve!!
Next Topic: Intermediate COMMITS when using the sqlldr or imp utilities
Goto Forum:
  


Current Time: Thu Oct 30 12:31:59 CDT 2014

Total time taken to generate the page: 0.13529 seconds