Since I've got no experience with OCI and not much play time right now I'm going to ask this question. Can you execute a command line shell script using OCI? If so there is no reason you cannot invoke sqlplus and startup or shutdown an Oracle database.
Kevin
Jared Still wrote:
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
