My Oracle Support Banner

Ora-00942: Table Or View Does Not Exist Error At Startup After 9.2.0.6 Upgrade (Doc ID 335680.1)

Last updated on APRIL 06, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.5 and later
Information in this document applies to any platform.

Symptoms

 

SQL> startup
    ORACLE instance started.
    Total System Global Area  957697448 bytes
    Fixed Size                   732584 bytes
    Variable Size             285212672 bytes
    Database Buffers          671088640 bytes
    Redo Buffers                 663552 bytes
    Database mounted.
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist

 

TRACE FILE SHOWS

ksedmp: internal or fatal error
ORA-00942: table or view does not exist


Current SQL statement for this session:
select e.xmldata."sysconfig"."protocolconfig"."ftpconfig"."ftp-port",
e.xmldata."sysconfig"."protocolconfig"."ftpconfig"."ftp-protocol",
e.xmldata."sysconfig"."protocolconfig"."ftpconfig"."ftp-listener",
e.xmldata."sysconfig"."protocolconfig"."httpconfig"."http-port",
e.xmldata."sysconfig"."protocolconfig"."httpconfig"."http-protocol",
e.xmldata."sysconfig"."protocolconfig"."httpconfig"."http-listener" from xdb.xdb$config e

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.