Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

ORA-12592: TNS:bad packet

ORA-12592: TNS:bad packet

I'm getting oracle error "ORA-12592: TNS:bad packet" on Oracle 11g. It happens when reading from the database on an app server separate from the db server. The read fails.

Anyone seen this before? What did you do to fix it?

RE: ORA-12592: TNS:bad packet


Conventional wisdom on this error says If you are getting TNS error (on an irregular basis, i.e., not easily or reliably reproduceable) and query not using DBLINK (no SQL*Net), then failure occurs at network level between client & DB server. This means it is likely not an Oracle problem, but basic OS/network issue.

Get local Network Administrator involved to find & fix root cause.

(aka Dave of Sandy, Utah, USA)
"People may forget what you say, but they will never forget how you made them feel."

RE: ORA-12592: TNS:bad packet

Thanks! I've requested the network administrator take a look. How do we know we are not using DBLINK?

RE: ORA-12592: TNS:bad packet

Quote (Prbnc):

How do we know we are not using DBLINK?
First thing you can do is run this query as the user whose DB links are the subject of your investigation:


col db_link format a30
col host format a30
col x heading "DB Links"
select substr(db_link,1,decode(instr(db_link,'.')
             ) db_link, host
  from user_db_links
order by db_link
This query shows any database links that exist that the user owns.

Second option is investigate your application code. Search of occurrences of the "@" embedded in a SQL statement. (Database links use the "@" to designate the db link to use. Example:


SQL> select count(*) from user_tables;


SQL> select count(*) from user_tables@dlha099;

The first SELECT does not use a database link; the second SELECT uses a database link named "dlha099".

Let us know if you have follow-up questions.


(aka Dave of Sandy, Utah, USA)
"People may forget what you say, but they will never forget how you made them feel."

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close