Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Mike Chepaykin

You have to check that your mssql2005express has sql authentication turned on. 
By default only windows authentication is turned on.

I run batch of ars servers on mssql2005express, flight is high! :)


Tried using SQL server 2005 express edn (free) on my laptop with ARS 7.
The installation was failing. Anyone tried it successfully. 


--
Mike Chepaykin

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Moore, Chris
Also, be prepared for it to take a long time- I've been installing all
the newest apps on a desktop P4 with 2 GB RAM and got through most of it
ok but the SLA bit has been running for 8 days now.  It's still going,
but the processor is pegged out at 100% 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Chepaykin
Sent: Wednesday, June 20, 2007 2:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

You have to check that your mssql2005express has sql authentication
turned on. By default only windows authentication is turned on.

I run batch of ars servers on mssql2005express, flight is high! :)

 Tried using SQL server 2005 express edn (free) on my laptop with ARS
7.
 The installation was failing. Anyone tried it successfully. 

-- 
Mike Chepaykin


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Guillaume Rheault

great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample data 
(excluding the product dictionary)



From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


Yes, using it on my laptop with 7.x But only for small development tasks...

--
Jarl

On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:

**

Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), but
maybe somebody has given it a shot...

XE is free since 02/2006, according to this Oracle press release:

http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

The software can be downloaded for free from the Oracle Technology Network
at: http://www.oracle.com/technology/xe. Oracle Database XE
is available for download, usage and distribution at no charge.

Any feedback is appreciated

thx, Guillaume





  __20060125___This posting was
submitted with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Rick Cook
Ours, even after all the configuration data was in (including LDAP and a
truncated DSL), fit in about 1 GB (on Oracle 9), until we started importing
asset records from Discovery, at which time it ballooned to about 10 GB.  So
even with Oracle 10, I would think 4 GB should hold plain ITSM 7 without
FD/TD.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample
data (excluding the product dictionary)

  _  

From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


Yes, using it on my laptop with 7.x But only for small development tasks...



--

Jarl



On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:

 **



 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?

 Oracle 10g XE is not listed on the Remedy compatibility matrix (why??),
but

 maybe somebody has given it a shot...



 XE is free since 02/2006, according to this Oracle press release:



 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html



 The software can be downloaded for free from the Oracle Technology
Network

 at: http://www.oracle.com/technology/xe. Oracle Database XE

 is available for download, usage and distribution at no charge.



 Any feedback is appreciated



 thx, Guillaume











   __20060125___This posting was

 submitted with HTML in it___




___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Tony Worthington
Rick -

The space usage is probably related to storing CLOB's out of row.  There's 
a defect (somewhere) regarding your exact situation with Disco/CMDB.

We found that when loading 120k+ people, our db grew out of control. There 
is auditing functionality on ctm:people, and storing clob's (zero length 
fields) out of row will eat at least your db block size (8k usually) for 
each row.  I've made it a point to switch on clob-in-row as soon as 
finishing the ars install (prior to itsm7) and manually moving clobs out 
of row via ardbc.conf as needed.

If you use a utility such as TOAD you can browse objects (on the 
tablespace tab) and sort by size.  Our offender was the CTM:AuditLogSystem 
form which had grown to about 1GB

Here's a snippet of some of my email on the subject:


So I did some math (always a scary thing) ...

Column C536870935 data is basically:

1178756214AR_ESCALATORLocation has been set with Site : 01018 - 
Covington - Wa

Region has been set with  : Department Store

Default Notify Mechanism has been set to  : E-mail

Client Type has been set to : Office-Based Employee

Received Person ID : PTG8352

PTG8352 has Asset Viewer Permissions now

People Entry has been successfully added

User Information has been successfully added

User Form Information for Company Kohl's has been successfully modified.


That data is 468 characters.  We're non-unicode for the ARServer so that 
should be bytes.  Bump it up to 500.  Multiply by 12.  6000 bytes. 
 

