Edit D:\app\Administrator\product\11.2.0\dbhome_1\mgw\admin\mgwpatch.sql
Rem Rem $Header: mgwpatch.sql 13-jul-2006.10:06:56 chall Exp $ Rem Rem mgwpatch.sql Rem Rem Copyright (c) 2002, 2006, Oracle. All rights reserved. Rem Rem NAME Rem mgwpatch.sql - MGW patch script Rem Rem DESCRIPTION Rem This patch script is used to apply bug fixes. It is run in the Rem context of catpatch.sql, after the RDBMS catalog.sql and Rem catproc.sql are run. It is run with a special EVENT set which Rem causes CREATE OR REPLACE statements to only recompile objects if Rem the new source is different from the source stored in the database. Rem Rem NOTES Rem This script must be run AS SYSDBA. Rem Rem MODIFIED (MM/DD/YY) Rem chall 07/13/06 - replace shutdown trigger Rem chall 06/21/06 - fix comments Rem chall 06/15/06 - use RDBMS version for MGW component version; Rem load all package specs Rem chall 11/26/02 - call dbms_registry.check_server_instance Rem chall 11/05/02 - chall_bug-2606429 Rem chall 10/29/02 - Created Rem Rem ========================================================================== whenever sqlerror exit execute dbms_registry.check_server_instance whenever sqlerror continue -- specify the validate routine, just in case it changed execute - dbms_registry.loading('MGW', 'Messaging Gateway', 'mgwi_reg.validate_mgw') Rem Patch Work Rem Rem Below is slimmed down version of mgwlod.sql and should be sufficient for Rem most MGW patches but may need to be altered depending on requirements of Rem a given patch. Alternate is to just run mgwlod.sql which is likely okay Rem for MGW, but note that mgwlod.sql does _not_ load private type specs Rem which may be needed for a given patch. Rem Rem Below currently excludes: Rem public/private type specs, table modifications, AQ log/notify queues, Rem Scheduler objects Rem -- package specs @@mgwmsg @@mgwadm @@mgwnfy.plb @@mgwaqd.plb @@mgwiadm.plb -- views @@mgwview -- type and package bodies @@mgwtypeb.plb @@mgwityb.plb @@mgwmsgb.plb @@mgwadmb.plb @@mgwnfyb.plb @@mgwaqdb.plb @@mgwiadmb.plb @@mgwireg.plb -- database SHUTDOWN trigger create or replace trigger mgw_dbshutdown_trig before shutdown on database call mgwi_admin.db_shutdown_trigger / execute dbms_registry.loaded('MGW') execute mgwi_reg.validate_mgw Rem === End file: mgwpatch.sql ===============================================
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de