Podczas pobrania adresu „https://…” pojawia się błąd:
select UTL_HTTP.request(’https://…’) from dual
*
Error at line 1
ORA-29273: HTTP request failed
ORA-06512: at „SYS.UTL_HTTP”, line 1530
ORA-29024: Certificate validation failure
ORA-06512: at „SYS.UTL_HTTP”, line 380
ORA-06512: at „SYS.UTL_HTTP”, line 1470
ORA-06512: at line 1
tworzymy wallet-a:
mkdir -p /u01/app/oracle/product/11.2.0.4/dbhome_1/wallet
orapki wallet create -wallet /u01/app/oracle/product/11.2.0.4/dbhome_1/wallet -pwd Password123 -auto_login
dodajemy certyfikaty:
orapki wallet add -wallet /u01/app/oracle/product/11.2.0.4/dbhome_1/wallet -trusted_cert -cert „/tmp/INTERCA.crt” -pwd Password123
orapki wallet add -wallet /u01/app/oracle/product/11.2.0.4/dbhome_1/wallet -trusted_cert -cert „/tmp/ROOTCA.crt” -pwd Password123
dodajemy walleta do utl_http:
EXEC UTL_HTTP.set_wallet(’file:/u01/app/oracle/product/11.2.0.4/dbhome_1/wallet’, 'Password123′);