RE: closing DB on NT with a scheduled BATCH FILE

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Thu, 09 Aug 2001 00:23:10 -0700
Message-ID: <F001.00365748.20010809003030@fatcity.com>

Jared,

Just out of curiosity I am asking ( May be I am missing something)....

How does it matter whether the command file is on C drive or D/E (other) drives?

Some other things I would suggest is 1. Generate a logfile for every command file (including one in schedular) for example on schedular you type the command as:

c:\backup\startorcl.bat >> c:\backup\startorcl.log

and not just

c:\backup\startorcl.bat

2. Define the environment variables (ORACLE_SID , ORACLE_HOME etc) in bat file and provide the full path of commands e.g.

SET ORACLE_SID=ORCL
d:\orant\816\bin\svrmgrl.exe "connect internal/pass" <h:\backup\shut1supp.sql >>h:\backup\logs\shut1supp.log

3. Use some GUI version of Schedular e.g. WINAT or NT's native schedular.

If you need any more assistance do get back..

Regards,
Rajesh

-----Original Message-----
Jared.Still_at_radisys.com
Sent: Thursday, August 09, 2001 4:45 AM
To: Multiple recipients of list ORACLE-L

Because you are running this in the AT scheduler, it is not executing with the same permissions.

I'll bet that your batch script it not on the C: drive.

Put it on the C: drive and see if it works.

Jared

                    "Bunyamin K.

                    Karadeniz"              To:     Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <bunyamink_at_havels       cc:

                    an.com.tr>              Subject:     closing DB on
NT with a scheduled BATCH FILE                  
                    Sent by:

                    root_at_fatcity.com

 

 

                    08/08/01 06:15 AM

                    Please respond to

                    ORACLE-L

Dear Gurus , I have a question , In fact I wonder if it is a bug of NT .

I want to close and reopen database with a .BAT file . When I execute the .bat file directly it executes correctly . But When I
execute it with a schedule with AT command then it connects but does not close database.

How can I handle That. ?
What do you do when you want to schedule startups and shutdowns of database
on NT?

Thank you

--

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

Author:
INET: Jared.Still_at_radisys.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: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com

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