Re: Problem connecting to database with Oracle Discoverer 4

DA Morgan wrote:
> antonyliu2002_at_yahoo.com wrote:
> > DA Morgan wrote:
> >> 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?
> >> --
> >
> > Hi, Dan,
> >
> > You are right that the problem seems to be with SQLNET.ORA. I removed
> > those two lines you mentioned.
> >
> > And it also seems that in TNSNAMES.ORA, the line that says
> >
> > SERVICE_NAME = MyDBName
> >
> > needs to be changed to
> >
> > SID = MyDBName
> >
> > as you instructed in a previous message a few days ago.
> >
> > So, now, I am able to connect to the database, and could actually see
> > those table structures. Thank you so much for walking me through this.
> >
> > But it looks to me that discoverer is more like a database management
> > tool instead of a reporting tool.
> >
> > I don't even know how to create a simple SQL query with discoverer.
> > Hmm, how to submit a SQL query from discoverer?

>

>

All right, that's great. Will do the docs. Thanks. Received on Sun Sep 10 2006 - 22:31:11 CEST