Convert that to megabytes = 57 which is getting stored in the database as 
994MB.  Even if I got screwed up on my bit/byte stuff and math, 457MB is 
nowhere close to 994.



hth,
tony

-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-5911



Rick Cook [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
06/20/2007 09:58 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)






** 
Ours, even after all the configuration data was in (including LDAP and a 
truncated DSL), fit in about 1 GB (on Oracle 9), until we started 
importing asset records from Discovery, at which time it ballooned to 
about 10 GB.  So even with Oracle 10, I would think 4 GB should hold plain 
ITSM 7 without FD/TD.
 
Rick From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

** 
great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample 
data (excluding the product dictionary)

From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

Yes, using it on my laptop with 7.x But only for small development 
tasks...

--
Jarl

On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:
 **

 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
 Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), 
but
 maybe somebody has given it a shot...

 XE is free since 02/2006, according to this Oracle press release:

 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

 The software can be downloaded for free from the Oracle Technology 
Network
 at: http://www.oracle.com/technology/xe. Oracle Database XE
 is available for download, usage and distribution at no charge.

 Any feedback is appreciated

 thx, Guillaume





   __20060125___This posting was
 submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where 
the Answers Are

__20060125___This posting was submitted with HTML in 
it___ 
__20060125___This posting was submitted with HTML in 
it___ 


CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages to or from authorized Kohl's Associates 
at any time
without any further consent.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Guillaume Rheault
great, thanks for the feedback

Guillaume



From: Rick Cook
Sent: Wed 06/20/07 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
Ours, even after all the configuration data was in (including LDAP and a 
truncated DSL), fit in about 1 GB (on Oracle 9), until we started importing 
asset records from Discovery, at which time it ballooned to about 10 GB.  So 
even with Oracle 10, I would think 4 GB should hold plain ITSM 7 without FD/TD.

Rick 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample data 
(excluding the product dictionary)



From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


Yes, using it on my laptop with 7.x But only for small development tasks...

--
Jarl

On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:
 **

 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
 Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), but
 maybe somebody has given it a shot...

 XE is free since 02/2006, according to this Oracle press release:

 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

 The software can be downloaded for free from the Oracle Technology Network
 at: http://www.oracle.com/technology/xe. Oracle Database XE
 is available for download, usage and distribution at no charge.

 Any feedback is appreciated

 thx, Guillaume





   __20060125___This posting was
 submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Guillaume Rheault
Tony,

Do you know of any reason why the clob-in-row is not the default
It seems to me BMC should make available an ardb.conf file for the ITSM 7 
suite, downloadable from the developer community whenever that is available, to 
prevent this problem.

Guillaume



From: Tony Worthington
Sent: Wed 06/20/07 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


Rick -

The space usage is probably related to storing CLOB's out of row.  There's 
a defect (somewhere) regarding your exact situation with Disco/CMDB.

We found that when loading 120k+ people, our db grew out of control. There 
is auditing functionality on ctm:people, and storing clob's (zero length 
fields) out of row will eat at least your db block size (8k usually) for 
each row.  I've made it a point to switch on clob-in-row as soon as 
finishing the ars install (prior to itsm7) and manually moving clobs out 
of row via ardbc.conf as needed.

If you use a utility such as TOAD you can browse objects (on the 
tablespace tab) and sort by size.  Our offender was the CTM:AuditLogSystem 
form which had grown to about 1GB

Here's a snippet of some of my email on the subject:


So I did some math (always a scary thing) ...

Column C536870935 data is basically:

1178756214AR_ESCALATORLocation has been set with Site : 01018 - 
Covington - Wa

Region has been set with  : Department Store

Default Notify Mechanism has been set to  : E-mail

Client Type has been set to : Office-Based Employee

Received Person ID : PTG8352

PTG8352 has Asset Viewer Permissions now

People Entry has been successfully added

User Information has been successfully added

User Form Information for Company Kohl's has been successfully modified.


