Miesiąc: sierpień 2021

ORA-29024: Certificate validation failure (UTL_HTTP – HTTPS)

Opublikowano przez Wiech

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 Passwo


…

The OLE DB provider „OraOLEDB.Oracle” for linked server * reported an error. Access denied. Msg 7350, Level 16, State 2, Line 3 Cannot get the column information from OLE DB provider „OraOLEDB.Oracle” for linked server *.

Opublikowano przez Wiech

Pełny komunikat:

Msg 7399, Level 16, State 1, Line 3
The OLE DB provider „OraOLEDB.Oracle” for linked server * reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 3
Cannot get the column information from OLE DB provider „OraOLEDB.Oracle” for linked server *.

Neleży w Server Objects -> Linked Servers -> Providers dorzucić „Allow inprocess” w danym providerze
…