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
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 programs
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
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
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
