Upgrade Oracle to 10g r2

To all,

Does anyone know if there is an RT problem related to upgrading Oracle 

DB to 10g r2? We’re running 3.6.4 and planning to do that but I wanted
to see if that would cause any RT problems. Thanks in advance.

Kenn
LBNL

Kenneth Crocker wrote:

To all,

Does anyone know if there is an RT problem related to upgrading Oracle
DB to 10g r2? We’re running 3.6.4 and planning to do that but I wanted
to see if that would cause any RT problems. Thanks in advance.
I have been running RT on Oracle XE, not quite the full blown 10g, but
close enough and haven’t had a problem in about 2 years?
I think I started out with RT-3.4.5 but not quite sure about that.

Hope this helps you making the move else let me know if I can help in
any way.

Joop

Does anyone know if there is an RT problem related to upgrading Oracle
DB to 10g r2? We’re running 3.6.4 and planning to do that but I wanted
to see if that would cause any RT problems. Thanks in advance.

I’m running RT on systems with 10.2.0.3.0 with only one problem: sorting
queries on CFs and non-CFs returns a count but no actual tickets. From
what I’ve seen it’s probably an Oracle-only issue, but whether it’s a
problem in RT or Oracle itself I don’t know.

Regards,

joe
Joe Casadonte
joe.casadonte@oracle.com

========== ==========
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation. ==
========== ==========

Joop,

Kool. Thanks. What version are you on now?

Kenn
LBNLOn 3/17/2008 12:37 PM, Joop van de Wege wrote:

Kenneth Crocker wrote:

To all,

Does anyone know if there is an RT problem related to upgrading 

Oracle DB to 10g r2? We’re running 3.6.4 and planning to do that but I
wanted to see if that would cause any RT problems. Thanks in advance.
I have been running RT on Oracle XE, not quite the full blown 10g, but
close enough and haven’t had a problem in about 2 years?
I think I started out with RT-3.4.5 but not quite sure about that.

Hope this helps you making the move else let me know if I can help in
any way.

Joop

At Monday 3/17/2008 03:43 PM, Joe Casadonte wrote:>On 3/17/2008 2:40 PM, Kenneth Crocker wrote:

  Does anyone know if there is an RT problem related to 

upgrading Oracle

DB to 10g r2? We’re running 3.6.4 and planning to do that but I wanted
to see if that would cause any RT problems. Thanks in advance.

I’m running RT on systems with 10.2.0.3.0 with only one problem: sorting
queries on CFs and non-CFs returns a count but no actual tickets. From
what I’ve seen it’s probably an Oracle-only issue, but whether it’s a
problem in RT or Oracle itself I don’t know.

Joe,

Do you see anything in the RT log? We’ve had this symptom when using
Oracle-specific sql functions against a mysql database. The RT log
revealed the problem in our case.

Steve

Joe,

Thanks. Good to know.

Kenn
LBNLOn 3/17/2008 12:43 PM, Joe Casadonte wrote:

On 3/17/2008 2:40 PM, Kenneth Crocker wrote:

Does anyone know if there is an RT problem related to upgrading 

Oracle DB to 10g r2? We’re running 3.6.4 and planning to do that but I
wanted to see if that would cause any RT problems. Thanks in advance.

I’m running RT on systems with 10.2.0.3.0 with only one problem: sorting
queries on CFs and non-CFs returns a count but no actual tickets. From
what I’ve seen it’s probably an Oracle-only issue, but whether it’s a
problem in RT or Oracle itself I don’t know.

Do you see anything in the RT log? We’ve had this symptom when using
Oracle-specific sql functions against a mysql database. The RT log
revealed the problem in our case.

It’s been a long time since I’ve looked into this. I remember capturing
the SQL for it, but I don’t recall if it displayed the same symptoms in
SQL*Plus as it did in RT. I’ve a new DBA now, so I’ll get him to look
into it sometime this week.

Regards,

joe
Joe Casadonte
joe.casadonte@oracle.com

========== ==========
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation. ==
========== ==========