Ok, I added the ORACLE_HOME variable (C:\oraclexe\app\oracle\product\10.2.0) to the tnsnames.ora file, and to the Windows environmental settings. Restarted the Oracle services, and I still get the same error.
Any other ideas? Rick On Wed, Aug 20, 2008 at 1:24 PM, Joe DeSouza <[EMAIL PROTECTED]> wrote: > ** > I recently had to use emca on the db server to create the database > repository after moving an oracle database between domains, and surprise > surprise.. I did need to set that in the dos environment before running it > else it failed to connect.. Setting your ORACLE_HOME may not be such a bad > idea afterall.. > > Is the database remote? You would also need your TWO_TASK if so.. > > Joe > > ----- Original Message ---- > From: Rick Cook <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Wednesday, August 20, 2008 4:08:21 PM > Subject: Re: AR System install error - Oracle > > ** I have the tnsnames.ora file. There is no ORACLE_HOME variable > therein, but I don't think I need that for a local DB - ditto for the > TWO_TASK. I put the SID in myself. The client is the same version (10g) as > the local Oracle server. > > Rick > > On Wed, Aug 20, 2008 at 12:04 PM, Grooms, Frederick W < > [EMAIL PROTECTED]> wrote: > >> ** I don't believe Oracle uses the Registry on Windows. There should be >> a tnsnames.ora file in <OracleHome>/Network/Admin. See if you have an >> environment variable of ORACLE_HOME (You may also have TWO_TASK and >> ORACLE_SID defined). >> >> Also make sure which Oracle client you have installed. ARS 7.1 uses the >> Oracle 10g (32 bit) client >> >> Fred >> >> ------------------------------ >> *From:* Action Request System discussion list(ARSList) [mailto: >> [EMAIL PROTECTED] *On Behalf Of *Rick Cook >> *Sent:* Wednesday, August 20, 2008 11:39 AM >> *To:* arslist@ARSLIST.ORG >> *Subject:* AR System install error - Oracle >> >> I am trying to install AR System 7.1 patch 4 on an Oracle 10g Express >> platform on a Windows box. The Oracle services are running, I can log in >> and navigate in the browser-based Administration, so I am pretty sure that >> the DB is up. However, the AR System installer seems to think otherwise. I >> get this error message when specifying the DB information: >> >> "Could not connect to the database. Verify the selected Database Server >> is running". >> >> There's only one instance of the DB running, and the SID is specified as >> "XE" both in the installer and in the tnsnames.ora file. I got that value >> from the Registry. >> >> So what am I missing here? >> >> Rick >> > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
