NETWORK_DATASTORE Attributes

Use these attributes with the NETWORK_DATASTORE type during indexing, for text stored in files on the internet or in local file system files.

Table 7 NETWORK_DATASTORE Attributes

Attribute Attribute Value
timeout

Specify the time out value for all future HTTP requests that use the UTL_HTTP package to read the HTTP response from a web or proxy server. This attribute can be used to avoid being blocked by busy web servers or heavy network traffic when retrieving web pages.

The default value is 30 seconds. The minimum value is 1 second and the maximum value is 3600 seconds.

http_proxy

Specify the fully qualified name of the host computer that serves as the HTTP proxy (gateway) for the computer on which Oracle Text is installed. You can optionally specify port number with a colon in the form hostname:port.

You must set this attribute if the computer is in an intranet that requires authentication through a proxy server to access Web files located outside the firewall.

For HTTP network connection, an ACL package is required so that the UTL_HTTP package can interact with the external host. You must have EXECUTE privilege for the DBMS_NETWORK_ACL_ADMIN package to grant the CONNECT privilege on the ACL to a user.

https_proxy

Specify the fully qualified name of the host computer that serves as the HTTPS proxy (gateway) for the computer on which Oracle Text is installed. You can optionally specify port number with a colon in the form hostname:port.

You must set this attribute if the computer is in an intranet that requires authentication through a proxy server to access Web files located outside the firewall.

For HTTPS network connection, in addition to the ACL package, an Oracle wallet is also required. You can create an Oracle wallet using the orapki command-line utility.

To create an Oracle wallet using the orapki command-line utility, use the orapki wallet create command:

orapki wallet create -wallet wallet_location -pwd password -auto_login

To add a trusted certificate to an Oracle wallet, use the orapki wallet add command:

orapki wallet add -wallet wallet_location -trusted_cert -cert certificate_location -pwd password

Use the UTL_HTTP.SET_WALLET procedure to configure the request to hold the wallet:

EXEC UTL_HTTP.SET_WALLET(wallet_location, password);
no_proxy

Specify a string of domains (up to sixteen, separated by commas) that are found in most, if not all, of the computers in your intranet. When one of the domains is encountered in a host name, no request is sent to the server(s) specified for http_proxy and https_proxy. Instead, the request is processed directly by the host computer identified in the URL.

For example, if the string us.example.com, uk.example.com is entered for no_proxy, any URL requests to computers that contain either of these domains in their host names are not processed by your proxy server(s).

Related Topics