Kbase P95101: The cursor limit is ignored by the Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/12/2004 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
The cursor limit is ignored by the Oracle DataServer
The Progress client (_progres or prowin32) connection parameter has the -c specified
The cursor limit shows in the DataServer log(dataserv.lg) file does not match the cursor limit specified in the client connection parameter
The client connection parameter has the same cursor limit that is defined in the Oracle database's init.ora file
The connection parameter stored in the schema holder has the -c specified
CAUSE:
The cursor value, -c, stored in the schema holder connection parameter is overwriting the -c specified in the client connection parameter.
FIX:
Remove the cursor parameter -c from the schema holder connection parameter by following the step below:
1. Connect to the schema holder in a single user mode
_progres <path to the schema holder including the schema holder name> -1
or
prowin32 <path to the schema holder including the schema holder name> -1
2. From the editor click on Tools > Data Administration (for GUI)/Data Dictionary (for CHUI) screen.
3. Select Database menu > Select Working Databases and choose the Database type Oracle listed below the schema holder name and click OK.
4. Select DataServer menu > Oracle Utilities > Edit Connection Information...
5. Delete -c cursor parameter from the connection parameters and save it by clicking OK.