That's a good point Joe - I think there is a TNS listener that needs to be running in the Oracle DB. SQLPlus would tell you if it is/isn't running since it connects via tnsnames.ora
Janie _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, August 20, 2008 3:15 PM To: arslist@ARSLIST.ORG Subject: Re: AR System install error - Oracle Asking the obvious so pardon me.. Has the Oracle client libraries been installed? If so try connecting using sqlPlus.. If you get the same error when you sqlPlus to it, you may want to restart the db sever instance.. Maybe the console is up but the db server isn't? Joe ----- Original Message ---- From: Rick Cook <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, August 20, 2008 4:53:13 PM Subject: Re: AR System install error - Oracle ** 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"
