‘Oracle XML Database’ package needs to be properly re-created

O Oracle XML DB é uma feature que possui várias tecnologias que pode auxiliar o DBA quando o assunto é high-performance. No entanto, em alguns casos, seja por um mal upgrade executado anteriormente ou por qualquer outra atividade esta feature se torna inválida e para isso necessitamos executar os seguintes comandos:


SQL> shutdown immediate;
SQL> startup upgrade;
SQL> @?/rdbms/admin/xdbrelod.sql;
SQL> shutdown immediate;
SQL> startup;
SQL> select comp_id,version,status from dba_registry;

 

Oracle XML DB is a feature that has several technologies that can help the DBA to improve high performance. However, in some cases, due to an incorrectly updated executed or any other activity, this resource becomes invalid and for this it is necessary to execute the commands:

 


SQL> shutdown immediate;
SQL> startup upgrade;
SQL> @?/rdbms/admin/xdbrelod.sql;
SQL> shutdown immediate;
SQL> startup;
SQL> select comp_id,version,status from dba_registry;


 

Related posts

Leave a Comment