ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?

2008-08-15 Thread Rabi Tripathi
Hi all, After a lot of issues trying to add language packs to existing ARS 7.1 p2 install, we're starting from scratch and doing a new install (Solaris , Oracle) to included most of the language packs available in ARS. If anybody has gone through this process and can share any lessons learned,

Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?

2008-08-15 Thread Axton
The two env vars that matter on the remedy server are: LC_ALL=en_US.UTF-8 LANG=en_US.UTF-8 On the oracle side, we use the AL32UTF8 as the character set with all the NLS stuff set up as America.American. Axton Grams On Fri, Aug 15, 2008 at 10:30 AM, Rabi Tripathi [EMAIL PROTECTED] wrote: Hi

Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?

2008-08-15 Thread Rabi Tripathi
Thanks Axon. I will keep these in mind. We'll be using the same settings. There is some confusion about the following oracle setting: NLS_LENGTH_SEMANTICS For unicode (oracle) databases, 7.0.1 install guide says it should be set to CHAR, 7.1 install guide says it should be set to BYTE. I'm

Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?

2008-08-15 Thread Axton
Our is set to BYTE. These parameters can be configured at the oracle instance level in either the spfile or init.ora, depending on your configuration, if you need them to stick. I will say hi :) Axton Grams On Fri, Aug 15, 2008 at 11:03 AM, Rabi Tripathi [EMAIL PROTECTED] wrote: Thanks Axon.

Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?

2008-08-15 Thread Rabi Tripathi
Thanks a lot William. We already had that setup in previous installation, but didn't know that app install would overwrite it. Good catch. --- William Rentfrow [EMAIL PROTECTED] wrote: I'd like to add that if your Oracle server is separate from your AR server you absolutely need to change

Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?

2008-08-15 Thread William Rentfrow
Actually - please post your results after installing - I'd like to confirm what experienced. The only way to do it here though would be to re-install and I'd rather chew off my own leg that do that. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?

2008-08-15 Thread Walters, Mark
It's a typo in 7.0 - you should be using BYTE. Mark From: Action Request System discussion list(ARSList) on behalf of Rabi Tripathi Sent: Fri 15/08/2008 16:03 To: arslist@ARSLIST.ORG Subject: Re: ARS 7.1 install on Oracle with language packs and unicode: any