Joe, Thanks for clarifying that. It looks like it can serve both purposes. In our present system (the one we are moving off of) we have two AR system on the same box, and if we don't set TWO_TASK correctly when we restart an AR system it connects to the wrong database.
Dwayne ---- Original message ---- >Date: Wed, 6 Jun 2007 14:59:01 -0400 >From: "Joe D'Souza" <[EMAIL PROTECTED]> >Subject: Re: ARSystem can't login to the database following installation - >SOLVED >To: arslist@ARSLIST.ORG > >Dwayne, > >That's not what the TWO_TASK variable is for.. The TWO_TASK variable is a >Oracle client environment setting and has nothing to do with how many AR >Servers you have. > >This variable points the Oracle client to the alias of the DB. It is used as >an alias to connect to either a local or a remote machine, so is a must if >your database is remote. You can have local instances connect without >defining the TWO_TASK variable. > >Since I'm not really an oracle pro, I hope I explained the above right.. > >I bet it was this variable that was the reason why your connectivity was >failing as you didn't have it defined on your environment.. > >Joe > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin >Sent: Wednesday, June 06, 2007 2:05 PM >To: arslist@ARSLIST.ORG >Subject: Re: ARSystem can't login to the database following installation - >SOLVED > > >Thank you, Ben, Mike and Susan ! > >I took all of your advices and it worked. Unfortunately I don't know which >bit of advice actually made the difference. (I was too eager to get this >working to do a controlled experiment.) > >I set the "TWO_TASK" variable (which I thot was only necessary if you have >two ar systems on the same machine), and I reset the password to >"AR#Admin#". Neither of these steps were necessary in the test environment, >but if it works I'm not going to argue with success. > >Thanks again! >Dwayne > >---- Original message ---- >>Date: Wed, 6 Jun 2007 12:02:38 -0500 >>From: Susan Palmer <[EMAIL PROTECTED]> >>Subject: Re: ARSystem can't login to the database following installation >>To: arslist@ARSLIST.ORG >> >> ** >> Dwayne, >> >> There is a point during the install that it asks for >> the 'database' login/password. It's separate from >> the Remedy database login, it asks for that too. >> It's the Oracle system login to Oracle that your dba >> will supply. It's easy to get this all confused. >> >> I'm suprised it didn't stop right at that point >> during the install. If I key something wrong it >> won't go forward. >> >> hth, >> Susan >> >> >> On 6/6/07, Dwayne Martin <[EMAIL PROTECTED]> wrote: >> >> Hello everyone, >> >> I am installing AR System as non-root. (ARS 7.01 >> patch 2, Linux server, Oracle 10.2 db) onto a >> database copied from another server. >> >> Before installing I "tnsping" the new database. >> >> When the installer asks me for the "ARAdmin" >> password to the database I give it the same >> password I use to log in via TOAD, and via sqlplus >> on the Linux machine. The installation goes to >> completion, but on the start-up of the ARSystem I >> get: >> >> " >> 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-01017: invalid username/password; logon >> denied >> >> 390600 : Cannot initialize contact with SQL >> database (ARERR 551) >> Stop server >> >> 390600 : AR System server terminated -- fatal >> error encountered (ARNOTE 21). >> " >> >> I have repeated the installation about ten times, >> sometimes copying and pasting the password, >> sometimes having somebody else enter it, just to >> make sure I am entering the correct password. I >> am sure that at least ONE of those ten times I >> entered it correctly, but the ARSystem still can't >> log into the database. >> >> All the logs show the same "invalid >> username/password" message, but of course they >> don't say what password the system is using so it >> isn't very helpful. >> >> Any suggestions (other than try ten more times)? >> >> Dwayne Martin >> Computing Support >> James Madison University >> >> >____________________________________________________________________________ >___ >> UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org ARSlist:"Where the Answers Are" >> >> __20060125_______________________This posting was >> submitted with HTML in it___ > >Dwayne Martin >Computing Support >James Madison University > >____________________________________________________________________________ >___ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the >Answers Are" > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.5.472 / Virus Database: 269.8.11/837 - Release Date: 6/6/2007 >2:03 PM > >No virus found in this outgoing message. >Checked by AVG Free Edition. >Version: 7.5.472 / Virus Database: 269.8.11/837 - Release Date: 6/6/2007 >2:03 PM > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the >Answers Are" Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
