Oracle-L: RE: Dba tools on NT

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 13 Aug 2002 09:54:31 -0800
Message-ID: <F001.004B3344.20020813095431@fatcity.com>

Dan,

You said:
"The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID, $SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus."

You are correct sir! However, you can generate the sql scripts within the NT script and use the environmental within that process. For example:

Within an NT script, I say:

echo spool $SCRIPT_LOG/some_script_file.log > run.sql echo select * from sysdate; >> run.sql
echo exit >> run.sql

sqlplus user/pw @run.sql

The above would interpret the $SCRIPT_LOG environmental correctly. I do the above all the time and it works just fine.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, August 13, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L

I've used MKS Toolkit and Cygwin for shell scripting. My preference is MKS Toolkit for features and it runs as the user you are logged in as (i.e. oracle). Cygwin is free, but it's processes run as the adminstrator. That being said, it could be I did not configure it properly..

The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID, $SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus. Instead of using these variables, I used SQL*Plus native variables populated with a login.sql script. Not a problem. I'm not certain if the same restriction is present in perl, but it is something to keep in mind.

Dan Fink

-----Original Message-----
Sent: Tuesday, August 13, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L

Hello all

We are looking on programming and scripting tools for DBA team on NT.

Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them.

TIA Yechiel Adar
Mehish

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Yechiel Adar
INET: adar76_at_inter.net.il

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: Fink, Dan
INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------