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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/16/2002 07:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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
tnsnames.ora
Description: Binary data
