Question: This ORA-12570 error error
occurs while trying to print a report in a PDF format using Oracle
Application Express 3.0.
ORA-29273: HTTP request
failed
ORA-06512: at
"SYS.UTL_HTTP", line 1186
ORA-12570: TNS: packet reader failure
Answer: As
to the Apex error, Oracle's HTML-DB guru Marc Sewtz
has this solution.
To see the root cause of an ORA-12570
error you need to turn on tracing and re-execute the command.
In many cases, a failure of the listener will not be logged on
the database server, but will instead be presented as a message on
the client workstation. Hence, the vast majority of listener
errors are reported by end-users. The docs note this on the
ORA-12570 error:
ORA-12570: TNS:packet reader
failure
Cause: An error occurred during a
data receive.
Action: Not normally visible
to the user. For further details, turn on tracing and re-execute the
operation. If error persists, contact Oracle Customer Support.
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|