We were using US7ASCII. Our DBA's told us that Oracle 11g is not compatible and said that we had to Change it. After getting some information from BMC, we changed it to WE8MSWIN1252. The DBA's set the character set when they installed Oracle 11g (I'm not sure their exact process). I don't think any data transformation was done. Do we need to do that?
BMC recommended that we downgrade everything back to what it was (this is just a test environment at this point, so that is fine). Then they said to bring up a new 11g database. Then install a new AR Server against this DB. Then they said to use the Remedy Migrator (which we don't currently have) and migrate our data over. We would prefer not to go thus route if possible. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 21, 2012 12:31 PM To: arslist@ARSLIST.ORG Subject: Re: upgrading from Oracle 10g to 11g, issues What was your old character set? What did you change it to? How did you change it? Did you perform necessary data transformation at the DB level if that was required? Joe -----Original Message----- From: Joshua Bray Sent: Wednesday, March 21, 2012 12:16 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: upgrading from Oracle 10g to 11g, issues Good Morning, Sorry if this gets posted twice. I don't seem my previous post. We are trying to upgrade from Oracle 10g to 11g and are getting errors when we restart the AR Server (we are on 7.5 patch 6, on windows 2003). The errors are "390600 : Error in definition for an active link (ARERR 399)", on every active link. We are getting these because we had to change the character set. Oracle 11g is no longer compatible with what we were using. We are completely customized, no out of the box stuff. Has anyone else done this, with a similar configuration? BMC has a suggestion, but it's a bit painful and wondering if anyone else has a better way. Thanks, Josh Bray Turner Broadcasting System, INC ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
