Kbase P122287: Oracle error ORA-1116 during the creation of schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/16/2007 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
Oracle DataServer
SYMPTOM(s):
Oracle error ORA-1116 during the creation of schema holder
The error is apparent in the unified broker and the dataserver log file
ORA-1116: error in opening database file %s
The above error happens after the selection criteria is supplied
With the verbose logging, the above error is apparent after several Oracle system tables are queried by the DataServer
Each of the individual queries listed on the dataserver log with verbose logging can be run from the sqlplus session with success
Running all the queries at once on a sqlplus with the spool file output revealed both ORA-1116 and ORA-27092 errors
ORA-27092: skgfofi: size of file exceeds file size limit of the process
CAUSE:
The ulimit for the user was set to 2 GB which was smaller then the Oracle process's size. Therefore, the dataserver process could not open the file.
FIX:
Increase the ulimit for the user.