Lyuda,
I have exactly these type of environmental files on my NT server. The PATH
on the NT server is altered to include the directory where these files
exist.
I have one file for each database instance on each server.
For example, the listing below is the WTWD.BAT file (representing the WTWD
database). Notice all of the environmental values that will point me to
various DBA directories, as well as RMan common settings.
Because it is a .BAT file, I call it from varois jobs to set the correct
environmental values.
Nothing new here - this stuff has been available in Unix forever. Just
doing the same thing in NT.
Hope this helps.
@rem **************************************************************
@rem File Name : WTWD.BAT
@rem Purpose : This file will establish environmental
@rem variables required for the above named database
@rem instance.
@rem
@rem **************************************************************
@echo off
@SET ORACLE_HOME=C:\Oracle\ora817
@SET RORACLE_HOME=C:\Oracle\ora816
@SET PATH=%roracle_home%\bin;%path%
@SET TMP=C:\TEMP
@SET TEMP=C:\TEMP
@set dbtype=8i
@set dbversion=817
@rem
@rem -------------------------
@rem Rman Settings
@rem -------------------------
@SET RMAN_SID=R816
@set rmanuser=(rman user)
@set rmanpw=(rman password)
@rem
@rem DatabaseFile Settings
@rem
@set rman_DB_Setsize=2220000
@set rman_DISKF='df_%%U_%%t'
@rem
@rem Archivelog Settings
@rem
@set rman_DISKA='al_%%U_%%t'
@set rman_AL_Setsize=20000000
@set rman_AL_Filesperset=100
@rem
@rem Control File Settings
@set rman_CTLF='ctl_%%U_%%t'
@rem
@set rman_blksize=2097152
@rem
@rem -------------------------
@rem Database Settings
@rem -------------------------
@rem
@SET ORACLE_SID=WTWD
@set dba_root=w:\dba
@set dba_home=%dba_root%\%oracle_sid%
@set dba_log=%dba_home%\log
@set dba_temp=%dba_home%\temp
@set dba_scripts=%dba_root%\scripts
@set rmantapes=1
@set paccount=sys
@set pinternal=(sys password)
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, August 20, 2001 4:37 PM
To: Multiple recipients of list ORACLE-L
John, may be it is a dump question.. but...
there are certain directories my variables would go under. Note: I am
declaring custom environmental variables.
How do I address this issue?
-----Original Message-----
Sent: Monday, August 20, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
Simple. Put them in a batch file:
@echo off
set env1 = One
set env2 = Two
set oracle_sid = mydb
...
Then reference like normal
C:\> echo %oracle_sid%
mydb
Jon Walthour
>
> From: [EMAIL PROTECTED]
> Date: 2001/08/20 Mon PM 02:36:36 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: environmental variables
>
> Is there any way to create NT environmental variables through script?
>
> Lyuda Hoska
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
