Re: ARS 7.1 install on a virtual machine Windows 2008

2008-09-18 Thread Reiser, John J
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

2008-09-18 Thread Reiser, John J
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

2008-09-18 Thread Joe DeSouza
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

2008-09-18 Thread Reiser, John J
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?

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 
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?

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 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?

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 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?

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. 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?

2008-08-15 Thread William Rentfrow
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?

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 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?

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 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?

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, 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

2007-11-01 Thread Ed LeBlanc
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"