Blog Archives

ORA-01403: no data found

Message: ORA-01403: no data found Cause: No data was found from the objects. Action: There was no data from the objects which may be due to end of fetch. Explanation and Troubleshooting Tips: The most common reason for this error

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-24247: network access denied by access control list (ACL)

Message: ORA-24247: network access denied by access control list (ACL) Cause: No access control list (ACL) has been assigned to the target host or the privilege necessary to access the target host has not been granted to the user in

Posted in Explained, ORA codes, Troubleshooting Tips Tagged with:

ORA-12511: TNS:service handler found but it is not accepting connections

Message: ORA-12511: TNS:service handler found but it is not accepting connections Cause: The dispatchers notified the listener that they temporarily do not accept new connections. Action: Attempt the connection again. If error persists, contact the DBA to check the state

Posted in ORA codes

ORA-06512: at … line …

Message: ORA-06512: at string line string Cause: Backtrace message as the stack is unwound by unhandled exceptions. Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-30768: Cannot evaluate pipelined function

Message: ORA-30768: Cannot evaluate pipelined function Cause: Pipelined functions can only be used in a TABLE expression in the from clause. Action: Use a non-pipelined function instead.

Posted in ORA codes

ORA-06548: no more rows needed

Message: ORA-06548: no more rows needed Cause: The caller of a pipelined function does not need more rows to be produced by the pipelined function. Action: Catch the NO_DATA_NEEDED exception in an exception handling block. Explanation: This message is linked

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-07445: exception encountered: core dump […] […] […] […] […] […]

Message: ORA-07445: exception encountered: core dump [string] [string] [string] [string] [string] [string] Cause: An OS exception occurred which should result in the creation of a core file. This is an internal error. Action: Contact your customer support representative. See also:

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-01422: exact fetch returns more than requested number of rows

Message: ORA-01422: exact fetch returns more than requested number of rows Cause: The number specified in exact fetch is less than the rows returned. Action: Rewrite the query or change number of rows requested. Explanation and Troubleshooting Tips: An exact

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-29270: too many open HTTP requests

Message: ORA-29270: too many open HTTP requests Cause: Too many HTTP requests were opened. Action: End some HTTP requests and retry the HTTP request. Explanation and Troubleshooting Tips: There is a limit to the number of HTTP requests that can

Posted in Explained, ORA codes, Troubleshooting Tips Tagged with:

ORA-31679: Table data object … has long columns, and longs can not be loaded/unloaded using a network link

Message: ORA-31679: Table data object string has long columns, and longs can not be loaded/unloaded using a network link Cause: Table data objects that contain long columns can not be selected over a network link. Action: Export this table to

Posted in Explained, ORA codes, Troubleshooting Tips Tagged with: , , , ,