ORA-04043: object dba_data_files does not exist
今天做rman本地迁移数据库的实验。 E450的数据库版本已经升到了10.2.0.3，搞笑的bug跟哭笑不得的解决方法…… 呵呵
在mount状态的时候，如果你desc dba_*数据字典，会报错：
SQL>select status from v$instance;
STATUS
------------
MOUNTED
SQL>desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist
然后，即使你将数据库alter database open到open状态，还是会报同样的错误：
SQL>alter database open;
Database altered.
SQL>desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist
SQL>select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>desc dba_temp_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
也就是说，只要你在mount状态下desct过某个dba视图，oracle就不认识它了，除非你重启数据库.
oracle说这个bug影响的版本为Oracle Server - Enterprise Edition - Version: <8.1.7.4 to 10.1.0.3
我上面的操作是在10.2.0.3中，这么多版本了，oracle就一直没想过要修复这个问题。
解决方法：
1) Don't describe the dba_* views at mount stage.
2) If you issue DESC of any DBA_*views at mount stage, then shutdown and restart the
instance.
在mount状态的时候，如果你desc dba_*数据字典，会报错：
SQL>select status from v$instance;
STATUS
------------
MOUNTED
SQL>desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist
然后，即使你将数据库alter database open到open状态，还是会报同样的错误：
SQL>alter database open;
Database altered.
SQL>desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist
SQL>select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>desc dba_temp_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
也就是说，只要你在mount状态下desct过某个dba视图，oracle就不认识它了，除非你重启数据库.
oracle说这个bug影响的版本为Oracle Server - Enterprise Edition - Version: <8.1.7.4 to 10.1.0.3
我上面的操作是在10.2.0.3中，这么多版本了，oracle就一直没想过要修复这个问题。
解决方法：
1) Don't describe the dba_* views at mount stage.
2) If you issue DESC of any DBA_*views at mount stage, then shutdown and restart the
instance.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-705092/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/11780477/viewspace-705092/