ORA-00604 during startup

[Shivdeep]

Hi,

I am getting ORA-00604 during startup:
(9.2.0.3.0 - 64bit Production)

SQL> startup
ORACLE instance started.

Total System Global Area 253199000 bytes
Fixed Size 742040 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

The alert log indicates:
............
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
ORA-604 signalled during: ALTER DATABASE OPEN...

However i am able to query from the database and connect as other users. I have not tried anything else apart from this.
SQL> select count(*) from dba_users;

COUNT(*)
----------
75

SQL> conn omruser
Enter password:
Connected.

[hrishy]

Hi

Are there any database system triggers ?

regards
Hrishy

[Shivdeep]

No there are no database level triggers as such

[jovery]

Originally posted by Shivdeep
No there are no database level triggers as such

"as such"?? Either you have startup triggers or not.

Are you pinning objects into the SGA on startup?

Are you getting this message after upgrading from an 8.1.7 instance?

[Shivdeep]

1) Ok, there are no database level triggers.

SQL> startup
ORACLE instance started.

Total System Global Area 336560912 bytes
Fixed Size 742160 bytes
Variable Size 218103808 bytes
Database Buffers 117440512 bytes
Redo Buffers 274432 bytes
Database mounted.
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

SQL> select trigger_name, trigger_type, triggering_event from dba_triggers where triggering_event = 'STARTUP';

no rows selected

2) There are no objects pinned in the SGA on startup.
3) And no there was no upgrade from 8.1.7 instance. The database is
9.2.0.3.0 - 64bit Production.

[jovery]

Are you getting a trace file generated? If not have you tried adding the following to your parameter list:

event="942 trace name errorstack level 10"

and viewing the resulting trace to see if it gives any further details.

HTH

[Shivdeep]

After setting the event and restarting i get the follwoing in the trace file.

*** SESSION ID:(9.3) 2003-12-24 13:33:57.422
*** 2003-12-24 13:33:57.422
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"."http
config"."http-port", e.xmldata."sysconfig"."protocolconfig"."httpconfig"."http-protocol", e.xmldata."sysconfig"."protocolco
nfig"."httpconfig"."http-listener" from xdb.xdb$config e
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148 bl ksedst 1024815A4 ?
.....
......

Is it the probem with xdb schema? The object xdb.xdb$config does not exist

[pando]

have you done a migration recently?

what´s your compatible parameter?

[Shivdeep]

No we haven't done a migration. We had renamed a database in one case and created another one in other case.(So we have this happening in two cases).

Also
SQL> show parameter compatible

NAME TYPE VALUE
------------ ----------- ---------
compatible string 9.2.0.0.0

And as i mentioned the database runs fine with no problems.

[julian]

Originally posted by Shivdeep
Hi,

I am getting ORA-00604 during startup:
(9.2.0.3.0 - 64bit Production)

SQL> startup
ORACLE instance started.

Total System Global Area 253199000 bytes
Fixed Size 742040 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

The alert log indicates:
............
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
ORA-604 signalled during: ALTER DATABASE OPEN...

However i am able to query from the database and connect as other users. I have not tried anything else apart from this.
SQL> select count(*) from dba_users;

COUNT(*)
----------
75

SQL> conn omruser
Enter password:
Connected.

You might be missing the XMLTYPE table. If it is not there:

Try to rerun catqm.sql

Do you get the error afterwards?