RE: backup script
- From: Branimir Petrovic <BranimirP@xxxxxxxx>
- To: "'ora_forum@xxxxxxxxx'" <ora_forum@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 30 Mar 2005 14:09:59 -0500
> -----Original Message-----
> From: George Koroluck [mailto:ora_forum@xxxxxxxxx]
> I'm writing Oracle (on NT) backup script using DOS scripting.
> Script must read location of the ORACLE_HOME from the registry.
> Any ideas?
// ScriptName: MakeSetORACLE_HOME.bat.js
//
// Script will create SetORACLE_HOME.bat file in same dir.
//
// Execute output of this script - SetORACLE_HOME.bat from DOS batch
// script to set ORACLE_HOME env variable in calling script's shell.
var oShell = new ActiveXObject("Wscript.Shell");
var sOraHome = oShell.RegRead("HKLM\\SOFTWARE\\ORACLE\\ORACLE_HOME");
var oFSO = new ActiveXObject("Scripting.FileSystemObject");
var SCRIPTPATH = oFSO.GetParentFolderName(WScript.ScriptFullName);
var sBatFQfN=oFSO.BuildPath(SCRIPTPATH, "SetORACLE_HOME.bat");
var oTxt = oFSO.CreateTextFile(sBatFQfN, true);
oTxt.WriteLine("set ORACLE_HOME=" + sOraHome);
oTxt.Close();
WScript.Quit();
/*
REM -- ScriptName: DOSkludge.bat (saved to same dir as the above *.js)
echo off
MakeSetORACLE_HOME.bat.js
call SetORACLE_HOME.bat
del SetORACLE_HOME.bat
echo %ORACLE_HOME%
pause
:: Due to sheer nonsense, *.js or *.vbs or *.wsf script called from
:: within DOS batch script can not set and pass environment variable
:: back to "parent" (calling) DOS batch. Instead, the above kludge
:: is "must do".
::
:: In other words, high time to re-evaluate needs for DOS batch-ing...
::
:: Good luck,
::
:: Branimir
*/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
