RE: OT- Start a process after oracle on Win 2K
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 it starting a head of Oracle. Haven't tried above myself but as with lots of MS stuff the theory is there ;) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] From: [EMAIL PROTECTED] Date: Tue, 1 Apr 2003 22:28:28 +1000 Subject: OT- Start a process after oracle on Win 2K 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? This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: O'Neill, Sean 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).
OT- Start a process after oracle on Win 2K
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 -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Re: OT- Start a process after oracle on Win 2K
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 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 -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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).
RE: OT- Start a process after oracle on Win 2K
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).
RE: OT- Start a process after oracle on Win 2K
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/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, April 01, 2003 5:39 AM To: Multiple recipients of list ORACLE-L 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 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 -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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).
Re: OT- Start a process after oracle on Win 2K
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 of scripts and I would envisage running them as a batch file What is best? If you have Active Directory just set it up in the GPO for the machine to run at startup. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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).