Message-ID: <F001.004B81F7.20020816171827@fatcity.com>
Date: Fri, 16 Aug 2002 17:18:27 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Jared.Still@radisys.com
Subject: RE: Cannot Connect to DB from 9i DS Release 2
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Oops, I identified Cherie as the respondent to Ken's question, and
it was actually Beth.

Sorry Beth.

@#$& non-threading Lotus Notes MUA.  The responses to email
do not appear with the questions.

Jared


"Seefelt, Beth" <Beth.Seefelt@TetleyUSA.com>
Sent by: root@fatcity.com
08/16/2002 08:43 AM
Please respond to ORACLE-L

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


Did you set your default home back to the 9.2 home after the install?  The 
install will have changed it to the home for 9iDS.
 
Go to start -> programs -> Oracle installation products -> Home selector 
and set it back.
 
You should also make sure you have TNS_ADMIN set in the registry so that 
everything looks for the same tnsnames regardless of the home setting.
 
HTH,
 
Beth
-----Original Message-----
Sent: Friday, August 16, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L

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 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still@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@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).