Brian and all, Just rec'd this from Remedy Support:
There is a bug reporting upgrade problems to 701 concerning the user_cacheY22 table. The bug is SW00255568. The workaround is to upgrade to 7.0 patch 1 or 2 and then upgrade from 7.0 to 7.0.1 using the SHARE option. regards, rp On Feb 6, 2:52 pm, Rick Phillips <[EMAIL PROTECTED]> wrote: > Brian, > > Thanks for the input, but it's not encouraging since those are the > same symptoms that I have! I should know by the end of the day > whether we need to start over and try again via 7.0.0. > > rp > > On Feb 6, 7:05 am, [EMAIL PROTECTED] wrote: > > > > > > > Rick, > > > I tried upgrading an oracle 9.2 database from version 5.1.2 to 7.0.1 on my > > laptop. I installed the Oracle 10g client and used this as instructed. I > > could never get the service to start. It would always time out. I watched > > what Remedy was up to through Enterprise Manager and could see it talking to > > the database, presumably trying to build its cache. It would keep starting > > more and more connections. It was driving me crazy until I was advised by a > > colleague that you cannot upgrade from 5.1.2 to 7.0.1. You have to go > > through version 7.0.0 first. > > > I don't know what the problem is though. I have now done an install of 7.0.0 > > over my 7.0.1 and it starts ok. I have yet to upgrade this to 7.0.1 though > > through lack of free time. I also want to restore the database back to 5.1.2 > > and try the upgrade to 7.0.0 and then 7.0.1 to see what the result is. But > > have yet to find the time! > > > Brian Bishop > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips > > Sent: 05 February 2007 17:59 > > To: [EMAIL PROTECTED] > > Subject: Re: Problems connecting to Oracle following 10g client install... > > > Thanks for the quick reply. I pasted a copy of tnsnames.ora in the > > new 10g \Network\Admin folder, but am still getting the same error. > > tnsping shows the correct use of sqlnet.ora and tnsnames.ora, so that > > looks good. > > > Not sure what to try next. > > > rp > > > On Feb 5, 12:13 pm, "Grooms, Frederick W" <[EMAIL PROTECTED]> > > wrote: > > > Usually each client has it's own tnsnames.ora file. Check the <client > > > install folder>\Network\Admin for a tnsnames.ora file. You may need to > > > copy the 9i one into the 10g folder. > > > > Fred > > > > -----Original Message----- > > > From: Action Request System discussion list(ARSList) > > > > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips > > > Sent: Monday, February 05, 2007 11:03 AM > > > To: [EMAIL PROTECTED] > > > Subject: Problems connecting to Oracle following 10g client install... > > > > Hello all, > > > > Windows 2000 AS > > > Ora 9i > > > ARS 5.1.2 upgraded to 7.0.1 > > > > I installed the 10g client, but am unable to start arserver following > > > the 7.0.1 upgrade. Found no errors in the install log, but found the > > > following in the arerror.log > > > > Mon Feb 05 11:13:38 2007 ORA-06401: NETCMN: invalid driver > > > designator > > > > Mon Feb 05 11:13:38 2007 390600 : Cannot initialize contact with SQL > > > database (ARERR 551) > > > > Mon Feb 05 11:13:38 2007 Stop server > > > > Mon Feb 05 11:13:38 2007 390600 : AR System server terminated -- fatal > > > error encountered (ARNOTE 21) > > > > I can connect via SQL Plus as ARAdmin. > > > > I have my old 9i client installed, and tnsnames.ora is in the 9i path. > > > Was the 10g client installation supposed to create a new or modify the > > > old tnsnames.ora file? > > > > Tia, > > > > Rick > > > ___________________________________________________________________________- > > ____ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > > Answers Are"- Hide quoted text - > > > > - Show quoted text - > > > ____________________________________________________________________________ > > ___ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > > Answers Are" > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > > Answers Are"- Hide quoted text - > > > - Show quoted text - > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are"- Hide quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
