ORA-00604 during startup

Printable View

12-20-2003, 06:36 AM
Shivdeep

ORA-00604 during startup

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.
12-21-2003, 03:03 AM
hrishy

Hi

Are there any database system triggers ?

regards
Hrishy
12-23-2003, 06:28 AM
Shivdeep

No there are no database level triggers as such
12-23-2003, 06:46 AM
jovery

Quote:

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?
12-23-2003, 08:12 AM
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.
12-23-2003, 08:35 AM
jovery

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

Code:

event="942 trace name errorstack level 10"

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

HTH
12-24-2003, 07:12 AM
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
12-24-2003, 10:20 AM
pando

have you done a migration recently?

what´s your compatible parameter?
12-25-2003, 01:35 AM
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.
12-26-2003, 05:53 AM
julian

Re: ORA-00604 during startup

Quote:

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?
12-29-2003, 06:15 AM
Shivdeep

After running catqm.sql i still get the same error. And there is no table of the name XMLTYPE either.
SQL> select object_name, object_type , owner , status from dba_objects where object_name='XMLTYPE';

OBJECT_NAME OBJECT_TYPE OWNER STATUS
------------------------------ --------------- --------------- -------
XMLTYPE TYPE SYS VALID
XMLTYPE TYPE BODY SYS VALID
XMLTYPE SYNONYM PUBLIC VALID
12-29-2003, 06:38 AM
jperusco

Did you get any errors when you ran catqm.sql? And can you
describe xdb.xdb$config?
12-29-2003, 07:22 AM
Shivdeep

Yes I did get some errors while running catqm.sql
Apart from the errors for re-creating existing objects I got ORA-0600 a couple of times.Below is a sample of the error

declare
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [unable to load XDB library], [],
[], [], [], [], [], []
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at line 129

And no i cannot describe xdb.xdb$config.
12-29-2003, 07:57 AM
jperusco

Hi Again,

It might be a problem with your LD_LIBRARY_PATH...

Set LD_LIBRARY_PATH and LIBPATH to the values

csh :
$ setenv LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ setenv LIBPATH=$ORACLE_HOME/lib

ksh :
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ export LIBPATH=$ORACLE_HOME/lib

if they are not already set and then rerun catqm.sql
12-29-2003, 09:54 AM
julian

Quote:

Originally posted by Shivdeep
Yes I did get some errors while running catqm.sql
Apart from the errors for re-creating existing objects I got ORA-0600 a couple of times.Below is a sample of the error

declare
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [unable to load XDB library], [],
[], [], [], [], [], []
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at line 129

And no i cannot describe xdb.xdb$config.

Well, that's the problem. Did you get the ORA-600 after setting LD_LIBRARY_PATH and LIBPATH?
12-31-2003, 01:28 AM
Shivdeep

Quote:

Originally posted by jperusco
Hi Again,

It might be a problem with your LD_LIBRARY_PATH...

Set LD_LIBRARY_PATH and LIBPATH to the values

csh :
$ setenv LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ setenv LIBPATH=$ORACLE_HOME/lib

ksh :
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ export LIBPATH=$ORACLE_HOME/lib

if they are not already set and then rerun catqm.sql

Hi,

If that is the case then i must get this message for all the databases in the oracle home where i have the database in question. The other databases DO NOT return ORA-604 on startup.
12-31-2003, 01:34 AM
Shivdeep

Quote:

Originally posted by julian
Well, that's the problem. Did you get the ORA-600 after setting LD_LIBRARY_PATH and LIBPATH?

As i had replied to jperusco, i should get the same message for the other database in the same oracle home also. But i don not.
What should be the values for LD_LIBRARY_PATH and LIBPATH wrt to ORACLE_HOME?
12-31-2003, 05:59 AM
jperusco

a simple test on the other databases would be to see if you
can describe xdb.xdb$config. my bet is you can.

the value of ORACLE_HOME should already be set. if you run

echo $ORACLE_HOME

this should return something like /u01/oracle/product/9.2.0.3/
or something similar.

Then run the two exports above and you should be able to echo $LD_LIBRARY_PATH and $LIBPATH which something like /u01/oracle/product/9.2.0.3/lib.

HTH
01-02-2004, 12:20 AM
Shivdeep

The problem lies in the xdb schema. On removing the schema by running catnoqm.sql, the message during startup did not appear. It seems that the schema xdb was not set up correctly.