RE: backup script

> -----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
*/
--
http://www.freelists.org/webpage/oracle-l

Other related posts: