Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\pp_db\latest\deploymentProcs

Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\pp_db\latest\deploymentProcs_sql\PatchRACSADBRolling.sql

REM############################################################################
REM
REM Copyright (c) 2002, 2003, Oracle Corporation.  All rights reserved.
REM
REM
REM PRODUCT
REM     Oracle Enterprise Manager
REM
REM THIS FILE IS MACHINE GENERATED. DO NOT EDIT!
REM
REM DEPLOYMENT PROCEDURE SQL FOR DEPLOYMENT PROCEDURE : 
REM
REM#############################################################################

BEGIN
  DECLARE
    l_dp_version MGMT_PAF_PROCEDURES.VERSION%TYPE;
    l_data_guid MGMT_PAF_TEXTUAL_DATA.DATA_GUID%TYPE;
    l_guid MGMT_PAF_PROCEDURES.PROCEDURE_GUID%TYPE;
  BEGIN

l_guid := '00E2E1C749014031E040578C11011B17';
    SELECT version INTO l_dp_version
    FROM MGMT_PAF_PROCEDURES
    WHERE PROCEDURE_GUID = l_guid;
  EXCEPTION WHEN NO_DATA_FOUND THEN

SELECT SYS_GUID() into l_data_guid from dual;

INSERT INTO MGMT_PAF_TEXTUAL_DATA
    ( DATA_GUID , DATA_SIZE , ENCODING 
, DATA0)
    VALUES(
      l_data_guid,
      0,
      'Base64',
-- data0
'UEsDBBQACAAIAPcVZTwAAAAAAAAAAAAAAAABAAAAeu0ba1PbSPI7v2JOy55xVWIbEl4JsOeHAO8a7LMEe6
m6OpUsjbF2JY2YkSAu4vz27Rk9LMvyQ4ZNcqlAFZZnpnu6e/qt4eSXj46NHjBlFnHRKSrtVmolhF2DmJZ7
xwdu1PPXR6Vfzk48SgxsBhTHy08lWCwhg2Ldx2ZjfCp1+/VmR5YQppTQK2LiU4n5xJOQP/bguaf7xqhLdc
PGrYZChv6jTrGE7gLLPJVqNXlP3m0evj2u7b6tvdmVa29r+4dHzd3d2u5uY/dQQrbO/BvP5JvB1nsHh4dH
B7WDwzdH+xIyMTOo5fmCrF6/pfW7nU77+kJryUqzLyFXdzgBdbV5qQGRWqsRr5AQSMBlp9LI97131erj42
OFCBorBnGqnj6sAucPFucYRFI34ZHQ/1x1pLOTEdZNTCPksLLi6Y505g1o4J5Uw8nMIubrdxwLyEw6+xk7
pkYJ8X+uylcKzOAFUBw1C0winfG/i1BjP/A07D5IZ1vOGG0Ds5eK3ONn+K70HomfnxCcwQgx7OlU9wlFDz
qtoIBhEw2wTR4rWz8hi8mO5493/mn7733M/LMyDPYBOXUZ8mmAkTUEOBsekiUAhDCH4gh6NtYZRiZBLvGR
A5o0HCN/BEtYMKAk8C0XV7bgOdlqu4y2nrY4gUD4zjZHWQa6/6W9D4lmPuXa6BNkjLDxp1gpVnHmSpyenX
+YeAh4zXC8/H4rhPzdck3yyBDF94FFMUM60BUMbPz6PiCgSDHqIcjC0xnjz25g24gLyME+aLrARAX/EW0I
3yNJKqNPn9ID/4Xf7GCpBJRMQCa6aXZa/ESEWK/l37XwqxBu3TRBPiAxoNCAUxkj3RcDAwzKwrUOkSHqtL
ROu9Gv9z9oHLKYpKf7b5fTonbxo2abHihFJPB4ajuzHcxuy9e3T6XMeGkSgvAzSI4zs6ZcFkvCbcXZLUKe
xjgRf7HN8Eroz4h93vnfp+2nSOcn5e2nKWeTnenEp+3y5+m3z3fvV2JNwyaPgCWGDclcIBtgTJohJYXiKb
N6InFVmZ4qHBnS3bGwWIbGJECPFhtxI+Az8ME1JEs0gMvug0WJ62DXR7c6tXTQdqSDSozIoxub+VQfpJB0
+arV73bV0qRqWwMJtHb5ijd7fM3W1BWZ2LC5TwEvyc5OfJ3eYb9jgRWErn9EmC8hywWDerDw46kEHlYDV6
4PgFURQ0yg19JtNbV8xqlzr61eqMCuomrn3b522VVUJfbsHKCBwVJEjMEmOOeHiHc2fURAI2MhxB/6g16x
dfeuoggXEGOyWIcYui1Vi4L1sQMehcMt4H6eSQdnmMwweCWnGHTwyzAIwe2S71yQQVUw1VX4t6KwFHu2Ds
mDiHEtixYWrgtx0zUwK7yxbrQG1xtQ7ELysgmcOWhvSqs5UNqtwlA6czbeMdTT2zCbKwpsg3pjF2A5YDWl
i9Wp+i+ZWO0hFhnNnGfgRiOcgbCaVrsvN9X2rTyb+nG4c0KbASSkjuJjr7C02DrKCyHXrtyKKC4lyRsY7K
qTXQSnUGMzwBb41o0A+1iEH1bcAQrPBFloYcHe24o4zcLWHbjKvzuFtd5yIDvTHW9jwA65gxkOPgxcgyth
GjwqHtiYObpbMQdQFFQgePUo7vEKirGpwC3X8ougERJuu0NygX2wkxgNGJKYAVr5ZBGMSr3V6F7m0WaS9D
gXw1poPU8QWm+Aw/8TMtApumSE+4vZdIFxezw7gXrLC3zMrRPhjx7l+3ID337igtpBfFmFV4uoPIEi0+UH
B6Ugr0niKvK8frxfO5L33+7VD2p7raZceyOqyOOD2vHe/u5exnW0r9uq1uxe9TRFlXuzHmN2jlPNawLbxn
ZvxPOz0IMxTh5PZCrZFGSSQ9NhPk3YtHzOTMzLDI2dbrendW/lKOOZJTIzKSWypMS2OS1ZUsPHSjadyCP2
aANiu9eaetlWRO4yS2l6RlrjyOf0b6ecR+TxGqfMU8fupdbry71+tykrGRnOTfOz/oMMBFHw2UrjUtT6ha
yJRoKsaL92GzEuWBhGKJHkhGJlsDCH5no+zV5APcLiSMNdRohkhcgXUhRyNzcNwh9AVSwq3ZQBa2E6Kgr7
lKJE2eKEy2QWLIlrUxhhB/H4IhAR0vJg+MQiIBHO8oD4RA5QEqznGMrmogK4Gh031DGiBrceQpVMvnEEII
p3gOGmf31OicPLsp1SK17AqmFjC6VGYqdcbRLHIW61btvVC54zWUa1H7gaFHAaqDjF90xrNUrCqX3EBthD
a7pvdOKkCWHZvfEWurtGvlIZBMTiRzbFOXCJvxMJcBqyJ3zvRP90z7PHaf2b0bdm9/q8026qWv263vmgtD
PWNDc9p28Jc5XrOniJpmN2LBdDqcqixttlQU1cglDoAS/oOO1rKsPayCEvpeMegZw1wRwFQyJ0swLCH9qW
4RfC6sVSX9usliCDslQ3ElRD3Wa4GIu8k9senuuWnWARCiiCeNpW4Hvk06vp2JMangmfiyPU2sG0+axg2p
evuqq8PKam17xoaG2tYawRurixMPmCkTdO1XaSjOsVGBL14/FXU+ri2jOsJCavomASt3ZeHbyq8d/c2C2v
EbshfPVVrdGpN3/r3qhzoS01x1WymPdGy9135LXBEc54bmUU+KjFe2mtiEnUde3xM933+QbKrFyCRMTbjP
yad36+uC8unBYswcibKvOo4lZLMVxAnDnIcehxw6cYNnOgMctk8/jCpkxhZNwscrElvZpiKKfNljmcyVQx
jCG0Fr3Km0c70xsqhlpnziIBpLtVk7wY8iUM2NM1OCLu/2zsY40K91rMfCkW/rB+BynAIpNu1Fak+XNp1l
JjV2VFTRl6FJpm7H12yQ9b/2Hr35StF8uAtdkzekYOLGoAzVy7GFwbMbgQR3dNTbwSiXELqy7OLhRhUec1
l+m4K1vw4JNWZwZnMvECTngtH9xq5LhgUEhrWMzxrmj6NXY3SKMg02+ff1iURGVnpU3kH3WMF51COF3sbN
d22V8jxCo8OqIb7yVT5MbeJimyKBGW5cjzC34Ezh+B85tOkguX7sRLKvfcSrzxZq1KvNtbWIinpgTFK1pB
s8PP7QQ13j7rTYWiLuqXKOpLdn0a+0W6PuIWyvfX9GkcfOWmz+bpSlwxPr9UZAHzsGuqEP9BsKfSYW11Zn
P4d1aT32wZGcYcjfvvl4k7cSRYgHLDQPH/UrGwe1sLtSBLaHIJoxjCwLujuok1J521vI58ZbFcJbzMkSEr
HC0YWsUVBS0sxDYvyywG1jTlKfz6N1RfBQjS4lIxizH1Ju87STZjTjW6blX8HVWxRz+q2JetYp/3np7/i4
YGUdYPxa0NCU0skRXMBgK3Dmmj+GeOlWpwvEa+OGf+y7Wkf3Ot8VvcoBrtXnjNWFwNUeTsW9BlK6UvccIv
X+XUi1c5i5oGuYu+QuXT+GIXyhZdiBL1E7/00b6Aj04n905Uk7hD6y4IL/w1gWlshBcyVpnAynf84ZWGWQ
aXkRRymbdiTqmZq3tsRHzOQqK6/FA0I81OzuWjCPA3GE0AjYBSKAFmbxutvDIR/8/d2V9QSwcIEL5rP2kK
AACpNwAAUEsBAhQAFAAIAAgA9xVlPBC+az9pCgAAqTcAAAEAAAAAAAAAAAAAAAAAAAAAAHpQSwUGAAAAAA
EAAQAvAAAAmAoAAAAA'
      );

UPDATE MGMT_PAF_TEXTUAL_DATA
    SET DATA_SIZE = 3753
    WHERE DATA_GUID = l_data_guid;

INSERT INTO MGMT_PAF_PROCEDURES
    ( PROCEDURE_GUID ,
      BASE_GUID, 
      VERSION,
      APPLICATION_NAME,
      NAME,
      DESCRIPTION,
      LAST_UPDATED,
      CREATED_BY,
      IS_ORACLE,
      DATA_GUID
    ) VALUES ( 
      l_guid,
      l_guid,
      '1.0',
      'PatchOracleDBSoftware',
      'PATCH_RAC_DB_ROLLING',
      'PRD_ROLLING_DESCR',
     to_timestamp('2010-03-05 02:47:47.385', 'yyyy-mm-dd hh24:mi:ss.ff'),
      'ORACLE',
      'Y',
      l_data_guid
     );

COMMIT;
  END;
END;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de