Re: Problem connecting to database with Oracle Discoverer 4
From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 10 Sep 2006 10:26:59 -0700
Message-ID: <1157909218.505468_at_bubbleator.drizzle.com>
>
> 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?
Date: Sun, 10 Sep 2006 10:26:59 -0700
Message-ID: <1157909218.505468_at_bubbleator.drizzle.com>
antonyliu2002_at_yahoo.com wrote:
> DA Morgan wrote:
[Quoted] >> 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?
[Quoted] Discoverer is a reporting tool you just aren't there yet. But Discoverer assumes you have read the documentation and understand that as the Administrator you must create the END USER LAYER. Then you go in as the end user and create reports.
[Quoted] I highly recommend reading the docs. Generally a good practice with any Oracle tool.
-- Daniel Morgan University of Washington Puget Sound Oracle Users GroupReceived on Sun Sep 10 2006 - 19:26:59 CEST