Re: Problem connecting to database with Oracle Discoverer 4

From: <antonyliu2002_at_yahoo.com>
Date: 9 Sep 2006 15:41:51 -0700
Message-ID: <1157841711.121666.199860_at_h48g2000cwc.googlegroups.com>

DA Morgan wrote:
> antonyliu2002_at_yahoo.com wrote:
>
> > 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

Thank, Dan.

[Quoted] [Quoted] Well, I did try many combinations of the host names and service names, but when I typed it up, I showed only one version. The problem for discussing on the web is that, if I attempt to be as complete as possible, then the message is going to be too lengthy to be read from A to Z. If I try to make a short message, then many important things may be considered ignored.

Anyway, this is the nature of web talk. But, every time, we exchange our converstation, things get clearer.

Now, let me try to make it more complete this time.

Here is the output of tnsping from my database server:

C:\oracle\product\10.1.0\Oracle\BIN>tnsping MyDBName

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 09-SEP-2
006 16:56:22

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.1.0\Oracle\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = mydbserver.at.my.edu)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MyDBName.at.my.edu))) OK (30 msec)

C:\oracle\product\10.1.0\OOracle\BIN>

It looks like MyDBName is OK.

Discoverer 4 is installed on a different computer and the file called TNSNAMES.ORA under C:\orant\NET80\ADMIN\ has the following content:

MyDBName =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mydbserver)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = MyDBName)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

The following are the strings I tried for the connect box:

mydbserver
mydbserver.at.my.edu
MyDBName
MyDBName.at.my.edu

None of this worked with this version of TNSNAMES.ORA

Then, I changed TNSNAMES.ORA by replacing

HOST = mydbserver

with the following respectively each time:

HOST = mydbserver.at.my.edu
HOST = MyDBName.at.my.edu
HOST = MyDBName

and replacing

SERVICE_NAME = MyDBName

with the following respectively each time:

SERVICE_NAME = MyDBName.at.my.edu
SERVICE_NAME = mydbserver
SERVICE_NAME = mydbserver.at.my.edu
SID = MyDBName
SID = MyDBName.at.my.edu

SID = mydbserver
SID = mydbserver.at.my.edu

Of course, each time with a different combination and then also tried different strings for the connect box in Discoverer 4.

None of this worked. Well, if one thinks about it, there are houndreds of thousands of combinations of such stuff. In other words, I might not have hit the right combinations of these stuffs, but it is also possible that something else un-thought-of might have occurred.

And the file called SQLNET.ORA has the following content:

TRACE_LEVEL_CLIENT = OFF
sqlnet.authentication_services = (NTS)
names.directory_path = (TNSNAMES, ONAMES, HOSTNAME) names.default_domain = world
name.default_zone = world
automatic_ipc = off

Let's hope that we'll get this problem resolved in two weeks, given the pace of web talk. Received on Sun Sep 10 2006 - 00:41:51 CEST