Steve, That was the magic bullet that will allow me to complete the task at hand. I still need to determine why this EV is needed. Many thanks for the quick response!!!
Best, Pete On Mon, Aug 21, 2017 at 7:58 AM, Murnane, Phil <phil.murn...@windward.com> wrote: > ** > > Hi Peter, > > > > I’m far from an expert here, but in the past I’ve resolved some Oracle > connection problems by setting the TWO_TASK environment variable. Some > notes here: http://www.orafaq.com/wiki/TWO_TASK . It’s a long shot, but > couldn’t hurt to try. > > > > HTH, > > --Phil > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran > *Sent:* Sunday, August 20, 2017 2:34 PM > *To:* arslist@ARSLIST.ORG > *Subject:* DB connection from the AR Server installer > > > > ** > > 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 > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
