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