Re: how to shutdown immediate in Pro*C

From: Laurenz Albe <invite@xxxxxxxxxxxxxxx>
Date: 28 Apr 2006 13:33:42 GMT

sl <susanzlam@xxxxxxxxx> wrote:

I would like to call 'shutdown immediate' in my proc program but I
could not figure how to do it. Tried calling it using EXEC SQL but it
failed with
"ORA-00900: invalid SQL statement".

You cannot do this with embedded SQL.

SHUTDOWN is not an SQL command, it is an SQL*Plus command.

To shutdown an Oracle database from C, use the OCI interface.

Yours,
Laurenz Albe
.

References:
- how to shutdown immediate in Pro*C
  - From: sl

Prev by Date: how to shutdown immediate in Pro*C
Next by Date: Re: Table stats in 10.2
Previous by thread: how to shutdown immediate in Pro*C
Index(es):
- Date
- Thread

Relevant Pages

Re: MSDE OSQL Shutdown
... > die MSDE soll jeden Tag über eine externe Software ... dazu führe ich per Batch ein SQl ... > soll der shutdown solange warten bis die Umstellung ... Dort müsstest du die abzuwartende Aufgabe ...
(microsoft.public.de.sqlserver)
MSDE OSQL Shutdown
... die MSDE soll jeden Tag über eine externe Software ... dazu führe ich per Batch ein SQl ... soll der shutdown solange warten bis die Umstellung ... Das Sql Skript: ...
(microsoft.public.de.sqlserver)
Re: SQL 2005 Cluster shutdown automation
... It is possible to script this using SQL DMO/SMO and Windows WMI objects, but I prefer to use a manual checklist. ... there is no chance of an accidental shutdown on the cluster. ... Plus, I like independent verrification when I bring a cluster back up from a cold start that everything works, so I add verification steps to the startup checklist. ...
(microsoft.public.sqlserver.clustering)
Re: So to Remove!
... frustration more than anything else): ... Shutdown and restarted, ... I say this because when I tried removing SQL, I noticed that my NIC bandwidth ramped up to almost 100 percent usage - RX/TX was around 91%. ... what I meant by spending $$$ on SQL was the SQL expert that was contracted to come in to install and setup this server up. ...
(microsoft.public.sqlserver.server)
Re: Server Memory Stats are they OK ??
... That is a very old recomendation and really only needed if you want a full memory dump. ... If you enable the mini dump the swap file can be 4GB or less without any issues as long as SQL Server is the only real app on the box. ... > This shutdown may happen twice in the same week....but then may not> happen ...
(microsoft.public.sqlserver.setup)