Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-09-19
9
Medium Priority
?
362 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 total points
ID: 36561655
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
ID: 36561687
yes, This is new install
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 36561701
That answers one of the questions.

What about the others?
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:nirvairghuman
ID: 36561813
Can you query tables with Toad?

Yes
Can you connect using sqlplus?
No,
For starters, disable your local firewall and try.
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 36561839
>>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
ID: 36561880
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 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 36561897
>>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
ID: 36563208
Do you have any other suggestions for this problem.
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 36566717
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

719 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