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"