Question: how to reinstall xdb in oracle 12c?
Answer: Remove the dispatcher by removing the XML DB dispatcher entry from the init.ora file as follows: dispatchers="(PROTOCOL=TCP) (SERVICE=<sid>XDB)" ...  Drop user XDB and tablespace XDB by connecting to SYS and running the following SQL script: ...  Re-create tablespace XDB .