RE: OT- Start a process after oracle on Win 2K

2003-04-03 Thread O'Neill, Sean
Peter, An option you might want to investigate writing your script command file, using the W2K resource kit utility, (can't think of it's name right now, to convert it to a service. Set service to startup automatically and then create a dependency on Oracle service for this new service to prevent

Re: OT- Start a process after oracle on Win 2K

2003-04-01 Thread Chris Berry
From: [EMAIL PROTECTED] 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

RE: OT- Start a process after oracle on Win 2K

2003-04-01 Thread Pardee, Roy E
One other way to go would be to use a system startup script (see http://support.microsoft.com/default.aspx?scid=kb;en-us;198642 for details) that first started your db, and then followed up w/whatever other scripted tasks were necessary. Theoretically, anyway... HTH, -Roy Roy Pardee Programmer/

RE: OT- Start a process after oracle on Win 2K

2003-04-01 Thread Stephane Faroult
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 progra

Re: OT- Start a process after oracle on Win 2K

2003-04-01 Thread Richard Foote
Hi Peter, Sounds like a job for an after startup database event trigger (check out CREATE TRIGGER doco). Cheers Richard - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 01, 2003 10:28 PM > Hi > Slightly OT > I have a couple of pr