Oracle Bug ORA-04043
Someone tested Oracle bug ORA-04043 in Oracle 11.0.2.0 under Win, and then carried out the test on his own machine, the test process is as follows:
SQL> select * from v $ version where rownum = 1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 146803800 bytes
Database Buffers 159383552 bytes
Redo Buffers 6336512 bytes
Database mounted.
SQL> desc dba_users;
ERROR:
ORA-04043: object dba_users does not exist
SQL> alter database open;
Database altered.
SQL> desc dba_users;
ERROR:
ORA-04043: object dba_users does not exist
SQL> alter system flush shared_pool;
System altered.
SQL> desc dba_users;
Name Null? Type
-----------------------------------------------------------------------------
Username not null VARCHAR2 (30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2 (30)
ACCOUNT_STATUS not null VARCHAR2 (32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE not null VARCHAR2 (30)
TEMPORARY_TABLESPACE not null VARCHAR2 (30)
CREATED NOT NULL DATE
Profile not null VARCHAR2 (30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2 (30)
EXTERNAL_NAME VARCHAR2 (4000)
PASSWORD_VERSIONS VARCHAR2 (8)
EDITIONS_ENABLED VARCHAR2 (1)
AUTHENTICATION_TYPE VARCHAR2 (8)
Some guys checked on MOS. It was a bug with the ID of 2365821.
Abstract: ORA-4043 on dba _ * tables if they are described in a mount stage.
During the mount phase desc, The ora-04043 still appears after the open query, either restart once or flush shared pool once.