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 at www.arslist.org ARSlist:"Where the Answers Are"
