You have no oracle clients installed

Guest · November 23, 2009, 11:22pm

Hi Brad,

Thank for your message. I have TOAD 9.0 installed. Maybe I need to install the patch.

Thank you again.

Sincerely,

Andrew.

Guest · November 23, 2009, 11:27pm

Hi and thanks for your post. I checked the bin directory in the Oracle home is definitely in the PATH variable. I do not however see anything like a SQLPATH variable. When toad starts up it says that there are no oracle clients installed within an error dialog.

Thank you again.

Sincerely,

Andrew.

Guest · November 23, 2009, 11:31pm

Hi and thanks for your message. When I click on this button all I get is an error dialog with the original error I got saying: “You do not have any Oracle homes installed!” There is no useful information displayed at all especially no debugging information.

Thanks for your suggestion.

PetervanRijn · November 24, 2009, 12:57am

I just wanted to emphasize that complete server installs always include
client software, be it on Unix or on Windows. It is no problem having
them in the same OH.
But perhaps you're right, drifting off topic a bit too much.

Damir Vadas schreef:

Peter,

I think the whole story starts with problems with Toad and this is
strictly connected with windows environment. I agree with you but please
let us focus on the topis of this forum....a

Hope you do understand me.

Damir Vadas
http://damir-vadas.blogspot.com

dboussebha_123807095 · November 24, 2009, 4:56am

Hi;

How to filter the SQL requests into a AWR SQL report ? For example show only the requests where execution time > 10s, etc…

Regards

HillbillyToad · November 24, 2009, 6:12am

Sure, no problem.

When I installed Oracle, I chose to put down the server and the connectivity
software, all in one oracle BASE directory.

This included the database server piece, and the SQL*NET/OCI.DLL piece.

I didn’t have to run the installer twice…

HillbillyToad · November 24, 2009, 6:14am

That’s what I’ve been trying to say J

Obviously you wouldn’t want to install a 2nd ORACLE_HOME (client) into an
existing HOME.

HillbillyToad · November 24, 2009, 6:17am

Have you looked at the underlying data model for the AWR tables?

dboussebha_123807095 · November 24, 2009, 6:28am

Hi;

How to filter the SQL requests into a AWR SQL report ? For example show only the
requests where execution time > 10s, etc…

Regards

HillbillyToad · November 24, 2009, 6:57am

Then I’m not sure you’re going to be able to do this just by
pointing and clicking in Toad or OEM Grid.

We have a browser, but it’s more suited for picking specific metrics for a
point in time. If you want to filter, you have to write your own query.

I’m not even sure the execution time is logged in AWR. Wait events
are…

ianjackson · November 24, 2009, 7:22am

just a suggestion: sometimes in Control Panel / Environment Variables. There is
a PATH in ‘user variables’ that can override the ‘system variables’. I had a
software install include a ‘user variables’ PATH statement.

question … does SQLPLUS work?

Ian

Guest · November 24, 2009, 7:53am

I’m just glad you saw my post

9.0.0 is the original release which had this bug. The bug is fixed in 9.0.1.

Guest · November 25, 2009, 5:20am

“SQLPATH” has nothing with your problems.

With SQLPATH you define default directory for scripts. I.e. when you place:
SQL>@run_me

then if “run_me.sql” is not in directory where sqlplus has been started, Oracle looks for all directories defined with SQLPLATH.

Hope this helps,
Damir Vadas

JohnDorlon · November 30, 2009, 8:38am

There’s no way to do that in Toad right now.

Here is a query that you can use to find some queries running longer than 10
seconds. Then just put that SQL ID into the field in the AWR SQL report.

select stat . snap_id , stat . sql_id , stat . module , stat . action , stat .
parsing_schema_name ,

   stat . elapsed_time_delta / 1000000 / stat . executions_delta

avg_time_in_seconds ,

   text . sql_text

from dba_hist_sqlstat stat , dba_hist_sqltext text

where stat . executions_total > 0

and stat . elapsed_time_delta /* microseconds */ / 1000000 / stat .
executions_delta > 10

and stat . dbid = text . dbid

and stat . sql_id = text . sql_id

dboussebha_123807095 · December 1, 2009, 2:07am

select stat . snap_id , stat . sql_id , stat . module , stat . action , stat .
parsing_schema_name ,

stat . elapsed_time_delta / 1000000 / stat . executions_delta
avg_time_in_seconds ,

text . sql_text

from dba_hist_sqlstat stat , dba_hist_sqltext text

where stat . executions_total > 0

and stat . elapsed_time_delta /* microseconds */ / 1000000 / stat .
executions_delta > 10

and stat . dbid = text . dbid

and stat . sql_id = text . sql_id

HillbillyToad · December 1, 2009, 7:03am

There is a separate forum for Toad for MySQL, but for performance advice, you
can download the free version of Spotlight on MySQL.

Patchanee · February 26, 2011, 8:04am

You might probably fixed your problem already. But I will post this anyway, it might be useful for someone else too.
I just got the same problem. Actually my Toad has been working fine for a long time
and suddenly it stoped working with the same message. And I found out that it conflicts with program Fence by Stardock. After I uninstall Fence, the message is gone. And it works fine.

Patchanee.

KiranJagannath · May 26, 2011, 3:30am

I have the following configurations and I am facing the “You have no Oracle Clients ?Installed” and the “You do not have any Oralce Homes installed” Error:

Windows 7 Professional 64 Bit
Oracle 10g Client
Toad Version 9.6.1.1

Please guide me.

Guest · May 26, 2011, 3:30am

Toad needs the 32 bit client.