OraFAQ Forum: SQL & PL/SQL » How to access URL's from your database that are accessible from your browser

Home » SQL & PL/SQL » SQL & PL/SQL » How to access URL's from your database that are accessible from your browser (Oracle DB 19c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to access URL's from your database that are accessible from your browser [message #688079]

Wed, 16 August 2023 10:00

kjcook
Messages: 31
Registered: January 2016

Member

I am trying to index the content of a document using NETWORK_DATASTORE in Oracle Text. The URL that I am providing for the document is valid. I have logged on to the DB server, and using FireFox validated the URL. But the content is not being indexed.

SELECT * FROM CTX_USER_INDEX_ERRORS

returns the following error:

DRG-11622: URL store: unknown HTTP error 2447200152 getting http://myHost/10880871.docx
DRG-50857: oracle error in read_into_lobLocator
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDML", line 2183
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1288
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 651
ORA-06512:

I have been working this issue in the "Text & interMedia" forum. See conversation here: http://www.orafaq.com/forum/t/208417/

[Updated on: Wed, 16 August 2023 10:59] by Moderator

Report message to a moderator

Re: How to access URL's from your database that are accessible from your browser [message #688082 is a reply to message #688079]

Wed, 16 August 2023 10:33

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-29024: Certificate validation failure
 *Cause:  The certificate sent by the other side could not be validated. This may occur if
          the certificate has expired, has been revoked, or is invalid for another reason.
 *Action: Check the certificate to determine whether it is valid. Obtain a new certificate,
          alert the sender that the certificate has failed, or resend.

Report message to a moderator

Re: How to access URL's from your database that are accessible from your browser [message #688085 is a reply to message #688082]

Wed, 16 August 2023 12:01

kjcook
Messages: 31
Registered: January 2016

Member

Didn't I validate that the Certificate was valid or non-existent when I logged into the DB server, and using Firefox was able to browse to the URL with out any errors?

Report message to a moderator

Re: How to access URL's from your database that are accessible from your browser [message #688089 is a reply to message #688085]

Wed, 16 August 2023 15:04

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

This certificate stuff is outside of my area of expertise, but, while you are waiting for Michel or somebody else to reply, perhaps I can shed a little light on things.

From the Firefox browser window, at the top where the url is, to the left of the url, do you see a little icon like a padlock or a triangle or a circle or an exclamation point or some combination? If so, which is it and when you click on it what do you see? If you click through your menu options, you should see the certificate information.

If you go to www.oracle.com and click on the following things

padlock to the left of the url
connection secure
more information
paclock labeled security
view certificate

then you will see an example of what you are looking for on the sites that you are trying to connect to.

[Updated on: Wed, 16 August 2023 15:28]

Report message to a moderator

Previous Topic:	Ranking account and customer balances
Next Topic:	check the integrity of a field between 3 or more tables - SQL Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 16:00:07 CDT 2024