Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Verify XMLDB ?
"Maxim Demenko"
> If the installation was correct, this component will be registered.
>
> sys_at_ORA102> select comp_name,version,status from dba_registry where
> comp_name like '%XML%';
>
> COMP_NAME VERSION STATUS
> ------------------------------ ------------------------------
> ------------------------------
> Oracle XML Database 10.2.0.2.0 VALID
>
I get this ok:
COMP_NAME
VERSION STATUS -------------------------------------------------------------------------------- ------------------------------ -------------------------------------------- Oracle XML Database 10.2.0.1.0 VALID
But I googled, an Oracle.com doc says:
"Confirm that Oracle XML DB is installed using the following command:" select XDBUriType('/xdbconfig.xml').getXML() from dual;
But I get:
ORA-31050: Access denied
ORA-06512: at "SYS.XDBURITYPE", line 30
Received on Fri Dec 15 2006 - 14:12:18 CST