All, I am trying to get the Remedy installer to connect with the DB to install the application.
SQLPlus As a preliminary test I tested the connection using SQLPlus from the Remedy server. Without appending the pw with @sid the connection failed (ERROR:ORA-12560: TNS:protocol adapter error) PW with @sid appended connects successfully Remedy Installer In this case I'm only installing the AR Server 8.1.02 files as the DB (Oracle 11g) is in place. The issue is that the application installer does a validation check and it fails. Without the @sid it validates and performs the installation but then fails when its time to connect to the DB at the very end of the installation. Appending the pw @sid the installer validation fails. Any thoughts on how to connect to the DB (SQLPlus or application installer) without using the @sid would be greatly appreciated. Different servers ping the db server, by name and IP = success DB is started and open lsnrctl status = success tnsping sid = success Adding server env var ORACLE_SID=sid did not help Thanks Pete _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
