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