DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: ORA-00604 during startup

  1. #11
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    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
    When everything is lost, future still remains.

  2. #12
    Join Date
    May 2002
    Location
    England
    Posts
    78
    Did you get any errors when you ran catqm.sql? And can you
    describe xdb.xdb$config?

  3. #13
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    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.
    Last edited by Shivdeep; 12-29-2003 at 07:27 AM.
    When everything is lost, future still remains.

  4. #14
    Join Date
    May 2002
    Location
    England
    Posts
    78
    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

  5. #15
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  6. #16
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    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.
    When everything is lost, future still remains.

  7. #17
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    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?
    When everything is lost, future still remains.

  8. #18
    Join Date
    May 2002
    Location
    England
    Posts
    78
    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

  9. #19
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    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.
    When everything is lost, future still remains.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width