Solved

I am trying to execute some of the queries through Toad. I am getting the error

Posted on 2011-09-19
9
352 Views
Last Modified: 2012-05-12
I am trying to execute some of the queries through Toad. I am getting the error ORA-12571: TNS:packet writer failure
0
Comment
Question by:nirvairghuman
  • 5
  • 4
9 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
Comment Utility
Is this a new install?
Can you query tables with Toad?
Can you connect using sqlplus?

For starters, disable your local firewall and try.
0
 

Author Comment

by:nirvairghuman
Comment Utility
yes, This is new install
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
Comment Utility
That answers one of the questions.

What about the others?
0
 

Author Comment

by:nirvairghuman
Comment Utility
Can you query tables with Toad?

Yes
Can you connect using sqlplus?
No,
For starters, disable your local firewall and try.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
Comment Utility
>>Can you query tables with Toad?  Yes
>>Can you connect using sqlplus?  No,

These mean the opposite.  If you can query the tables in Toad, you are connecting to the database.  If you cannot connect through sqlplus then I wonder how you are connecting with Toad?

>>For starters, disable your local firewall and try.
 
Did you try this?  Did it change anything?
0
 

Author Comment

by:nirvairghuman
Comment Utility
can you query tables with toad,
Means to say some time when i execute any query and some time in the middle of fetching I get this error
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
Comment Utility
>>when i execute any query and some time in the middle of fetching I get this error

OK.  It sounds like you are having some Network Issues.

I would work with your Network Admins to help you figure them out.

If you look up the text for the ORA-12571 it mentions that you shouldn't see this error and you should contact Oracle Support.
0
 

Author Comment

by:nirvairghuman
Comment Utility
Do you have any other suggestions for this problem.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
Comment Utility
You might try a ping loop from the client machine to the database server and see if you drop packets around the time you receive the ORA-12571.

ping -t -l 1 <dbserver_ip_address>
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now