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 PROTECTED] On Behalf Of Rabi Tripathi Sent: Friday, August 15, 2008 12:28 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls? 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 the CLOB storage option to in-row > or else there are severe performance penalties that are a royal pain > in the neck to troubleshoot. > > BMC has a white paper with instructions and an Oracle stored procedure > to complete this taks. > > Also, this task must be done after installation of the apps. If you > try doing it before you install the apps and after you install the AR > server the installs "correct" your setting back to the default setting > of "F". > I have reported that bug to BMC engineering as recently as yesterday. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi > Sent: Friday, August 15, 2008 10:03 AM > To: arslist@ARSLIST.ORG > Subject: Re: ARS 7.1 install on Oracle with language packs and > unicode: > any tips, pitfalls? > > 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 wondering if one of them is a typo or each one is correct for each > version. > > We also had issues changing this setting in oracle. > We tried "ALTER.." > to change it, but didn't seem to stick even after restarting oracle. > We also tested setting this as a shell variable and doing sqlplus, but > our session doesn't pick it up. However, I believe this is a server > side setting. > > <personal message tunnel> > Please say hi to aiping t. and mike f. > </personal message tunnel> > > --- Axton <[EMAIL PROTECTED]> wrote: > > > 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 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, caveats, I would > appreciate. > > > > > > When it comes to internationalization, > > localization, > > > I've experienced that because all the settings > > have to > > > be just right at multiple levels (OS, database, > > ARS, > > > client) it's a challenge to get it to work. > > > > > > So I'm trying to pick anybody's brain to > > supplement > > > reading through the install guides, release > notes > > and > > > what not. > > > > > > Thanks in advance. > > > > > > Oracle 10g Release 10.2.0.4.0 - 64bit SunOS 5.10 > (separate box for > > > ars and db) Installing ARS 7.1 p2 > > > > > > > > > > > > > > > > > > > > > > > > ________________________________________________________________________ > _______ > > > UNSUBSCRIBE or access ARSlist Archives at > > www.arslist.org > > > Platinum Sponsor: www.rmsportal.com ARSlist: > > "Where the Answers Are" > > > > > > > > ________________________________________________________________________ > _______ > > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org Platinum > > Sponsor: www.rmsportal.com ARSlist: "Where the > Answers Are" > > > > > > > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"