That data is 468 characters.  We're non-unicode for the ARServer so that 
should be bytes.  Bump it up to 500.  Multiply by 12.  6000 bytes. 
 

Convert that to megabytes = 57 which is getting stored in the database as 
994MB.  Even if I got screwed up on my bit/byte stuff and math, 457MB is 
nowhere close to 994.



hth,
tony

-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-5911



Rick Cook [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
06/20/2007 09:58 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)






** 
Ours, even after all the configuration data was in (including LDAP and a 
truncated DSL), fit in about 1 GB (on Oracle 9), until we started 
importing asset records from Discovery, at which time it ballooned to 
about 10 GB.  So even with Oracle 10, I would think 4 GB should hold plain 
ITSM 7 without FD/TD.
 
Rick From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

** 
great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample 
data (excluding the product dictionary)

From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

Yes, using it on my laptop with 7.x But only for small development 
tasks...

--
Jarl

On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:
 **

 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
 Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), 
but
 maybe somebody has given it a shot...

 XE is free since 02/2006, according to this Oracle press release:

 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

 The software can be downloaded for free from the Oracle Technology 
Network
 at: http://www.oracle.com/technology/xe. Oracle Database XE
 is available for download, usage and distribution at no charge.

 Any feedback is appreciated

 thx, Guillaume





   __20060125___This posting was
 submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where 
the Answers Are

__20060125___This posting was submitted with HTML in 
it___ 
__20060125___This posting was submitted with HTML in 
it___ 


CONFIDENTIALITY NOTICE: 

This is a transmission from Kohl's Department Stores, Inc.

and may contain information which is confidential and proprietary.

If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.

If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.



CAUTION:

Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right

Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Rick Cook
Apparently, the excessive growth can be curbed by setting Remedy to store
CLOBS in row (see KB on that).  However, once the space has been used by
storing them out of row, Oracle won't release the excessive space used.
While that's probably not an issue with a demo box, it's something to keep
in mind on a production/test box.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 8:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks for the feedback
 
Guillaume

  _  

From: Rick Cook
Sent: Wed 06/20/07 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
Ours, even after all the configuration data was in (including LDAP and a
truncated DSL), fit in about 1 GB (on Oracle 9), until we started importing
asset records from Discovery, at which time it ballooned to about 10 GB.  So
even with Oracle 10, I would think 4 GB should hold plain ITSM 7 without
FD/TD.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample
data (excluding the product dictionary)

  _  

From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


Yes, using it on my laptop with 7.x But only for small development tasks...



--

Jarl



On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:

 **



 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?

 Oracle 10g XE is not listed on the Remedy compatibility matrix (why??),
but

 maybe somebody has given it a shot...



 XE is free since 02/2006, according to this Oracle press release:



 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html



 The software can be downloaded for free from the Oracle Technology
Network

 at: http://www.oracle.com/technology/xe. Oracle Database XE

 is available for download, usage and distribution at no charge.



 Any feedback is appreciated



 thx, Guillaume











   __20060125___This posting was

 submitted with HTML in it___




___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___ 
__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Guillaume Rheault
by any chance, do you have that KB article # at hand?



From: Rick Cook
Sent: Wed 06/20/07 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
Apparently, the excessive growth can be curbed by setting Remedy to store CLOBS 
in row (see KB on that).  However, once the space has been used by storing them 
out of row, Oracle won't release the excessive space used.  While that's 
probably not an issue with a demo box, it's something to keep in mind on a 
production/test box.

Rick 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 8:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks for the feedback

Guillaume



From: Rick Cook
Sent: Wed 06/20/07 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
Ours, even after all the configuration data was in (including LDAP and a 
truncated DSL), fit in about 1 GB (on Oracle 9), until we started importing 
asset records from Discovery, at which time it ballooned to about 10 GB.  So 
even with Oracle 10, I would think 4 GB should hold plain ITSM 7 without FD/TD.

Rick 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample data 
(excluding the product dictionary)



