How To Determine If XML DB is Installed

The user XDB must exists, check it with the following query;

 

SELECT * FROM DBA_USER WHERE USERNAME =’XDB’;

 

Describe the RESOURCE_VIEW view, with the following query;

 

DESCRIBE RESOURCE_VIEW

 

Dispatcher parameter must be set to <SID>XDB, execute show parameter like this;

 

SHOW PARAMETER DISPA

 

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s