If you want no user to log in, you may wish to start your database in restricted mode (and use an account which has the appropriate privilege to log into Oracle if you have to). The snag is that you have to issue an ALTER DATABASE once your job is done. Another solution, assuming that your programs run on the server and all users connect from elsewhere, is to run your programs after the database has been started but before the listener is.
'local run key in the registry' is Greek to me ... :-) Regards, Stephane Faroult Oriole >----- ------- Original Message ------- ----- >From: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Tue, 01 Apr 2003 04:28:36 > >Hi >Slightly OT >I have a couple of programs that need to be run >after Oracle has started >and want to run them without a user logging in. >The likely place seems to be in the scheduled tasks >running at startup or >as a program under the local run key in the >registry. > >The processes are a couple of scripts and I would >envisage running them as >a batch file >What is best? > >Cheers > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
