Home » SQL & PL/SQL » SQL & PL/SQL » Same SQL work differently in different SQL Plus (Oracle 11g)
Same SQL work differently in different SQL Plus [message #646060] Fri, 18 December 2015 10:59 Go to next message
jayakumar.u05
Messages: 5
Registered: December 2015
Junior Member
I have a SQL against Oracle 11 g Database and I am trying to execute the same SQL from SQL clients having same versions from different machines. In some of them SQL execute successfully and in some other clients it throws end of communication channel error. There is no connectivity issue between client and server through
Same SQL work differently in different SQL Plus [message #646061 is a reply to message #646060] Fri, 18 December 2015 10:59 Go to previous messageGo to next message
jayakumar.u05
Messages: 5
Registered: December 2015
Junior Member
I have a SQL against Oracle 11 g Database and I am trying to execute the same SQL from SQL clients having same versions from different machines. In some of them SQL execute successfully and in some other clients it throws end of communication channel error. There is no connectivity issue between client and server through
Re: Same SQL work differently in different SQL Plus [message #646062 is a reply to message #646061] Fri, 18 December 2015 11:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Do NOT cross/multi-post.


Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide

How to use {code} tags and make your code easier to read


We need you to COPY & PASTE the complete error code & message
Re: Same SQL work differently in different SQL Plus [message #646063 is a reply to message #646062] Fri, 18 December 2015 11:51 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Based on the given information, something seems to be broken on the client's where it doesn't work.

So one solution would be to change the installation on the clients where it doesn't work to the same setup as on the clients where it does work.
Re: Same SQL work differently in different SQL Plus [message #646067 is a reply to message #646063] Fri, 18 December 2015 14:14 Go to previous messageGo to next message
jayakumar.u05
Messages: 5
Registered: December 2015
Junior Member
Other SQLs are working against the same Database from client machine which has issues. And Client installations are identical. So I am thinking what else could go wrong
Re: Same SQL work differently in different SQL Plus [message #646068 is a reply to message #646067] Fri, 18 December 2015 14:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You have a mystery & we have no clues.

When you observe different results, then you can be sure that something is different.
Only you can compare & contrast since it works OK for us.


Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Re: Same SQL work differently in different SQL Plus [message #646069 is a reply to message #646068] Fri, 18 December 2015 14:33 Go to previous messageGo to next message
jayakumar.u05
Messages: 5
Registered: December 2015
Junior Member
I see another difference , where most of the TNS entries connect via 1521, this one connects through 1500. Will it make any difference? But 1500 is common for this DB in all servers
Re: Same SQL work differently in different SQL Plus [message #646070 is a reply to message #646069] Fri, 18 December 2015 14:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Do NOT tell us what you think you see.

use COPY & PASTE to show us!

It appears that you have multiple DB Severs with multiple databases which support multiple clients & most work without error.
We still do NOT know what you do that throws the error & we don't know the actual & complete error.
So show us what works & what fails.
Do you have multiple listeners on the DB Server that is involved with you mystery error?

In order to provide you with an actual solution, we need to actually know what problem you have.
Re: Same SQL work differently in different SQL Plus [message #646071 is a reply to message #646070] Fri, 18 December 2015 14:57 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The most important fact would be:

- Does the error happen during the connection to the DB...
- ... or does it happen after a successful connection when the actual SQL is already executed.

But, as BlackSwan said, without seeing the actual session with the actual error that is just guesswork.
Re: Same SQL work differently in different SQL Plus [message #646072 is a reply to message #646071] Fri, 18 December 2015 16:00 Go to previous messageGo to next message
jayakumar.u05
Messages: 5
Registered: December 2015
Junior Member
Here is the actual error message- and this is not happening from all of the clients even though they have same versions and TNS etc

The connection to the "XXXXX" database has been terminated due to an unrecoverable error. ORA-03113: end-of-file on communication channel Process ID: 79763 Session ID: 779 Serial number
Re: Same SQL work differently in different SQL Plus [message #646073 is a reply to message #646072] Fri, 18 December 2015 16:03 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I give up.

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Previous Topic: dynamic Column header using Pivot operator
Next Topic: find missing record
Goto Forum:
  


Current Time: Fri Jun 26 18:20:36 CDT 2026