Kbase P71089: Client connection to Oracle DataServer refuses with error 1461
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/03/2009 |
|
Status: Verified
SYMPTOM(s):
Client connection to Oracle DataServer refuses with error 1461
Schema holder does not match database schema -- file field . (1461)
Messages 6442 and 6443 appears in dataserv.lg
Closing cursor number to reduce the number of cursor from . (6442)
Cursor limit reset from to (6443)
Cursor limit reset from 2999 to 499 (6443)
Unable to locate index '<indexname>' on table '<tablename>' for procedure '<procedure>'. (7967)
Invalid or inappropriate handle value given to DELETE OBJECT or DELETE PROCEDURE statement. (5425)
ORA-00604: error occurred at recursive SQL level 1
FACT(s) (Environment):
Retrying to connect succeeds
All Supported Operating Systems
Oracle
Progress 8.x
Progress 9.x
OpenEdge 10.x
CAUSE:
The number of cursors specified by -c is greater than the number ORACLE can supply.
When ORACLE is unable to open a cursor for its internal use, error ORA-604 occurs.
Cursors can become available, hence sometimes a user is able to connect if connecting is retried.
FIX:
Increase the number of cursors defined for the Oracle database. Modify OPEN_CURSORS parameter into init.ora file. The default is 50.