Re: Cannot Connect to DB from 9i DS Release 2

Ken,

When installing new Oracle products, it is not unusual for that product to install it's own sqlnet.ora and tnsnames.ora.

These will of course be incorrect.

As Cherie said, you may want to just try setting TNS_ADMIN, or you can make sure the files are in sync.

Jared

"KENNETH JANUSZ" <kjanusz_at_att.net>
Sent by: root_at_fatcity.com
08/16/2002 07:58 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Cannot Connect to DB from 9i DS Release 2

I have a DB connection problem that I cannot resolve and need your help.  

Standalone Dell 8200 PC using XP Prof. with 61.6 GB of free space.  

A couple of days ago I installed my 9.2 DB successfully and was able to connect with SQL*Plus and TOAD.  

Then yesterday I installed 9iDS Rel. 2 which finished with no errors. Destination for DS is:
Name: IDSHome
Path: C:\IDSHome1  

The 9.2 DB is located at C:\oracle\admin . . . \ora92 . . . \oradata  

Now I'm having a problem connecting the DB. I can connect via SQL*Plus but not TOAD. I tried connecting to the Forms Developer/Builder, Designer, and Reports Developer/Builder and get the same error message.  

ORA-12154:TNS: Could not resolve service name. Service name specified is not defined in TNSNAMES.ORA file.  

And when I go to Services for DS I get:
OracleIDSHomeAgent - fails (will not run even with numerous start attempts)
OracleIDSHomeClientCache - runs
Both have startup type of manual.  

Attached is my TNSNAMES.ORA file.  

One thing I didn't do is reboot my PC prior to the start of this installation. I didn't think I needed to since this is the first installation for DS.  

Anyone have any idea what is wrong and how I go about correcting it?  

Any and all help will be greatly appreciated.  

Thanks,
Ken  

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

--=_mixed 000154E588256C18_=--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



application/octet-stream attachment: tnsnames.ora