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 := '0089B8D9A98768A7E670896C666666B8'; 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, DATA1, DATA2) VALUES( l_data_guid, 0, 'Base64', -- data0 'UEsDBBQACAAIAKOaEz8AAAAAAAAAAAAAAAABAAAAeu09aXPbtrbf+ys4bO846cjavOcmvo8iqZg32kpKTj LzZnhpEo7YSiRLUrF9O/7v7wBcxFXiIstOn9OpJRHAAXBwdgCH7/91v1xQ35Ht6KZBfaAOOs32AYUM1dR0 4xt+MJv2D88P/nX53rJNFWkrGwXVP9BQmaZUGyku0noPH+ixyLADnmLH4gS+ToXxiKaQbZv20NTQB9pxTY um3AcLvnM9qDsRx9c09W2lax/odvv8onfOXTAX52en58wZf3oGT07ZU/Kvd05TC8VxZ5aGO4OujzpH5+3T 89PTbrdDUxpyVFu3XDIsAMvy3EzkZY6XWJnr8SxNGcoSRYtGzJD3iwAFhvOBnruu9a7Vuru7a5q2oi5QUz WXLUu5bcHUv+t4yoATRoOvpv1lOKAv38+RoiHbh+2sbqYwN/oSQ33f8soSddDy2kMefdnpNLvNNv4vpy70 3LSUJX1p3dgrI6/SQnFvTXvJ6TZSXdPWkUNfLnRjdX/UbZBP+f702P+mK+FXy1LD7/91EG4Hv+cWLlJs3V GDX6SNogctHHOBi2UHakV/30e/n5+G3zvtaN9rOMmeZNdeIfh2pxuaeefA4P1v62enxzk4cFzlG14ZIET6 8h9oqcm2abr/aPFDCUpQTqvbO20mwiICQSk3ioNa2g1SW/y9iwyNXawcF9k5LW10A/BF9Kc2IbgHjHePGs cnR3njQ+7KkpHxnb78iYJ/+M/PP1PwmGLN5RIYD8p02zSWyHCp74AU5WaBHFIXKkHhG3rAyQMBeEb8Kk+Y 6ZUsjYZjukH/wo+u/zrgh5w4Hk8PHlsL/eao+y7jaeqZhexFZoGB3DvT/iOz7Hftj9bvNsJlLf3o/LSlLn QY89Z69Nt/xmYz4cXBCcwnYwa54woKgD8PN1dC925rMpaEL9nFM1HILriaDgfyRLGBHfIrHHoVMnu/0Y3U M+fBWSpGS9GWutHyhJTTGiH3kBtJh+3m8TlBUrFmUBNW57DT7Fy0cvHTOmmeN4/yix3dRTL5VbRiocEV7r Clg9Q+JELh0J0Dz2qHy9XC1bNoRO4JozwaAWQnm/wb5PrVeMhnNPEpMtkiwVZPzlGp/oVeqX5z+8iAnQM4 i0gxdrKeRxFNYIPYkkBsBVqHciyk6re6miPBSBv8b/lA/WI6YE/8Z4VlInXo/OefsUKwKSKldqJ0rtjanW KjD0GFZaSCOjeXFvUG4AejxP/0W+oN6RP9SdHSyhhLNPWW+iss30wFrZVDWLy1uLMCvMYhB0Mi8PXzU0tN wy9HaXWFa4Fe89TGrrp+pNDCQTvDAjEyioyFVNwxHup1/vhTDCcxaryaHM6+pKmF1KFDwqI9ygKzqSRhUR unJTCnx6MWaLDvGVouVbE8Tp+y901IHWCFkoWpkmitjFgMssjMSNcZaK2H2Hq9h+hM4sk5umjf0yXxlDtQ 0CTAUIrj6Oq7DXWqYGf3febihDgw/49xgnY0813ouWfTdJuFESN82WBt5Np8NdYnPYax1O/s0iRRFtZc2T qssOaOtXGN3tOo4RT7DtAXQ06KtH+mZoazsizTdpFGjcEUVlwcE5MeHBctf4qTwU8/gWXcXxkqjkBRrkmc +0ybuIlrTmx0q99T7hxBwWKFKAvmBb1AQ9PWv+mGsvAKcGXdsFauQx3i7523FJ8BlQQacHn3LXVN2jmrGx /d3pTAin7zS1C9AfY2rvUWTO7/kf/pl/8yUdy5hCx4SL+jyVOMNQ2GasDYCM5DEI8R3CVKoL0HnmquYTaT tQj8JNLzIHmVf3rE5v2GaJmz0kz6Ev/dEi1z6Mvj00a3C/93juHzDD47jZOLRucCf+02ukeN7ulZo3NG4j qNTqfdOIX/u43zs8YFKYcK7fOcbhRnyd+ri5WGYPousg368tfmwvzW+LWp3dw2nD8X4BLiIGNjoQMxGcgm P1zDwe0d/CMHsmo7mZC3zPczuJ+cbsO0W+7SauzwD/vuf4EbUp95kTNFrYuYhh/VCz4BkDpHzq+NCdPPw4 JtqldoYQE/0JdAJ7LqyIjE+WQYkKx6wT5ZN1zb1FaEhdeQNARCB7O+aTiX713F/obcAQzOj2PPTcclMXAN +FFXFtPI01hQmhUlWeT78vTjVCJx6SAkHSmgL9+HcmL9lSJSz6v8u/JdaS4U41tTcm2QRgGQz2Pxk8wJoj wYs3SrXNuZxIs4Gl68nYNgwu4HGsdsw8g6I0kwCq5s7+xgJk15UR6NOV6ezHoDgZXLjSYLjihcM1O+PqBr YVIJyJQRP/JTGAcv8r/JQ2YyEUYfpbJQxr3+TGJhIpxcFb0YE2QqA0EKxiNVAgKYqAPjWhCnM2ZQeywBnJ rD6QsDXua/wGJjcmGmsOKjqmhhOE7kpdJDkK4YEVYW8z8JWkLzVoT9W2tZU0fuiAybLXciBT+K3NkBV+xS dO2ChnwiwIvxhETADAZpAggeVl/9F7mCuejbAn7bymJGLTDKrWBgqcviqzcecaA/YPWuBbaaVgtADEH8Vm 3Lj5jegC/NJldjENNVxizNeiNQokNG+lRBNA+xeykNmGvex1vp7iNtJaJsykLgxkNGGFWaOzeSZOCua14s rVc4vs/MBlP5IzDYZ+Zr2eaMOMFKzbNgKjUeAZ1fM4OybYeCsJO2kjybwLINyk89DoUbfx5VgzOaTvzFK9 tSkOQx25fkrsxe8ewn7Bn8NhPEIkzXM80FUowEpK4MtifY1JhzS8PApgn/ZcqPKnUPlhkeflWxAb7A2lj0 psKOR33h4wwrTFwi7QDkdCz3+F0Axn4LlnTkXFF0uLUgAiPuAJZvp1aBlF5Wke+Nx9OQMOX+WJQnA2YKn8 PSDFdBG4HNChb/CPQgVq9VZvBxMprIvptXuj0n9PsyNnxK+5XATFic41Nx5adM1quSEgXPBLqUwfgrZKOn 0TWC1f4sjEAcVqKXwk0TRFuYpJ5W8mAruRLX+YZDad0hsOXjBCLDMVOmihM2ZoF7GXEq4NOaMui9WWkKu+ akT3VhxMMU1UEEUYFqE0mGKGpBqTUUvCxDQRTHu1kdH1Rnl8C6tdc8ymZYOlZisyBc5509Jk50nbDfZ3DH Y7Aq8FQYQawirtNBodImG8NxJHgpzVgQQFJ/NqgiRLEBi71Nlh9NRaG85sAhjSoj2UAkGGQ1Wdyru6YJCJ Vcul5FpwoaSkLNCAnXqxrlwpjnR3EO20GUq0zzf48BA1PmYzVuvJ6BpfgFfMJqyz4Zi2A7gZ9APLKyADwT RB4yI6wTpBk3hpnwE0LBt8F+cQSOf/PAO2Hb1G7wHYSlCd+s5sQ2v3vnxUW0NL8j/NdFZFsvPJjuP2ExI6 6sWp2wc6T+Ia00U3IVdxX2oSYeF+0CqRh87Hg96WFiw0T+zOgjVlCjl4GpBF85xVWCPhaJxzV6EBzJRRZv YJrQAvh67GEd6IaOY7v6fxGHrAWsjxp2ASXcpPYKMJo2MjWUsQTxkhr9XCNbv30A9geIguG4iqGiZE/Bcx E5q4Vbe1bC7cS03b6N4h1FHuNYcXx3Fxpb8AHcYK1chNePQveWjRzvutMvf3kYf/P2kaaQt7KBlPUuMfWZ i5P2OX9y3O11212O5dtH7ZOzc/bitH3RPel0k3vC4+FkNuVlYSRMZW4S3xZOlAUax4LhLhZoMZkrDqK8+L aDx4bvsTQjm8kFxniUPUbVNDTd9acMCH+nGNobv4O4P/jY8B+HXvEjxk1sknh3SOKnIH8l6So2xXgJmWC4 Bhq5z6R/91Yh/BWMCCY9E0d921ziAyZvDriggtMaEwqhIk/IXTNqErnE1eq0yeWrTrPdWhn6fUvCV3QoGM YBWdt7pK6IIA169RComUSwzqxcjB5nYxQBPvFShIBqIOhGN8jdPL9KMMYmCTyxS22gG+hasZ1mdCNbor3z RCGhZPu4j5jCCncg', -- data1 'jEApQ1MSDVnD92iyGWwOlYMJSn409YyEAOL6RlcpSFFzrcdInu2wHiWmIiB0VXHfhEOO7mY+NigfVfEICi bwUsPI2OtK4Sqj0qMnn6JsAL997mjFpMA2oRDZ6S0gFE4KCK41YWLY+WQblP4tePu0gLTMkpGF2b8ULl/F wKsYKCcG4rZBirzP9mEMTK7wEuCR4HJ5wotDwUOrv98Vpf1tlZ9NonjmLDVzkE1NkL3UiYHo1JQv5xVsh2 teFPpf185xFElk350dcsThjCG2cKsycibupCfkTKywHOeQABLZfS8uu5IM8zz0gb1kauWQQ+O1tc9FMeqI pFsAznV1I5dkcCiCIWG5ApSSV5ne80Lmu2aJuMQbb2WhxnfdXBFfHNy2Rl44pohHxxQ0jEjSCf5LvBeR/y 2q0q84kVQhgkwW+qm6MHd8jguHYkDgkvmmBtQrMCB/ATlB+rR9mdO1aIJyPIRLZ/6+FXx/D6oF6x/vw+vu Eqlzk6KJ843pgdOdP6hb06aW5spwKZCRK+RQiksdBPooP+L+eEBn3fWhKK+PINnFA7VUHijDdIEW8Kk4AO 7OdYeyTB16vJvr6hz6JRUU6lbRFzh7yRsyQspZqSpCGtLeNjf2BfIdn6DHM1IofCqdIpRG4Wsec+TLEhjK O6rAtPAFD6+5fkua+wil5orxzdk8ECGjRQM/gjnhe8gxNN/p7tzDhYaXATdw5uZqoVE3iLrV75GW19nCKT KRTQP1aTaQdRoZjLlyyZCjIzbMTYOGAb73kwsApSWYYe8inSVZbqiQ8mpKc7ZinIDIlokI7MuKPD7hHjxM CpdEnTJymhhbxPzNkNWbiKKUWo+dHN6/Pb4LZbQLbzxFGVxlLzPD0MZ9FTa08yv/zQxt/tXQfjW0c6mj/2 poP6+hzbZfmKHNdn5sQzt9+uFHtq8zZvNDmdUZ43+1pmuJbLb7o1rTGbTwakSXj2VvUyhHRW3q9YWHbHsa Hyz27/Sm7edI4XPtd/kHICgBX2XHudnw4GsyV9Ut7WDfSRhNxbE04VlyUjTJXdm1yu5xJZjITz37RJ7rRB yDGT/9Su4flOe8g5ZqO/h/wbg1m5ZtWsh2dUScmjLDiN4nSE51XVTSuEuciipy0oU9KXHSZTBmuHDNyZn1 rDMv6VrB6Zd96ynTeqBIZjFKnAxr+p3sE20gs+PJV5n8gTEmckvEi8qyVaZ6iSTY9fOA4vTIgeiRLUX9Q/ mGnGffQi6mnMJz5+WAQ4MpsQR2pnSf2ZMmp+8Wi90R+062k3EF8C6CCnlOJaDwbZFjFgGZpfgkVViWU6DR rsihkeSkknohvPgJaALZORa/Jhkg95Lp0zNYkspBfKyUhaeItqiZ852dT9hARtuIxm9ThHZcdO9e5gGYgp X5vkWqvG+tkbB3tieUQuFDvpS0MF2HIs57Oda3Vwbj4PT3mpmxbBcFli12VvpNxs3lQtztNfLumwzGwE1e zCe5VjnVynL8Dxgt9RY78BFY07ilvPcp7HK9mT2v92zCEa88c5X9wspH5vjP3up5sbqc1d5y87ukVZ/q2r 9HmOo491J3yYNp2TfrNxF1dpOXQOG7tdd7eyZlYqhnEzIp2on53kKu2jLVW6fb8hPfNWFCtz+Iub4pacPz WfCNgygqD97+/ViB3Rsr9IG0etmsECnaHSvcgt9z80r9daifoPDty7Fw8I0/sjeDTRz928ouaeBs80S4Up 5IAbYo7enmKBASN8tWIKRoJ1zz0rYXtjJFDZ+Tf4KVruCCRpYwxwFNL3LofqYb5zqf+9iL6e9sL2YcZv/M 2oyJlD7XbgzgTA4zTrdEdItsZKiIujIdl5IUQ3drbnxy7Qp7M+RMAl4v4tNIzEiYxlVtZoWyoiMj48KO9z 4xfWzpYmdbPjBWgoD0FLyMDi9B9zGaRvVMb0KCAcboraKiSnZfBzNpu9Puc+3e6fkZENgxIbCzs85Zu3vW fuYobpCOEmfq6zM4N2NSGqZrlCXfZMrLxMInissRU1Y2zxz4kSrV+iAJ1nKA47JyUNeZPBMgw4KSoep17u SUHZ1IrlwOcDRzaGKokaKy274ZKUXTQZlUnZIjTycdTU4gVaOkLIskJU3Ks3VRSZiRbKVJmOuisi5KPI1p Em68uOT10liO0wTkWGEFuEEK0yywflk5qLHEqAmo0bLqUCMpUzfAX9eq01MkrerGvtb1SnoN6+SrCfjrkp e80cV1nmmjK601c5yNXPUa+hzRGmIMVq7vgc+kmAYyXIKj8FeetcQGFUJrKfKkgLXkPDiqu2h5L/PxAwVU X194oYInN9a8fRfKGwV1G/Rb2VDrnOzfUEuf+Aq8b1n6KrHTNOGkKpQ1y7LMmfJmTCKDbAJevPQFnTl52k wGrRgDlhJY3WcSWClyypFXeWQXiqs8QC9gl96/4eJv2uKXENYMGRyVOISWyKP7WOUWTPSctcxezzKOVpPH VaUAab9Oellts3XrlmfVY2K9zWdSa8dAIgGO/Rx+hcaB7El2tK+w8O5yw8RTQyZRFi2sckcqmsAw+5ZUgd O13HHZy1DhTSdv8NvuQ61r7fV4LWA3KtTA9LpfWTVF20kpPVRMI4mzEUaRfM3gi1uPb+vHsyIi03FNa9NS krXJWj2v4CVJupKs9ALkTQ0P7XRPhFbBJkreidxKQqERFD78G1k/2xZydzmvUstXnfFZ2b8lCvAws8bXLl b2ajS9Gk0/mNG098twxLzAm2P4lHNNC+N8V7kBiNfpMaB3FDnls0YLS59fTW+NPi2Bh5wefYNrxqZO3ste K/cWec/r1u4idav2F7wOdltfQb2Sez8kS34adOKdEOWArt9BSKRHVnAq722HVZyeWMrwnNwQBwD7oIjvc1 HZ94m9eILnMFY3+EDp2vu/ash7QonCApny5uf4OU0cZ15TbjFPYLBmv2lkFx5SpqQU8UvHJFYUJlMpU1rG KtS4QPyUVkDh+G0Ns8C/YXzwbAbCnrfLenum7SqB6iR55gWqc8h4HajOAfR3DFTXS5FHcutkRJuD55U9p7 FPu6+u06vr5EvGZ8jSz3EFTKN1Wj92MB7xOSn/vLLnOiPrvbiFwskmbjBWrswlIsmsuB5rGo65qCtG+F26 bNm4jJfU2tNev213p7lP6vJ96tVnm+FXcLEKS8bwHXA79a2CN5Ptx7eC3p7MtwLYhXyr/qtvVcm32oJXvv 0UewOZr1J8EleLaKFNrlaqwg5drV2KqWd818e+Xam4SKzuSvGdPdNuBVcqRX45rlQemYauVB6gF+BKxe8N hZcYqTE7JKYRIjZTPbuI7xY9B5SzgFtkCYw1SEqAUxJHlydR9PTyo6SaXb8isEj6M/6ojCIN1aL3VtG+yP NJ7ZlVpbUXp4I/Ls3/Ec0D/P9xMpoEedsytVP6tcJZZ0k93wTvfoTvnk27LrHiuPeyv6PEodviHyAOGz75 KWK8oRW8MbPy0WHm7LjgHa8akiAQtnjByNV5fLQ2S1zHKry8+4ZVdHGZ4Xv3TQrcMywDlGSfjYF0HjJS84 V024y8Jzo1iNg7ycqMIgUyeEe158p8oEFE8IZqP1iu967c4qaWNMxd96xTzds9rPhraAtpgJM6rlRI8YXd qYwWMNPfzRsyK/jkMjsGNSDy0hWNa0wfLLLqnmVBXn/LmqBFSL7Y7RM+rROaDccRn2XwOLn4jqFYztx08Z DDpcX5q2U1Ovw01QQNP8HTsKG6sm0gBkIaPsY2EUXyhdo1d2Y2ZwgrQmpnBUkNGIIZede1kvl2/YIgo+o+ 7IrzEmfOk/ZBpm3AD1kmW5lklT9bbHNIxViMYoCwsHRxiRk/QneUYWqoZm4e/uJpLfmoes7He36tV01eX5 PHYsSKpmV5NftUAMyrAngmBdDbmwJYP7dNFWkrG13+H1BLBwh2gPZI4BYAAC60AABQSwECFAAUAAgACACj mhM/doD2SOAWAAAu', -- data2 'tAAAAQAAAAAAAAAAAAAAAAAAAAAAelBLBQYAAAAAAQABAC8AAAAPFwAAAAA=' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 8060 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, HELPSET, DATA_GUID ) VALUES ( l_guid, l_guid, '1.0', 'DBRACPROV', 'PROCEDURE_NAME_DBEC', 'PROCEDURE_DESC_DBEC', to_timestamp('2011-08-19 19:21:06.221', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE CORPORATION', 'Y', 'paf_cs_extend_rac_cluster_introduction', l_data_guid ); COMMIT; END; END; /