Re: Startup via SQL Embedded

"Renato Fabiano" <renatofabiano_at_hotmail.com> wrote in message news:2358ca76.0110161200.48f5423d_at_posting.google.com...
> > > Hi guys,
> > >
> > > I want to know if it is possible to start an Oracle db instance
> > > via an C application (Pro*C), without using a "system()" call
> > > to "svrmgrl".
> > <snip>
> >
> ...
>
> > Your application will need a dba right?
>
> In order to startup an Oracle instance an user must have
> the Oracle DBA role; or to be part of O.S. group named "dba",
> to perform an 'connect internal'.
> My application can have this permissions.
>
> > That person will be able to startup both your app and the database?
>
> Yes, if it was possible to start the database instance from the
> application, the application would start the Oracle instance too.
>
> > Indeed they will be able to script that using cron or whatever.
>
> I've configured my Oracle db instance to start automatically during
> Solaris boot using script "/etc/init.d/dbora".
>
> Moreover, I want to ensure that when the application is started,
> it looks for an active Oracle instance and, if there isn't,
> it attempts to startup a new instance.
>
> > Why on earth is that not acceptable?
>
> Actually, It's acceptable.
>
> I just want to know if there is another way to start db instance,
> mainly via a Pro*C program, without using sqlplus or svrmgrl. Is there?
>
> Thanks,
>
> Renato Fabiano

There is NOT and that is GOOD
You have been explained there are *more than enough* reasons not to allow this. Why do you think you know better?
Hopefully you don't sell this application.

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 16 2001 - 17:00:47 CDT