Re: Problem connecting to database with Oracle Discoverer 4

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

Well this doesn't seem to be working particularly well for you.

But getting back to your topic ... a value that works with TNSPING should work for connecting. A value that does not work with TNSPING will not work for a connection.

Comment out everything out of your SQLNET.ORA and then reintroduce them one at a time. The lines:

 > names.default_domain = world
 > name.default_zone = world

Are almost undoubtedly part of the problem and most certainly were not created by netca. Where did they come from?

-- 
Puget Sound Oracle Users Group