A
A
Alexey M.2015-05-20 10:56:48
Oracle
Alexey M., 2015-05-20 10:56:48

How to access Oracle from the command line?

Good afternoon!
Tell me, please, how to make an oracle backup from the client using the command line?
I have the following now:

set nls_lang=russian_cis.ru8pc866
md \\Srv01\BACKUPORA\%date:~6.4%_%date:~3.2%_%date:~0.2%
\\Srv01\BIN\exp.EXE USERID= SCOTT/[email protected]//Srv01:1521/orcl FULL=Y FILE=\\Srv01\BACKUPORA\%date:~6.4%_%date:~3.2%_%date:~0.2%\full .dat LOG=\\Srv01\BACKUPORA\%date:~6.4%_%date:~3.2%_%date:~0.2%\full.LOG

But this approach does not work, but it is very necessary ...
Writes the following error:
Invalid format of Export utility name

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey M., 2015-05-20
@lnl

Got it! Registered ORACLE_HOME and ORACLE_SID on the shared read-only folder and everything took off. True, I had to tweak the batch file a little:

set nls_lang=russian_cis.ru8pc866
md \\Srv01\BACKUPORA\%date:~6.4%_%date:~3.2%_%date:~0.2%
\\Srv01\BIN\exp.EXE USERID= SCOTT/[email protected] FULL=Y FILE=\\Srv01\BACKUPORA\%date:~6.4%_%date:~3.2%_%date:~0.2%\full.dat LOG=\\ Srv01\BACKUPORA\%date:~6.4%_%date:~3.2%_%date:~0.2%\full.LOG
Dropped the hostname.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question