Re: ORA-00604 during startup
You might be missing the XMLTYPE table. If it is not there:
Originally posted by Shivdeep
I am getting ORA-00604 during startup:
(184.108.40.206.0 - 64bit Production)
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
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;
SQL> conn omruser
Try to rerun catqm.sql
Do you get the error afterwards?