Some other general thoughts: 1. AR System 7.5.00 is only supported on 64-bit Red Hat Linux - is it possible you're on a 32-bit Linux operating system?
2. If not (i.e. you are on a 64-bit Linux OS now), did you replace your Oracle client with a 64-bit 10gR2 client as per the compatibility matrix? 3. You may want to take a look at the following white paper about CLOBs in case that holds any clues: 17-Mar-2008 Using Oracle CLOBs with BMC Remedy Action Request System http://documents.bmc.com/supportu/documents/96/63/89663/89663.pdf -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mark Milke Sent: Wednesday, May 26, 2010 7:52 AM To: [email protected] Subject: Upgrade to 7.5 Patch 4 and 5 fails Hi there, we're on ARS 6.3 with Oracle 9.2 on Linux Red Hat. We're trying to upgrade from 6.3 to 7.5 on Oracle 11 and Linux Red Hat. We tried to upgrade to 7.5 patch 4 and then to 7.5 patch 5; both fail while executing this statement: Failed to run SQL statement [ALTER TABLE ACTLINK_MESSAGE MODIFY ( MSGTEXT CLOB NOT NULL )] Due to [ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB In order to make the gap between the versions smaller, we've upgraded 6.3 to 7.1. This worked just fine, however the upgrade from 7.1 to 7.5 failed again for the same reason. Any ideas where can we go from here? Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
