Ora-12592

Printable View

05-07-2009, 07:21 AM
rupert777

Ora-12592

Sometimes is this error:

ORA-12592: TNS:bad packet

Can you help me,what is a problem.
05-07-2009, 07:40 AM
PAVB

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.
05-07-2009, 08:40 AM
rupert777

I know what is oerr,but I need how can I resolve this problem. Via Oracle metalink?
05-07-2009, 08:50 AM
malay_biswal

Try metalink. They are there to support. They might suggest you to talk to your Server vendor.
05-07-2009, 10:41 AM
rupert777

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: TNS:protocol 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: TNS:protocol 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.
05-07-2009, 01:22 PM
PAVB

Quote:

Originally Posted by rupert777

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.