You say the database connection with sqlplus is OK.  How did you test the 
connection?  When you supplied the login did you use the @ method to specify a 
database?  My preferred method is to set the TWO_TASK and ORACLE_SID 
environment variables so sqlplus just needs a login and password.

export TWO_TASK=(the name of the entry in your tnsnames.ora file)   
export ORACLE_SID=(the SID or Service Name of your Oracle instance)   
sqlplus aradmin/password

Also make sure you are using the installer for patch 3

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Vincent Riedweg
Sent: Wednesday, February 10, 2010 10:23 AM
To: [email protected]
Subject: AR System 7.5 installation issue...

** 
Hi list,

I am facing a strange installation issue.

Let me to tell this story :
* We are using AIX 5.3 with a remote Oracle 10.2.0.4 database.
* The tnsnames.ora file is configured according to the SW00316551 workaround.
* The database connection with sqlplus is OK.
* All the prerequisites are verified and OK.
* The database is a database that comes from an AR System 6.3. No AR System 
server installed on the server.
* The AR System installer connects to the database correctly and proposes the 
upgrade option.
* To upgrade the data dictionary from 6.3 to 7.5, the arupora utility is called 
by the installer.
* I can find the following error in the arupora log file (arsql.log) ORA-12154: 
TNS:could not resolve the connect identifier specified.
* I have tried with or without setting the TWO_TASK and the result is the same.
* There is no other error in all the log files except duplicates of this error 
in different log files.

I have tried many configurations and the result is always the same.

All idea is welcome...

Regards,

Vincent RIEDWEG. 

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to