Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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.

prbnc (TechnicalUser) (OP)
3 Feb 12 11:21
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?
SantaMufasa (TechnicalUser)
3 Feb 12 12:18
Prbnc,

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.

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

prbnc (TechnicalUser) (OP)
3 Feb 12 12:37
Thanks! I've requested the network administrator take a look. How do we know we are not using DBLINK?
Helpful Member!  SantaMufasa (TechnicalUser)
3 Feb 12 13:14

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:

CODE

col db_link format a30
col host format a30
col x heading "DB Links"
select substr(db_link,1,decode(instr(db_link,'.')
                              ,0,length(db_link)
                              ,instr(db_link,'.')-1
                              )
             ) 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:

CODE

SQL> select count(*) from user_tables;

  COUNT(*)
----------
       115

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

  COUNT(*)
----------
        23
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.

 

santaMufasa
(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