Saturday, 28 January 2012

ORA-02797: No requests available

ORA-02797: No requests available

Cause: No free request descriptors are available.

Action: Wait until some requests are filled and then retry the request, or shutdown the servers and initialize the package with a higher number of requests.

ORA-02796: Done request is not in correct state

ORA-02796: Done request is not in correct state

Cause: A request is not in the right state.

Action: Internal error - contact ORACLE support.

ORA-02795: Request list is empty

ORA-02795: Request list is empty

Cause: The client was signalled by a server that it was done with a request but the done list was empty.

Action: Internal error - contact ORACLE support.

ORA-02794: Client unable to get key for shared memory

ORA-02794: Client unable to get key for shared memory

Cause: The client was unable to get a key so that it obtain shared memory for use with shared memory.

Action: Contact ORACLE support - this is an internal error.

ORA-02793: Close of asynchronous I or O failed.

ORA-02793: Close of asynchronous I or O failed.

Cause: The client was unable to close a file being used for asynchronous I or O.

Action: Contact ORACLE support - this should not happen.

ORA-02792: Unable to fstat() a file being used for asynchronous I or O.

ORA-02792: Unable to fstat() a file being used for asynchronous I or O.

Cause: The fstat(2) call on a file being used for asynchronous I or O failed.

Action: Check the file name.

ORA-02791: Unable to open file for use with asynchronous I or O

ORA-02791: Unable to open file for use with asynchronous I or O

Cause: The package could not open file for some reason.

Action: Check the file name.