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;
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)