From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


Yes, using it on my laptop with 7.x But only for small development tasks...

--
Jarl

On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:
 **

 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
 Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), but
 maybe somebody has given it a shot...

 XE is free since 02/2006, according to this Oracle press release:

 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

 The software can be downloaded for free from the Oracle Technology Network
 at: http://www.oracle.com/technology/xe. Oracle Database XE
 is available for download, usage and distribution at no charge.

 Any feedback is appreciated

 thx, Guillaume





   __20060125___This posting was
 submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-20 Thread Rick Cook
Actually, I think I misspoke.  A KB is being written for it (I have a draft
copy) - should be out there in a week or two, I would think - however long
it takes to run through the process.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
by any chance, do you have that KB article # at hand?

  _  

From: Rick Cook
Sent: Wed 06/20/07 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
Apparently, the excessive growth can be curbed by setting Remedy to store
CLOBS in row (see KB on that).  However, once the space has been used by
storing them out of row, Oracle won't release the excessive space used.
While that's probably not an issue with a demo box, it's something to keep
in mind on a production/test box.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 8:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks for the feedback
 
Guillaume

  _  

From: Rick Cook
Sent: Wed 06/20/07 10:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
Ours, even after all the configuration data was in (including LDAP and a
truncated DSL), fit in about 1 GB (on Oracle 9), until we started importing
asset records from Discovery, at which time it ballooned to about 10 GB.  So
even with Oracle 10, I would think 4 GB should hold plain ITSM 7 without
FD/TD.
 
Rick 
  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 20, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


** 
great, thanks Jarl.
BTW, does anybody know if ITSM 7 would fit in 4GB? with or without sample
data (excluding the product dictionary)

  _  

From: Jarl Grøneng
Sent: Wed 06/20/07 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)


Yes, using it on my laptop with 7.x But only for small development tasks...



--

Jarl



On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:

 **



 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?

 Oracle 10g XE is not listed on the Remedy compatibility matrix (why??),
but

 maybe somebody has given it a shot...



 XE is free since 02/2006, according to this Oracle press release:



 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html



 The software can be downloaded for free from the Oracle Technology
Network

 at: http://www.oracle.com/technology/xe. Oracle Database XE

 is available for download, usage and distribution at no charge.



 Any feedback is appreciated



 thx, Guillaume











   __20060125___This posting was

 submitted with HTML in it___




___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___ 
__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___ 
__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-19 Thread Guillaume Rheault
Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), but 
maybe somebody has given it a shot...

XE is free since 02/2006, according to this Oracle press release:

http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

The software can be downloaded for free from the Oracle Technology Network at: 
http://www.oracle.com/technology/xe. Oracle Database XE is available for 
download, usage and distribution at no charge.

Any feedback is appreciated

thx, Guillaume

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-19 Thread Greg Elphick
**
?


XE can only go to 4 gig and wont let youu allocate any 
more space to the DB and it also only has single channel backups. Due to the 
nature of the changed datatypes in ARS 7.0 the clob storage will quickly suck up 
the 4 gig unless you store the clobs inline.

Seriously only use this DB for eval testing and avoid 
the head ache later.


From: "Action Request System discussion 
list(ARSList)" arslist@arslist.org [mailto:"Action Request System 
discussion list(ARSList)" arslist@arslist.org] On Behalf Of 
Guillaume Rheault [EMAIL PROTECTED]Sent: Wednesday, 20 
June 2007 9:18 AMTo: arslist@arslist.orgSubject: Anybody 
running ARS 7 on Oracle 10g XE (XE is free)
** 
Anybody out there running ARS 7.x on 
Oracle 10g XE (Express Edition)?
Oracle 10g XE is not listed on the Remedy 
compatibility matrix (why??), but maybe somebody has given it a 
shot...

XE is free since 02/2006, according to this Oracle press release:

http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

