If on Win32, you can just shutdown the service, which you can do directly from Perl ( forget exactly which module at the moment )
This is one of those rare instances where something is simpler to do on Win32 that on *nix. Jared On Tue, 2003-11-11 at 06:41, Gold, Samuel (Contractor) wrote: > I have called oracle and ask them if they would provide the shutdown > functionality in OCI and there answer was no. The reason they gave was: > "OCI does not provide the functionality to start and stop the database. > Doing so requires access to a lower level API which is not exposed to OCI." > > That is from Oracle. Hope that helps. > > -----Original Message----- > From: Jared Still [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 11, 2003 1:49 AM > To: Kevin Moore > Cc: [EMAIL PROTECTED] > Subject: Re: Oracle dbi ? > > > The problem is, these aren't actually SQL commands. > > Rather, these are SQL*Plus commands. The DBD::Oracle > doesn't know what to do with these. > > If you could figure out how to do this with OCI, then > you could probably patch DBD::Oracle to provide this > functionality. > > Tim would appreciate that patch when you're done. :) > > Jared > > On Tue, 2003-11-04 at 07:03, Kevin Moore wrote: > > What user are you conneted as when you try to shut down the database? > > I've used shutdown, shutdown imediate, and in worst cases shutdown abort > > to stop an Oracle database. This has been the method (sql> ) from 8i > > forward. > > > > Kevin > > > > [EMAIL PROTECTED] wrote: > > > > >Since shutdown is not a sql command, has anyone figured out how to > > >shutdown a 8.1.7 or higher database > > >When you connect with: > > >$dbh=DBI->connect($tns,$connect,'',{ ora_session_mode => 2}) > > > > > >Mike Bacovcin > > >Unix and Database administrator > > >Ch2mhill > > >[EMAIL PROTECTED] > > >720.286.2038 > > > > > > > > > > > > > > > > > > > >
