Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Automatically execute SQL-script at instance startup?
In UNIX, there are the DBSTART and DBSHUT scripts that execute automatically at startup/shutdown as long as you set it that way in the /etc/oratab file. Then, a file can also be used to run these same scripts when you shut the database down, also. If these exist on Workgroup server, then you should be OK.
Alan V.
Anders.Malmberg_at_telelarm.se wrote in message
<6dj3l6$j1e$1_at_nnrp1.dejanews.com>...
>Hello,
>to cope with ORA-04031 I want to automatically execute a script that pins
>a bunch of packages at instance startup. My script should of course run
both
>at system boot and when the instance is started manually. Can this be done?
>How? I'm using Oracle Workgroup Server 7.2 and Windows NT 4.
>
>Thanks,
>Anders Malmberg
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed Mar 04 1998 - 00:00:00 CST