Solved

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

Posted on 2011-09-19
9
358 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 250 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 250 total points
ID: 36561701
That answers one of the questions.

What about the others?
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

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 250 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 250 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 250 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
exp/imp 25 101
Component is listed with a Protocol more than once 3 47
Oracle Query - Convert letters to numbers and display the difference 3 45
Read XML values 8 58
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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

733 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