RE: found dead shared server

Jeffrey,

>Implemented MTS in Production Oracle Applications database
>this morning.

I am not sure Oracle would support MTS in OA. For sure, MTS is not advised in either a batch-mode environment or in an OLTP environment where the queries are not short, one-liners. Although one may argue that the Forms mode and Self-Service of OA generate short queries, the Concurrent Managers certainly do not.

So I would ask this question: Is there a separate TNS handle for the CM that goes to dedicated servers and a separate handle that goes from the Forms/Self-service layer? If not, then it is very possible that your dead server is because of a misconfigured configuration.

Regards,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

http://tahiti.oracle.com - Manuals for DBAs (English only) http://www.bibleserver.com - Manual for Life (in English, Deutsch, French, Italian, Spanish, Portugese, Turkish,...)

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

  ---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

  ---

  To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

  ---