Re: Problem connecting to database with Oracle Discoverer 4
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 GroupReceived on Fri Sep 08 2006 - 03:07:56 CEST