This content has been marked as final. Show 12 replies
I use Release 22.214.171.124.0.
First I tried to install using dbca. I got different errors.
Then I run catqm.sql (with required 4 parameters) as sysdba.
select comp_name "Component" from dba_registry shows me that XML_DB was installed.
But I got an error using the package dbms_network_acl_admin. The body of the package was not valid.
I set the XMLDB Tablespaces offline, drop them and run catnoqm do deinstall.
Then I tried a second time with the same results as above.
Finally I run utlrp.sql with the result "XDB now invalid, could not find xdbconfig".
user2627033 wrote:With good reason, they implement enhanced security in 11g
The Bodys of the needed packages fortunately are wrapped. So I can't check what is wrong.
We migrated from 10g to 11g and use UTL_Mail from inside the database.The background of this and quick & dirty workaround: http://www.liberidu.com/blog/2007/08/14/oracle-11g-security-xmldb-is-here-to-stay/
In 10g that was no problem.
AFAIK UTL_MAIL has no dependance with XMLDB functionality. Its a wrapper around Java stuff and worked in older version even before version 9.2
DBMS_NETWORK_ACL_ADMIN and DBMS_XDB are related by not mutually exclusive
Does the following help:
Check the following 3 scripts regarding DBMS_NETWORK_ACL_ADMIN and how and when to execute.
In the end verify with @?/rdbms/admin/utlrp.sql
Edited by: Marco Gralike on Jan 25, 2013 1:39 AM
After running all scripts
XDB now invalid, invalid objects found
Then I tried:
acl => 'utlmail.xml',
description => 'Permissions to access UTL_MAIL',
principal => 'SYSADM',
is_grant => TRUE,
privilege => 'connect');
ORA-04063: package body "SYS.DBMS_NETWORK_ACL_ADMIN" enthält Fehler
ORA-06508: PL/SQL: aufgerufene Programmeinheit : "SYS.DBMS_NETWORK_ACL_ADMIN" konnte nicht gefunden werden
ORA-06512: in Zeile 2
04063. 00000 - "%s has errors"
*Cause: Attempt to execute a stored procedure or use a view that has
errors. For stored procedures, the problem could be syntax errors
or references to other, non-existent procedures. For views,
the problem could be a reference in the view's defining query to
a non-existent table.
Can also be a table which has references to non-existent or
*Action: Fix the errors and/or create referenced objects as necessary.
I look at the body of DBMS_NETWORK_ACL_ADMIN and try to compile and get following errors
Fehler(84,5): PL/SQL: SQL Statement ignored
Fehler(85,27): PL/SQL: ORA-01775: Zyklische Kette von Synonymen (looping chain of synonyms)
Yes, it's a production environment. That's the problem.
I'm not so familiar with XML, but i think, i need a xdbconfig.xml in a special path.
It's right or it's not relevant for me?
Furthermore I read that the views RESOURCE_VIEW and PATH_VIEW has to be available.
There is no PATH_VIEW in my database.
Edited by: user2627033 on 25.01.2013 01:44
Okay. I think then that makes it very easy regarding the next step:
1) Stop fiddling around on this production system.
2) Log an SR with support.oracle.com for help to get this straight again.
You should never just have executed those mentioned dbms_network_acl_admin database scripts on a production system.