Re: Oracle 9i to 10g upgrade issues?
Melissa, On ARS 6.0.3, you still need to connect to the Oracle 10 database using the Oracle 9iR2 client. Check your ar.conf (Unix) or ar.cfg (Windows) for the DB-home directory and point this to the location of where you have the Oracle 9i client installed. Hope this helps. Saby --- Roney Samuel Varghese <[EMAIL PROTECTED]> wrote: > Dear Melissa, > I believe you have the mapped > the new instances and the > directory names. Check the path as Steve has rightly > pointed out. Also check > the tnsnames.ora file for any incorrect connection > strings. Hope this helps. > > Regards, > Roney Samuel Varghese > > > > On 4/9/07, Steve Waller > <[EMAIL PROTECTED]> wrote: > > > > one the ar config will need to pointed to the > correctly installed > > oracale client on you AR server. Something like > this > > > > ORACLE_HOME: D:\oracle\product\10.2.0\client_1 > > PATH: ORACLE_HOME/bin > > > > If the client is not properly installed or the > Registry is not cleaned > > of the old client data the system can not connect > properly to the > > database. It will think you are running ora 9i. > > > > > > -Original Message- > > From: Action Request System discussion > list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of > melreed95 > > Sent: Monday, April 09, 2007 8:42 AM > > To: arslist@ARSLIST.ORG > > Subject: Oracle 9i to 10g upgrade issues? > > > > We are running ARS 6.3 patch 20 and need to > upgrade our database to > > Oracle 10g from 9i. When you do this, you can't > install Oracle on top > > of the previous version. Now that we have Oracle > upgraded, remedy can't > > find the database. Has anyone had issues with > this kind of an upgrade? > > Apparently Remedy hardcodes Oracle information > that we will need to > > change. Any ideas? > > > > Thanks! > > Melissa > > > > > > > ___ > > 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" > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org ARSlist:"Where the Answers Are" > Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A. http://answers.yahoo.com/dir/?link=list&sid=396545367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Oracle 9i to 10g upgrade issues?
Dear Melissa, I believe you have the mapped the new instances and the directory names. Check the path as Steve has rightly pointed out. Also check the tnsnames.ora file for any incorrect connection strings. Hope this helps. Regards, Roney Samuel Varghese On 4/9/07, Steve Waller <[EMAIL PROTECTED]> wrote: one the ar config will need to pointed to the correctly installed oracale client on you AR server. Something like this ORACLE_HOME: D:\oracle\product\10.2.0\client_1 PATH: ORACLE_HOME/bin If the client is not properly installed or the Registry is not cleaned of the old client data the system can not connect properly to the database. It will think you are running ora 9i. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of melreed95 Sent: Monday, April 09, 2007 8:42 AM To: arslist@ARSLIST.ORG Subject: Oracle 9i to 10g upgrade issues? We are running ARS 6.3 patch 20 and need to upgrade our database to Oracle 10g from 9i. When you do this, you can't install Oracle on top of the previous version. Now that we have Oracle upgraded, remedy can't find the database. Has anyone had issues with this kind of an upgrade? Apparently Remedy hardcodes Oracle information that we will need to change. Any ideas? Thanks! Melissa ___ 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Oracle 9i to 10g upgrade issues?
one the ar config will need to pointed to the correctly installed oracale client on you AR server. Something like this ORACLE_HOME: D:\oracle\product\10.2.0\client_1 PATH: ORACLE_HOME/bin If the client is not properly installed or the Registry is not cleaned of the old client data the system can not connect properly to the database. It will think you are running ora 9i. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of melreed95 Sent: Monday, April 09, 2007 8:42 AM To: arslist@ARSLIST.ORG Subject: Oracle 9i to 10g upgrade issues? We are running ARS 6.3 patch 20 and need to upgrade our database to Oracle 10g from 9i. When you do this, you can't install Oracle on top of the previous version. Now that we have Oracle upgraded, remedy can't find the database. Has anyone had issues with this kind of an upgrade? Apparently Remedy hardcodes Oracle information that we will need to change. Any ideas? Thanks! Melissa ___ 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"
Oracle 9i to 10g upgrade issues?
We are running ARS 6.3 patch 20 and need to upgrade our database to Oracle 10g from 9i. When you do this, you can't install Oracle on top of the previous version. Now that we have Oracle upgraded, remedy can't find the database. Has anyone had issues with this kind of an upgrade? Apparently Remedy hardcodes Oracle information that we will need to change. Any ideas? Thanks! Melissa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
