Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Oracle Shell Scripting - This article presents some some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN.



William Robertson said...

Possibly the title "Oracle Shell Scripting" might lead some people to expect an article about shell scripting around Oracle in general as a tool for application development (which, as I'm always ranting on about, I believe to be bad and wrong) rather than RMAN specifically, for which it is well suited.

Márcio said...

Very good.....thanks

Lori said...

The examples were simple and clear. Excellent. Thank you.

Fer said...

Good example..thanks

rash said...

simple and to the point...thanx..:).

Tugg said...

Great information...it was a big help. Finding this sooner would have saved me a couple early morning hours.

varun dhawan said...

Awsome !!
among dozen of other webpages, only this page has helped my in resolving my issue.

Truely ROCKING !!

Ranbir Kaur said...

Perfect! Helped me alot to take hot/cold backup...thanx alot!

Tony said...

Thank you for your good work at oracle-base.com, it is very helpful.

There is a way to redirect a SQL script from a Windows CLI script without using a stored SQL script. The caret sign '^' is used as ESCape character. I'm referring to following example I've posted on OTN forum:


set ORACLE_SID=ORCL
(
echo WHENEVER SQLERROR EXIT SQL.SQLCODE failure rollback
echo connect / as sysdba
echo spool redirect_conTEXT_logfile_%ORACLE_SID%.log
echo set lines 140 pages 50 trimspool on
echo col par_name format a35
echo col par_value format a45
echo prompt *** Current Oracle Text ^^^(CONTEXT^^^) LOG directory ***;
echo prompt;
echo SELECT par_value, par_name FROM ctx_parameters
echo WHERE par_name='LOG_DIRECTORY';
echo prompt execute ctxsys.CTX_ADM.SET_PARAMETER ^^^('LOG_DIRECTORY', -
echo 'F:\oracle\admin\%ORACLE_SID%\context\log'^^^);
echo prompt *** NEW Oracle Text LOG directory ***;
echo prompt;
echo SELECT par_value, par_name FROM ctx_parameters
echo WHERE par_name='LOG_DIRECTORY';
echo spool off
echo exit
) | sqlplus /nolog
echo %ERRORLEVEL%

Lawrence cumber said...

Very Direct. That was a very good example.

anandkarya said...

It is very nice and helpful for all the learner and new in oracle industry. I appreciate you for this.

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)