Re: Verify XMLDB ?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 15 Dec 2006 22:18:42 +0100
Message-ID: <45831132.6040907@gmail.com>

klabu schrieb:
> "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
>
>
>
>

Just looked up incase you have privileges issue - you have to be SYS, XDB or have XDBADMIN role to have access to xdbconfig.xml ( actually, xdb.xdb$config).

Best regards

Maxim Received on Fri Dec 15 2006 - 15:18:42 CST