rc.local equivalent to starting an Oracle Instance
From: Tony Jambu <aaj_at_phantom.trl.OZ.AU>
Date: 9 Mar 1995 04:56:19 GMT
Message-ID: <3jm1pj$lbr_at_newsserver.trl.OZ.AU>
Date: 9 Mar 1995 04:56:19 GMT
Message-ID: <3jm1pj$lbr_at_newsserver.trl.OZ.AU>
All Oracle gurus, hackers and Oracle staff
Is there an equivalent of an rc.local or autoexec.bat for the starting of an Oracle instance?
Background:
I need to have scripts run against specific Oracle instances when they startup (shutting down would be nice also). These scripts do things like compile packages, pin packages and tidy up some database objects.
Workaround:
At the moment, I have to call my own utilities to startup and shutdown the
database
and depending on the instance name, carryout certain actions.
Is there an Oracle supported 'feature' like a sql.bsq file or init.ora parameter that is executed when the database starts up? Or any other way?
ta
tony
-- _____ ________ / ___ |Tony Jambu, Database Consultant /_ _ /_ __ / |Wizard Consulting,Aust (ACN 065934778) /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX: +61-3-2536173 \_______/ |Email:TJambu_at_wizard.com.au PHONE: +61-3-2536385Received on Thu Mar 09 1995 - 05:56:19 CET