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\PatchRACSADBAllNodes.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 := 'FE8664F25820F808E030578C11012422';
    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
'UEsDBBQACAAIAPgVZTwAAAAAAAAAAAAAAAABAAAAeu1be3PaSBL/359iTus9TFUCmMSPJLb3QBI2t9hwSP
Zeqq5OJaTBaFcvayQ7lEM++/WMHgghAcKON5tLUrFhZrrV3dPd8+se5eSXT5aJ7rFHDMdGp6iyX2tUELY1
RzfsWzpwLXdeH1d+OTtxPUfDeuDhePkpB4s5pHlY9bHenp5y/WGL74kcwp7neJeOjk854jsuh/ypC58Hqq
9N+p6qmVhoS87Yf1A9zKHbwNBPuY54fHj4ttM8OG42OseNY7HxpnFwdMzv7zf2m2+bTQ6ZKvGvXZ0+DB7d
PDw6Oj5sHB7vHx1ySMdE8wzXZ2INhoLS6vWUq74gSgr844ccslWLitCS+QsFxFSE9nwNh8AKNjnlJr7vvq
/XHx4eag6Ts6Y5Vt1Vx3XQ/t6gWoNZWjp8dLx/X/a4s5MJVnXsRexhZc1VLe7MHXmBfVIPJzOLiK/eUi5g
N+7sZ2zpiuc4/s918VKCGVxARVmTQHe4M/qziDX2A1fB9j13tmNN0S6oeyGJA7qP7ysfEPvzE4J9mCCCXd
VTfcdD96pXQwHBOhph03mo7fyEDCJarj/d+7vpf/Ax8c+qMDgE5p5NkO8FGBljoDPhQ7IEiBCmVJTBwMQq
wUh3kO34yAJvGk+RP4ElJBh5TuAbNq7twOfkUbtVtPO4QwUEwfd2KcsqyP0P5UMoNPE96pG+g7QJ1v5gK9
kqqlyFyrP3Nx2Pga8ejlc/7ISUvxm27jwQ5OG7wPAwQSrIFYxM/PoucMCZYtZjsIWrEkI/24FpImogC/vg
7YyTx/SPZEP4DnFcFX3+nB74D/zNDlYqIMkMbKLqek+gO8LMeiX+poRfmXFbug72AYuBhBrsyhSpPhsYYX
AW6nXIGaOeoPS67WFr+FGhlOUsPX/+bjVtahs/KKbuglNEBo+ndjOPg9ld8ermsZIZr8xCEroHyXZm1lSr
bEn4WLZ3RczTHGfsJzYJXkv9BZEve//9vPsY+fysuvs412y2N5/4vFv9Mv/25fbDWq5p2uQjcIlpQzELbA
OKcQuipFg8ZlbPOOoq812FLUOqPWURS9DUCdCDQSY0COgM/KIekhUayEX73vAc28K2j25Uz1DB25EKLjFx
Huw4zOf+wIWii5fCsN+XK7O6aYw48NrVK9406ZqdeSrSsWbSnAJZkpyd+Kp3i/2eAVEQpv+JQ3wOGTYE1L
2BH045yLAKpHN1BKqyc0QHeQ3VlFPLFxI7zdvyuQzqSrLS6Q+Vi74kS3FupwRtDJHCzhmsQ3K+j3Qn848I
ZCQkpPhdvVdrpmrf1iSWAmJOBuk5mmpy9bJkQ2xBRilPJ03gJNQpXYHVlo1j4YxxMoa5FFOGsfDzGAYOxQ
v65JIKykypvkS/laX1sGuqADzY2SgYXmnj2nDe2hompR+sasLoaguJbQA+29Dpo+5GskJKN2s37JRYUjIa
Lv1kqSuUNpBKrO62xg3d/CYEkmWJTYgObAMtJaynXLk+j54VE+sTU1HMLSUkGnMsB7GgE7pDkZe7N+Ii5q
R0HcfjA8DCluRjt7S1yCa+n+MWLo33dTtbRCd52naEAqT0rQiHmJ16pHz+ZIkNwG9pw96ZEtvN0skhsKV/
9Up7vWEBKFQtd2vCnnMLM5R8HNgadcI0eVSzkCmxVLumj6AWqcGZOfDwgBZvhKQzhuGXYcMs3LXHzjn2IU
5iNhBIbAZkpZNlOEotod2/yJNNd9Lj1AwbsXVdylZOortr6/jTgqjhXMsvw2/QasP58wcA6bl4yQjNP4uo
h9D4PjuBstENfEyjHeFPrkf1oAlj95Eafg/RZTVa+KLqDOplmzoCVLW0tEoK4ta7AyiDD94220KjKfBxQf
zusPGuebDfzKSi7lVXVvj+5UCRZHGwmIEW56jUtLQxTWwOJhRmhhmRUPEoHqtlkdQsRyYxXyasGz5VJtZl
QcZevz9Q+jdiBNwWhcxMcoktPcc0qSxZUcOPtSy6yRO2s4Ww/StFvuhKDEotSpqe4TbY8iV/3qvmCMk3Nt
hlioD7F8pgKA6GfV6UMjZcmmYeGglYTxvyOczK7+dLrDk2GDZSHmLqPVSmewnjGO3OmOc/5w787oyY9eG3
kOYjya1zUWGtH1FS/tlvx8xgYXi0M3AZKkpgYY6qzXxV3cBzHRIf0TTXhkzWaFYoUaje0jToODJs1pJLZy
olLANYIya1dRFKn9HNXyRLAMGchgV8PF5EwrBAHg2dKCJiOCCPiE7kECUoZ0mhbA3AiOvRdkPdyXomxn0Y
e8m32PuAw/XwquM5Fi2j9ypCvIDUw2YkSo3Ep1mddyzLsest06yfU7BpaPVhYCtQcCsQyx6+I4rQrjAf/o
Q1CHxh/txoxx0e8Ix97Rbldf5NqfhhBpxjHRY/if+prmtO0/634G98/6rT6/Ky0rpq9T5K3UzaWJpe8rdE
udpVC4KRt/SeYeMb1SNRo/SipCeuYMj8gBbgVPYNnWFj5gDovenAAbCfcI5OfYf5Zg2MPzYNzS/F1Y2tvn
FYrWBmkKGqJazGqklwORVp97077qiGmXBhDsjQSjpWCs+GZHgBJzwDbODfPgk2DMXLviyuRg/pNc8JIviD
DaI1OePCTtDsBTFGDEr3Emz5CiLJ8+PxV3PpFrsFs1fRaRL34l4dvmrQv7ko5XADlALn11BW2r0W/2v/Wl
4621Jz1CfLpW+0On9HaRsy4ULqliaBjwTa/BQiJVHfNqdPzN9HWzizdAEWYRdQ+d2C5fnyybg0LljBkXaz
llnFPa5yvEA4fZST0eNOWzlu+kghhk6W+YXtrNLMaFjkcku6XOVYzttUSzyTqXIcQ2olun9dZrvQVSvHWi
VWkQHSfb5Z3iHyEgHsqgpsEc1/Jvax4rH0Wi58PczyYesWMEBhSB8/uaQphmQr84IsSnIqJ0Sn2EJqWFzy
Iy38SAvfVFooh5aVxT16Al5m9YKib1w4bswYso2l2rrCrq1i3iyqy6sLBVvU3s5VOm59l9z4pJ+c4ZlMPE
O+3ihdC+2cbA0OaYzL5eg1nVD+3dftOEH90O18LIJm2Vlum62KOvhFGxZOl3ODjbP7n179tZ7Uh5XkohpJ
kp+10muXqfTYqwLfYaHHb1HoFZQ0BavKF3/b56IYOT4dMpKAuNjWZYhYMPYpd9RYn7aENd3jJ0HFbxYjhk
hMoajmedBYjI8KWG4Jn/4qcITcmUroBVlBk2vscgwD99ZTdaxYaSz/Ohoth+DD6/CMWOFoScDJLmWVEGVt
j7kMAtE01yn8+hWgVQmBlBgHZjmmWvrfSQkWawpl+oaQ9zuCqNtcjP+f4c6XvLCj79YrcMr6obmVseMlkU
hKooHAbgGUZG/hr3WDzgYYcin8t0UEw+srhb6YC07THYRvgLLbY0nM3pOsWsm9xN6XRraOmwDbXKAqNDYC
qv3BBjg1d9GKdyi+WqUk7P9l78mE5p9/T/YiV0q0MkDX7nPeKAlvtrlRYuXVqiul5QU/msc/msff9J3S8x
8Tb8sfE4WHwxZHQlFi3fhEOHixFy6L3qNjHTj6rlD3HH71ermv0vGOPTZug/CFWB6Uxlr4Hs8awCQcrtMv
fBNmUcFVIoVa5q1Yyn7EVl0ycXyqQuKsdFMULa1OzjtrEeGvMJoQaoHnYdtffEltrbvE/7327H9QSwcIan
8LWasKAACUOwAAUEsBAhQAFAAIAAgA+BVlPGp/C1mrCgAAlDsAAAEAAAAAAAAAAAAAAAAAAAAAAHpQSwUG
AAAAAAEAAQAvAAAA2goAAAAA'
      );

UPDATE MGMT_PAF_TEXTUAL_DATA
    SET DATA_SIZE = 3842
    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_ALL_NODES',
      'PRD_ALL_NODES_DESCR',
     to_timestamp('2010-03-05 02:47:48.176', '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