OraFAQ Forum: SQL & PL/SQL » Same SQL work differently in different SQL Plus

Home » SQL & PL/SQL » SQL & PL/SQL » Same SQL work differently in different SQL Plus (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Same SQL work differently in different SQL Plus [message #646060]

Fri, 18 December 2015 10:59

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

Report message to a moderator

Same SQL work differently in different SQL Plus [message #646061 is a reply to message #646060]

Fri, 18 December 2015 10:59

jayakumar.u05
Messages: 5
Registered: December 2015

Junior Member

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646062 is a reply to message #646061]

Fri, 18 December 2015 11:28

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

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646063 is a reply to message #646062]

Fri, 18 December 2015 11:51

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.

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646067 is a reply to message #646063]

Fri, 18 December 2015 14:14

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

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646068 is a reply to message #646067]

Fri, 18 December 2015 14:21

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

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646069 is a reply to message #646068]

Fri, 18 December 2015 14:33

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

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646070 is a reply to message #646069]

Fri, 18 December 2015 14:49

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.

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646071 is a reply to message #646070]

Fri, 18 December 2015 14:57

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.

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646072 is a reply to message #646071]

Fri, 18 December 2015 16:00

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

Report message to a moderator

Re: Same SQL work differently in different SQL Plus [message #646073 is a reply to message #646072]

Fri, 18 December 2015 16:03

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

Report message to a moderator

Previous Topic:	dynamic Column header using Pivot operator
Next Topic:	find missing record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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