XML Database (MOSC)

MOSC Banner

Prerequisites Before Installing XDB Manually

edited Jul 21, 2018 5:03AM in XML Database (MOSC) 1 commentAnswered

I found when installing XDB manually in an 11.2.0.4 database using catqm rather than using dbca that apparently it is essential to have jvm installed before installing xdb.  I didn't see that in any documentation or My Oracle Support articles.  I found that when I didn't install JVM first that no amount of uninstalling and re-installing after JVM would fix the problem and enable the XDB component to be valid.  I had to go back in time to a clean copy of the new database and start over.

The specific error I had was that during install, the XDB.XDB$RESOURCE table could not be created, which resulted in ORA-00942: table or view does not exist errors in other XDB objects which prevented them from being created, and the XDB.DBMS_XDB_ADMIN package remaining invalid after recompile.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center