Re: ARS 7.1 install on a virtual machine Windows 2008
Hello Listers, I've come to realize that it may be the Windows 2008 Enterprise that is causing some difficulty. I tried to do an uninstall of the ARSystem and received an OS_Err warning. On a side note. I am now trying to use an old desktop to install onto the remote super-big SQLServer. When I get to the Upgrade , Overwrite Share I choose upgrade and it starts to process but when the install tries to load forms and asks for the admin account (Demo, no password) the dialog flashes and returns. I know the Demo account is in the user-cache table with no password. I saw it in the db with a 1; in the shortgroup column. Oh why didn't I take the blue pill? Thanks, John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, September 18, 2008 4:41 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.1 install on a virtual machine Windows 2008 ** Joe, When I get to the step to enter the AR System Server DB info I get: Could not connect to ARSystem_dev with the parameters given. You can create ARSystem_dev as a new AR System server . . . . I have verified that the password used for ARAdmin by the dba was in fact AR#Admin#. Still can't get in. I appears to complete the install if I tell it to create a new ARSystem_dev but then I get an error at the end and the arerror.log file has Thu Sep 18 12:05:20 2008 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Thu Sep 18 12:06:01 2008 : Action Request System(R) Server Version 7.1.00 Build 200708221849 (c) Copyright 1991-2007 BMC Software, Inc. Thu Sep 18 12:06:01 2008 390695 : Unable to extract minor version from Java VM version string: 10.0-b23 (ARERR 9130) Thu Sep 18 12:06:01 2008 390600 : Failure during SQL operation to the database (ARERR 552) Thu Sep 18 12:06:01 2008 Cannot open database "ARSystem_dev" requested by the login. The login failed. (SQL Server 4060) Thu Sep 18 12:06:16 2008 390600 : Failure during SQL operation to the database (ARERR 552) I will try to do an uninstall and try again. Thanks, John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, September 18, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.1 install on a virtual machine Windows 2008 ** Hi John, On MS-SQL it is enough for the ARAdmin user to be the dbo of the ARSystem database. If the database has already been created, and the database user has already been created with the default ar#admin# password, the install script should be able to connect to the MS-SQL database without the need for the sa user name and password. You may need to create a configuration file (ar.cfg file in the expected directory) to fool the system that you are either doing a system upgrade or an overwrite, failing which I think the installation might not proceed as it will not find the ar.cfg file and will attempt to create a new instance for which it will require the sa username and password.. Joe - Original Message From: "Reiser, John J" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, September 18, 2008 3:08:54 PM Subject: ARS 7.1 install on a virtual machine Windows 2008 Hello Listers, ARS 7.1 Virtual Machine MS Windows Enterprise 2008 Remote MS SQL 2005 DB I am trying to get a development box built on this VM. The DBA created a DB for me, calling it ARSystem_dev and giving ARAdmin dbo permissions though it is not the dbo account. When I have done installations in the past I always had the SA account password. That is not allowed on this massive SQL Server. I have been made the dbo with my domain account but I am not a domain admin. I need to know, since the install instructions don't seem to have many options, just exactly how I need to configure the accounts on the server and in the DB to get this installation to work. Do I really need to be a domain admin? If so I guess I have to get one of them to do the installation. Also, does the Run As account for the BMC Remedy ARSystem Server need to be a domain admin or just a local admin. Thanks in advance and good to here from the Ike survivors. John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and b
Re: ARS 7.1 install on a virtual machine Windows 2008
Joe, When I get to the step to enter the AR System Server DB info I get: Could not connect to ARSystem_dev with the parameters given. You can create ARSystem_dev as a new AR System server . . . . I have verified that the password used for ARAdmin by the dba was in fact AR#Admin#. Still can't get in. I appears to complete the install if I tell it to create a new ARSystem_dev but then I get an error at the end and the arerror.log file has Thu Sep 18 12:05:20 2008 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Thu Sep 18 12:06:01 2008 : Action Request System(R) Server Version 7.1.00 Build 200708221849 (c) Copyright 1991-2007 BMC Software, Inc. Thu Sep 18 12:06:01 2008 390695 : Unable to extract minor version from Java VM version string: 10.0-b23 (ARERR 9130) Thu Sep 18 12:06:01 2008 390600 : Failure during SQL operation to the database (ARERR 552) Thu Sep 18 12:06:01 2008 Cannot open database "ARSystem_dev" requested by the login. The login failed. (SQL Server 4060) Thu Sep 18 12:06:16 2008 390600 : Failure during SQL operation to the database (ARERR 552) I will try to do an uninstall and try again. Thanks, John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, September 18, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.1 install on a virtual machine Windows 2008 ** Hi John, On MS-SQL it is enough for the ARAdmin user to be the dbo of the ARSystem database. If the database has already been created, and the database user has already been created with the default ar#admin# password, the install script should be able to connect to the MS-SQL database without the need for the sa user name and password. You may need to create a configuration file (ar.cfg file in the expected directory) to fool the system that you are either doing a system upgrade or an overwrite, failing which I think the installation might not proceed as it will not find the ar.cfg file and will attempt to create a new instance for which it will require the sa username and password.. Joe - Original Message From: "Reiser, John J" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, September 18, 2008 3:08:54 PM Subject: ARS 7.1 install on a virtual machine Windows 2008 Hello Listers, ARS 7.1 Virtual Machine MS Windows Enterprise 2008 Remote MS SQL 2005 DB I am trying to get a development box built on this VM. The DBA created a DB for me, calling it ARSystem_dev and giving ARAdmin dbo permissions though it is not the dbo account. When I have done installations in the past I always had the SA account password. That is not allowed on this massive SQL Server. I have been made the dbo with my domain account but I am not a domain admin. I need to know, since the install instructions don't seem to have many options, just exactly how I need to configure the accounts on the server and in the DB to get this installation to work. Do I really need to be a domain admin? If so I guess I have to get one of them to do the installation. Also, does the Run As account for the BMC Remedy ARSystem Server need to be a domain admin or just a local admin. Thanks in advance and good to here from the Ike survivors. John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: ARS 7.1 install on a virtual machine Windows 2008
Hi John, On MS-SQL it is enough for the ARAdmin user to be the dbo of the ARSystem database. If the database has already been created, and the database user has already been created with the default ar#admin# password, the install script should be able to connect to the MS-SQL database without the need for the sa user name and password. You may need to create a configuration file (ar.cfg file in the expected directory) to fool the system that you are either doing a system upgrade or an overwrite, failing which I think the installation might not proceed as it will not find the ar.cfg file and will attempt to create a new instance for which it will require the sa username and password.. Joe - Original Message From: "Reiser, John J" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, September 18, 2008 3:08:54 PM Subject: ARS 7.1 install on a virtual machine Windows 2008 Hello Listers, ARS 7.1 Virtual Machine MS Windows Enterprise 2008 Remote MS SQL 2005 DB I am trying to get a development box built on this VM. The DBA created a DB for me, calling it ARSystem_dev and giving ARAdmin dbo permissions though it is not the dbo account. When I have done installations in the past I always had the SA account password. That is not allowed on this massive SQL Server. I have been made the dbo with my domain account but I am not a domain admin. I need to know, since the install instructions don't seem to have many options, just exactly how I need to configure the accounts on the server and in the DB to get this installation to work. Do I really need to be a domain admin? If so I guess I have to get one of them to do the installation. Also, does the Run As account for the BMC Remedy ARSystem Server need to be a domain admin or just a local admin. Thanks in advance and good to here from the Ike survivors. John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
ARS 7.1 install on a virtual machine Windows 2008
Hello Listers, ARS 7.1 Virtual Machine MS Windows Enterprise 2008 Remote MS SQL 2005 DB I am trying to get a development box built on this VM. The DBA created a DB for me, calling it ARSystem_dev and giving ARAdmin dbo permissions though it is not the dbo account. When I have done installations in the past I always had the SA account password. That is not allowed on this massive SQL Server. I have been made the dbo with my domain account but I am not a domain admin. I need to know, since the install instructions don't seem to have many options, just exactly how I need to configure the accounts on the server and in the DB to get this installation to work. Do I really need to be a domain admin? If so I guess I have to get one of them to do the installation. Also, does the Run As account for the BMC Remedy ARSystem Server need to be a domain admin or just a local admin. Thanks in advance and good to here from the Ike survivors. John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?
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 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. Please say hi to aiping t. and mike f. --- 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"
Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?
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. > > > Please say hi to aiping t. and mike f. > > > --- 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.
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. > > > Please say hi to aiping t. and mike f. > > > --- 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"
Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?
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. 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. > > > Please say hi to aiping t. and mike f. > > > --- 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"
Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?
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. Please say hi to aiping t. and mike f. --- 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"
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. Please say hi to aiping t. and mike f. --- 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"
Re: ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?
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"
ARS 7.1 install on Oracle with language packs and unicode: any tips, pitfalls?
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"
ARS 7.1 Install
Hello and good day, I have had some issues when installing ARS 7.1 on a Solaris box with Oracle 9i and am looking for some clarification or other insights into the process. 1. ARS 7.1 Compatibility matrix indicates 9i or 10g is compatible however install failed due a requirement for 10g 32 bit client. The DBA indicates that 10g is only installed as a 64 bit application and that the 32 bit libraries are also installed at that time. Is this where I need to point the Remedy config file to use the 32bit client? 2. Are there any issues if the Oracle 9i DB for ARS 6.3 is upgraded to 10g. Thanks Ed LeBlanc, RAC, ITIL Senior Consultant RIGID Systems, LLC 10440 little Patuxent Parkway Suite 200 Columbia, MD 21044 Phone 904-607-9387 Fax 410-715-0848 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"