ORA-00604 during startup
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: ORA-00604 during startup

Hybrid View

  1. #1
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20

    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.
    When everything is lost, future still remains.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Are there any database system triggers ?

    regards
    Hrishy

  3. #3
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    No there are no database level triggers as such
    When everything is lost, future still remains.

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    have you done a migration recently?

    what´s your compatible parameter?

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

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: ORA-00604 during startup

    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?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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