-
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.
-
Hi
Are there any database system triggers ?
regards
Hrishy
-
No there are no database level triggers as such
When everything is lost, future still remains.
-
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!
-
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.
-
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!
-
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.
-
have you done a migration recently?
what´s your compatible parameter?
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|