Kbase 15452: Getting error 1252 and ORACLE error 604 when running ProtoOra against a db schema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/2/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle 7.x
SYMPTOM(s):
Getting error 1252 and ORACLE error 604 when running ProtoOra
ORACLE error 604 see "ORACLE Error Messages and Codes Manual". (1252)
ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)
Original database has a large schema
error or-00604:"error occurred at recursive SQL level"
//*Cause: An error occurred while processing a reCursive SQL statement
// (a statement applying to internal dictionary tables).
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Increase the value of open cursors in your init.ora.
1) Edit the init.ora file of the particular instance and add the
following line:
open_cursors = 500
2) Restart ORACLE instance and check the following:
unix> sqldba lmode=y
SQLDBA> connect internal
connected
SQLDBA> show parameter open_cursors
NAME TYPE VALUE
----------------------------------- ------- ---------------------
open_cursors integer 500
SQLDBA>exit