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;
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.