Question: I see this message in my error
stack indicating an ORA-609 error:
TNS-12560: TNS:protocol
adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
ORA-609 : opiodr aborting process unknown
ospid (1476_6304)
What is the solution for the ORA-609 error?
Answer:
In this case, the ORA-609 is a "secondary" error, a result of the
preceding
TNS-12560 error. To diagnose any error, you
start by using the
oerr utility to display the ORA-00609 error:
ORA-00609: could not
attach to incoming connection
Cause:
Oracle process could not answer incoming connection
Action: If the situation described in the next error
on the stack can be corrected, do so; otherwise contact Oracle
Support.
The solution is to first check for any trace files, then open an
SR on Oracle MOSC.
|
|
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.
|