ORA-31020 from external DTD validation (Doc ID 1407634.1)

Last updated on MAY 03, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***** Checked for Relevance on 04-May-2015 *****

Symptoms

External DTD validation fails with errors since upgrading to 11g:

SQL> connect xdbtest/xdbtest
Connected.
SQL> SELECT extractValue(xml_data, '/properties/entry[@key="abc"]') tag_value
  2  FROM ( SELECT XMLType(
  3          '<?xml version = "1.0" encoding = "UTF-8"?>
  4           <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
  5           <properties><entry key="abc">Some Data</entry></properties>') xml_data
  6         FROM DUAL );
FROM ( SELECT XMLType(
*
ERROR at line 2:
ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at line 1

Changes

Database was upgraded from 10g to 11g.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms