Re: Startup via SQL Embedded

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 17 Oct 2001 15:02:51 +0100
Message-ID: <3bcd8fa3$0$234$ed9e5944@reading.news.pipex.net>

"Renato Fabiano" <renatofabiano_at_hotmail.com> wrote in message news:2358ca76.0110170529.4cb2eaed_at_posting.google.com...
> Hi,
>
> Some guys have disagreed completely with the possibility of to startup
> an Oracle instance from an user application.

<snip>

> I've done a C program that is able to start the Oracle db instance
> since the user who executed it be a member of "dba" Unix group.
> It uses a system call to "sqlplus".

The c program you show is not starting Oracle via the application though is it really. It is using sqlplus. I don't think that anyone here would object in quite the same terms to the code you post. For example the following works using vb and on a win2k platform. I just tried it

Sub Main()

x = Shell("c:\oracle\ora81\bin\oradim.exe -startup -sid nltest -starttype srvc,inst -intpwd oracle")

End Sub

I do however have a couple of objections.

svrmgrl is desupported so that part of the code shouldn't be included imo.
what happens if your applications site uses password authentication for sysdba operations? what happens if the password changes.

So yes it is *possible* to write a program in c (or presumably in any other language of your choice) to control external progs to start up the Oracle database. However anytime the startup routine changes the program needs recompilation. Surely the tried and tested approach of a shell script is better. 3 & 4GL languages have their place. scripting isn't one of them. Received on Wed Oct 17 2001 - 09:02:51 CDT