Re: DB connection from the AR Server installer
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"
Re: DB connection from the AR Server installer
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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"