Solved

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

Posted on 2011-09-19
9
355 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
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 76

Assisted Solution

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

What about the others?
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.

 

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 76

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 76

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 76

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

774 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