RE: environmental variables

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: lhoska_at_calibresys.com
> Date: 2001/08/20 Mon PM 02:36:36 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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: lhoska_at_calibresys.com
> 
> 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: ListGuru_at_fatcity.com (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: jonw_at_fuse.net

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: ListGuru_at_fatcity.com (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: lhoska_at_calibresys.com

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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us

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: ListGuru_at_fatcity.com (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).