Hi, We have ran our test environment must of 2009, on 6.3 on 10g, and recent upgraded our production and backup to 10g.
Its simple, 1. Keep the 9i client 2. Stop the application 3. Back-up ar.conf/ar.gf 4. Comment out ORACLE_SID 4. Add Oracle-Two-Task = "oracle_sid" 5. Keep the oracle path to point to the 9i cleint (sqlplus) 6. Upgrade the db to 10g. Please note Ars 6.3 and db sits in same server (unix). -----Original Message----- From: Jarl Grøneng <jarl.gron...@gmail.com> To: arslist <arslist@ARSLIST.ORG> Sent: Sun, Apr 25, 2010 2:40 pm Subject: Re: ARS 6.3 - Upgrading Oracle from 9i to 10g 6.3 has never supported 64 bits oracle client. AR System 7.5 has 64bits support, and therefore support for 64 bits oracle client. Regards Jarl 2010/4/25 Fatima <fsha...@gmail.com>: > ** > Thanks Jarl, > I have a question, I am currently running ARS 6.3 on a 64bit Oracle 9i > Database directly without the client and it has been working fine for the > past three years, is 6.3 compatible only with the 64bit database but does > not support the 64bit client? > Regards, > Fatima > On Sun, Apr 25, 2010 at 6:56 PM, Jarl Grøneng <jarl.gron...@gmail.com> > wrote: >> >> AR System 6.3 only support 32 bit client of Oracle. >> >> Regards, >> Jarl >> >> >> 2010/4/25 Fatima <fsha...@gmail.com>: >> > ** >> > >> > Hi List, >> > >> > ARS 6.3 - Upgrading Oracle from 9i to 10g >> > >> > I know this issue has been discussed a lot on the list, and I have read >> > most >> > of these discussions. Conclusion from past threads: ARS 6.3 does not >> > work >> > directly with 10g must be through a 9i client. I have done the >> > configuration >> > based on these requirements but still I couldn’t quite get it to work. >> > >> > My current problem: >> > >> > We are running ARS 6.3 with an Oracle 9.2.0.7 database, we upgraded the >> > database to 10g. >> > >> > I am having a problem starting the ARS; the start script terminates with >> > following error: >> > >> > 390600 : Failure while trying to connect to the SQL database. >> > >> > Please ensure the SQL database is running or contact the Database >> > Administrator for help (ARERR 550) >> > >> > ORA-12154: TNS:could not resolve the connect identifier specified >> > >> > 390600 : Cannot initialize contact with SQL database (ARERR 551) >> > >> > Stop server >> > >> > These are the configurations: >> > >> > OS: Solaris 10 [SPARC – 64bit] >> > >> > AR: 6.3 patch 23 >> > >> > DB: Oracle 10g [64bit] >> > >> > Oracle Client: 9.2.0 [64bit] >> > >> > I configured the oracle 9.2.0 client to have a TNS entry to direct to >> > the >> > 10g database. >> > >> > Entries in ar.conf: >> > >> > Dbhome-directory: set to the oracle 9 client home >> > >> > Oracle-Two-Task: set to TNS entry name in the 9 client that directs to >> > the >> > 10g database >> > >> > Db-name: name of table space on the 10g database >> > >> > Db-user: correct username >> > >> > Db-password: correct password >> > >> > My questions: >> > >> > 1. What am I missing? >> > >> > 3. In ar.conf, Can someone explain to me why do I need to enter >> > the >> > Db-name if I am entering the Oracle-Two-Task and since its going through >> > the >> > TNS entry. >> > >> > 4. Do I need to set the environment variables at the OS level [for >> > ORACLE_HOME & TWO_TASK] and does ARS read from the environment variables >> > or >> > only the entries in ar.conf? >> > >> > Thanks for the help. >> > >> > Fatima Amin >> > >> > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
