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