popovnv

Untitled

Dec 28th, 2017
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. mkdir -p /u/app/oracle/product/12.1.0.2/dbhome_2/owm/wallets/contur
  2.  
  3. orapki wallet create -wallet /u/app/oracle/product/12.1.0.2/dbhome_2/owm/wallets/contur -pwd contur123 -auto_login
  4. orapki wallet add -wallet /u/app/oracle/product/12.1.0.2/dbhome_2/owm/wallets/contur -trusted_cert -cert "/u/app/oracle/product/12.1.0.2/dbhome_2/owm/wallets/contur/geo.p7b" -pwd contur123
  5. orapki wallet display -wallet /u/app/oracle/product/12.1.0.2/dbhome_2/owm/wallets/contur
  6.  
  7. export ORACLE_SID=yest
  8.  
  9. sqlplus / as sysdba
  10.  
  11. exec DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('httpskontur.xml', 'Allow usage https access to focus-api.kontur.ru', 'IBS', TRUE, 'connect');
  12. exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('httpskontur.xml', host => 'focus-api.kontur.ru', lower_port => 443, upper_port => null);
  13. commit;
  14.  
  15. -- Test
  16. sqlplus ibs/IBS@yest
  17.  
  18. SELECT UTL_HTTP.REQUEST('https://focus-api.kontur.ru/api3',null, 'file:/u/app/oracle/product/12.1.0.2/dbhome_2/owm/wallets/contur','contur123') FROM DUAL;
  19.  
  20.  
  21. UTL_HTTP.REQUEST('HTTPS://FOCUS-API.KONTUR.RU/API3',NULL,'FILE:/U/APP/ORACLE/PRO
  22. --------------------------------------------------------------------------------
  23. <li class="active"><a href="#">?▒???▒???? ???????▒????????</a></li>
  24. <li><a href="news.html">?▒???????▒?▒??</a></li>
  25. <li><a href="req/userform">?▒???▒???????? ?▒?▒??????</a></li>
  26. <li><a href="https://kontur.ru/focus-api">?▒?▒??????-?▒?????▒</a></li>
  27. </ul>
  28. </div>
  29. </div>
  30. </nav>
  31.  
  32. <div class="container">
  33.  
  34.  
  35. UTL_HTTP.REQUEST('HTTPS://FOCUS-API.KONTUR.RU/API3',NULL,'FILE:/U/APP/ORACLE/PRO
  36. --------------------------------------------------------------------------------
  37. <div class="row row-offcanvas row-offcanvas-right">
  38.  
  39. <div class="col-xs-12 col-sm-9"
Advertisement
Add Comment
Please, Sign In to add comment