Let me introduce you to the magic of Oracle's oerr utility...
oerr ora 12592
12592, 00000, "TNS:bad packet"
// *Cause: An ill-formed packet has been detected by the TNS software.
// *Action: For further details, turn on tracing and reexecute the
// operation. If error persists, contact Oracle Customer Support.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Does it possible that this ORA error realete with problem:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=********)(PORT=*******)))
STATUS of the LISTENER
------------------------
Alias *****
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production
Start Date 08-MAR-2009 15:02:52
Uptime 59 days 21 hr. 30 min. 31 sec
Trace Level off
.........
(to be continue)
and
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=************)(PORT=*****)))
Services Summary...
Service "*****" has 1 instance(s).
.......(to be continue)
Listener is running and connection to the database is ok.
I know what is oerr,but I need how can I resolve this problem. Via Oracle metalink?
Yes, your primary source of Oracle technical info should be Metalink.
Here is how you solve the issue: *Action: For further details, turn on tracing and reexecute the operation. If error persists, contact Oracle Customer Support.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Bookmarks