Re: Problem connecting to database with Oracle Discoverer 4

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Sep 2006 18:07:56 -0700
Message-ID: <1157677672.713423_at_bubbleator.drizzle.com>


antonyliu2002_at_yahoo.com wrote:

[Quoted] > I tried both mydb_server.at.my.edu and MyDBName.at.my.edu as the > connection string respectively. Neither worked.

And I wouldn't have expected them to work as you completely ignored the advice you were given.

This is what you said worked:
>>> C:\oracle\product\10.1.0\MyDBServer\BIN>tnsping MyDBName
>>>
>>> TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on
>>> 07-SEP-2
>>> 006 14:14:37
>>>
>>> Copyright (c) 1997, 2003, Oracle. All rights reserved.
>>>
>>> Used parameter files:
>>> C:\oracle\product\10.1.0\MyDBServer\network\admin\sqlnet.ora
>>>
>>> Used TNSNAMES adapter to resolve the alias
>>> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
>>> (PROTOCOL = TCP)
>>> (HOST = mydb_server.at.my.edu)(PORT = 1521))) (CONNECT_DATA = (SERVER =
>>> DEDIC
>>> ATED) (SERVICE_NAME = MyDBName.at.my.edu)))
>>> OK (30 msec)

Do you see where what worked was: tnsping MyDBName

Why did you then go and type in complete nonsense such as: mydb_server.at.my.edu and MyDBName.at.my.edu

If you want to work in Oracle you are going to have to pay attention to details: Even the obvious ones.

What university are you at?

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Fri Sep 08 2006 - 03:07:56 CEST

Original text of this message