ORA-00604 during startup

[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

[jperusco]

Did you get any errors when you ran catqm.sql? And can you
describe xdb.xdb$config?

[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.

[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

[julian]

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?

[Shivdeep]

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.

[Shivdeep]

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?

[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

[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.