"The software can be downloaded for free from the 
Oracle Technology Network at: http://www.oracle.com/technology/xe. Oracle 
Database XE is available for download, usage and distribution at no 
charge."

Any feedback is appreciated

thx, Guillaume





__20060125___This posting was 
submitted with HTML in it___ 
-- 
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
-- 








__20060125___This posting was submitted with HTML in it___


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-19 Thread Guillaume Rheault
**



I never intended to have this on test or production system. I was just considering it for a demo environment. But now that you mention the 4 GB limit, it may not be even good for thatthanks for the heads up


From: Greg ElphickSent: Tue 06/19/07 7:25 PMTo: arslist@ARSLIST.ORGSubject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)
** ? 
XE can only go to 4 gig and wont let youu allocate any more space to the DB and it also only has single channel backups. Due to the nature of the changed datatypes in ARS 7.0 the clob storage will quickly suck up the 4 gig unless you store the clobs inline.

Seriously only use this DB for eval testing and avoid the head ache later.


From: "Action Request System discussion list(ARSList)" arslist@arslist.org [mailto:"Action Request System discussion list(ARSList)" arslist@arslist.org] On Behalf Of Guillaume Rheault [EMAIL PROTECTED]Sent: Wednesday, 20 June 2007 9:18 AMTo: arslist@arslist.orgSubject: Anybody running ARS 7 on Oracle 10g XE (XE is free)
** 
Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
Oracle 10g XE is not listed on the Remedy compatibility matrix (why??), but maybe somebody has given it a shot...

XE is free since 02/2006, according to this Oracle press release:

http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

"The software can be downloaded for free from the Oracle Technology Network at: http://www.oracle.com/technology/xe. Oracle Database XE is available for download, usage and distribution at no charge."

Any feedback is appreciated

thx, Guillaume





__20060125___This posting was submitted with HTML in it___ 
-- 
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
-- 







__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-19 Thread Murtuza . Bookwala
Tried using SQL server 2005 express edn (free) on my laptop with ARS 7.
The installation was failing. Anyone tried it successfully. 


Murtuza Bookwala

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: 20 June 2007 09:53
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

Yes, using it on my laptop with 7.x But only for small development tasks...

--
Jarl

On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:
 **

 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
 Oracle 10g XE is not listed on the Remedy compatibility matrix 
 (why??), but maybe somebody has given it a shot...

 XE is free since 02/2006, according to this Oracle press release:

 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

 The software can be downloaded for free from the Oracle Technology 
 Network
 at: http://www.oracle.com/technology/xe. Oracle Database XE is 
 available for download, usage and distribution at no charge.

 Any feedback is appreciated

 thx, Guillaume





   __20060125___This posting was submitted with 
 HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

2007-06-19 Thread Jarl Grøneng

Tried it, but did also fail on my laptop. So I then installed XE

--
Jarl

On 6/20/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:

Tried using SQL server 2005 express edn (free) on my laptop with ARS 7.
The installation was failing. Anyone tried it successfully.


Murtuza Bookwala

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: 20 June 2007 09:53
To: arslist@ARSLIST.ORG
Subject: Re: Anybody running ARS 7 on Oracle 10g XE (XE is free)

Yes, using it on my laptop with 7.x But only for small development tasks...

--
Jarl

On 6/20/07, Guillaume Rheault [EMAIL PROTECTED] wrote:
 **

 Anybody out there running ARS 7.x on Oracle 10g XE (Express Edition)?
 Oracle 10g XE is not listed on the Remedy compatibility matrix
 (why??), but maybe somebody has given it a shot...

 XE is free since 02/2006, according to this Oracle press release:

 http://www.oracle.com/corporate/press/2006_feb/oraclexega-022806.html

 The software can be downloaded for free from the Oracle Technology
 Network
 at: http://www.oracle.com/technology/xe. Oracle Database XE is
 available for download, usage and distribution at no charge.

 Any feedback is appreciated

 thx, Guillaume





   __20060125___This posting was submitted with
 HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers 
Are