Re: Oracle On Windows Question

I'd probably go with Grid Control/EM for this - I'm a big advocate of using it across entire Oracle estates. You could
also argue with the vendor that the agent install is part of the oracle install. It would make your life easier as you wouldn't have to pollute your mind with Windows :) Obviously this may mean extra licensing and business change, so might not be an option.

Having worked for a vendor that had the same stance, albeit on the HPUX/Solaris side of things, I understand the situation you're in. I also realise that the support contracts are mostly non-negotiable & you have no choice in the matter.

Not sure there's much else you can do otherwise. If you don't have access to the box and only have DB access maybe use DBMS_SCHEDULER which can be used to execute things (cmd.exe or powershell will be your friend) on the DB host. Probably the best route to go down.

Cheers,

Phil

On 10 Nov 2011, at 19:41, Scott Canaan <srcdco_at_rit.edu> wrote:

> Currently, we are not being given access to the Windows server, so we have to be able to access the data from within Oracle.> > Normally, I agree with you and I've told many vendors that it isn't important where the database is as long as they can connect to it. This vendor flat out says that if we don't put it on windows, they won't support us. They did say that we could move it to Linux after the install as long as we move it back to Windows for any support or upgrade.> > Scott Canaan '88 (srcdco_at_rit.edu)> (585) 475-7886 - work (585) 339-8659 - cell> "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.> > -----Original Message-----> From: D'Hooge Freek [mailto:Freek.DHooge_at_uptime.be] > Sent: Thursday, November 10, 2011 2:40 PM> To: Scott Canaan; oracle-l_at_freelists.org> Subject: RE: Oracle On Windows Question> > If the application software is not placed on the same server as the database, the vendor has 0 to say about the database platform.> > Now, back to your question :-)> > What do you mean about "without having direct access to the windows server".> Do you mean you can't use os scripts, or that it must be scheduled from within oracle?> > > Regards,> > > Freek D'Hooge> Uptime> Oracle Database Administrator> email: freek.dhooge_at_uptime.be> tel +32(0)3 451 23 82> http://www.uptime.be> disclaimer: www.uptime.be/disclaimer> > -----Original Message-----> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan> Sent: donderdag 10 november 2011 20:31> To: oracle-l_at_freelists.org> Subject: Oracle On Windows Question> > All,> Here are some particulars:> Oracle 11.2.0.1> Windows 2008 Server> We normally don't run Oracle on Windows, but one vendor insists that the Oracle database must be on windows. In our Unix / Linux environment, we monitor many things, including free physical disk space. Without having direct access to the Windows server, is there anything within Oracle that can return the disk size and space used?> > Thank you,> > Scott Canaan '88 (srcdco_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>)> (585) 475-7886 - work> "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.> > > --> http://www.freelists.org/webpage/oracle-l> > > --> http://www.freelists.org/webpage/oracle-l> >