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"