**
Dan,
It looks like the communication to your DB server is established but poor at times.
Is that a remote database? If so hows your network - maybe you have network problems...
Do you have limited number of DB user connections open? Is the DB server used by other applications which might be exhausting the number of user connections to the server?
Do you get random errors like that when trying to connect to the Oracle server via SQLPlus or any other DB client that you might be using to run your SQL directly to the database? If you do it would possibly mean that the number of available user connections to the database is restricted - find out how many user connections have been configured and recinfigure that value... Each thread uses a user connection to the DB, so if the number of ARS threads is higher than the number of available user connections to the DB you could possibly see errors like that..
Hope this helps.....
Regards
Joe D'Souza
Remedy Developer / Consultant,
Shyle Networks,
New Jersey.
"Dan.Bloom@sympatico.ca" wrote:
**
Sadly, the change of client to 9.2.0.5 has not helped.
We do not have the option currently of move to 10.2
However, to get even more specific, I think it is only recon engine and mid-tier,
or may only be them and not the user tool that generates the errors. Haven't been
able to prove it yet.
I am going to turn on SQL logging again to get a look at that
(and all sorts of other diagnostics are going on).
But I was wondering if anyone has see this in their arerror.log s and have an idea?
Sat Mar 18 10:27:18 2006 390620 : SQL database is now available (ARNOTE 592)
Sat Mar 18 10:29:19 2006 390635 : SQL database is now available (ARNOTE 592)
Sat Mar 18 10:29:19 2006 Reconciliation : AR System Application server terminated when a signal/exception was received by the server (ARAPPNOTE 4500)
Sat Mar 18 10:29:19 2006 6
Sat Mar 18 10:29:19 2006 Reconciliation : AR System Application server restarting (ARAPPERR 4503)
Sat Mar 18 10:29:34 2006 390635 : SQL database is now available (ARNOTE 592)
Sat Mar 18 10:29:34 2006 Dispatch : Failure during SQL operation to the database (ORA-03113: end-of-file on communication channel) ARERR - 552
Sat Mar 18 10:29:34 2006 390620 : SQL database is now available (ARNOTE 592)
Sat Mar 18 10:30:19 2006 390620 : SQL database is now available (ARNOTE 592)
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Grooms, Frederick W
Sent: March 17, 2006 17:29
To: arslist@ARSLIST.ORG
Subject: Re: Oracle 10G 10.1.0.4.0 to ARS 6.3 which Oracle Client? Urgent
**
Yes 9.2.0.5 client. FYI: My DBA said there are known problems with 10.1 so you may want to bump up to 10.2.0.1.0 (we did a couple of weeks ago and I haven't seen any problems from it).
Fred
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dan.Bloom@sympatico.ca
Sent: Friday, March 17, 2006 4:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle 10G 10.1.0.4.0 to ARS 6.3 which Oracle Client? Urgent
**
I have been asked to clarify that we are on Oracle 10.1.0.4.0 to see if the answer is the same?
thanks ... Daniel
-----Original Mes sage-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Alfred Differ
Sent: March 17, 2006 17:14
To: arslist@ARSLIST.ORG
Subject: Re: Oracle 10G to ARS 6.3 which Oracle Client? Urgent
** I concur. We are doing that to two db's right now.
Relax. Yahoo! Mail virus scanning helps detect nasty viruses! 20060125This posting was submitted with HTML in it
Previous Topic
Index